Cards on metabase show correct data. However when the data is downloaded, it is pre-dated data - probably from a cache.
I currently use Metabase v0.40.1. Below is a reproducible example
SELECT *,CURRENT_DATE AS execution_date FROM table1 a LEFT JOIN table2 b ON a.id = b.foreign_id
In the UI, the correct result is shown (still facing cache issues regularly but that can be handled by changing just one line in the query and running again or refreshing) but when the data is downloaded(CSV,JSON or xlsx), the data in the downloaded file does not correspond with the data in the UI. However, the execution_date field alone is correctly populated with the current date. Have tried a lot of ways(refreshing webpage, restarting browser, etc.) to handle this issue but nothing is currently working. The issue just resolves itself after a couple of tries/minutes.
Any ideas on how I can work around this issue would be much appreciated.