Direct Query - Data Referesh Tab : AWS Quicksight

You can refer to the following article about your problem

https://docs.aws.amazon.com/quicksight/latest/user/refreshing-data.html

You can use SPICE Data instead and you can refresh SPICE

or

you could create a workaround by adding an additional field to your Redshift table that contains the timestamp of the last update. This could be a single row table that you update with the current timestamp whenever you update the rest of your data. Then, you could include this field somewhere on your QuickSight dashboard.

CREATE TABLE last_update (update_time TIMESTAMP);

-- Then, whenever you update your data:
UPDATE last_update SET update_time = CURRENT_TIMESTAMP;

Then, in your QuickSight analysis, you could add a visual that pulls in this update_time value and displays it as a KPI or in a single-value visualization.