I have a query that is running a select statement against Postgres and after I update some data and run the query again, some of the updated data is not displaying the results from the Retool query but if I query Postgres directly with the same exact query the updated values are there. I do no have caching enabled and have also called the invalidateCache() function but still do not see the updated values in the Retool query. I have also noticed that after a period of time, the updated values eventually are returned by the Retool query which leads me to believe there is some caching occurring somewhere in the Retool layer.
Has anyone else experienced this or have any tips on how to resolve this? Thanks!