Hello Team, I wanted to know how often the data on...
# gooddata-cloud
m
Hello Team, I wanted to know how often the data on any given dashboard is refreshed? Or updated from the database? Some of our visualizations have data that is not completely synced with the database currently and I would like to know how to fix that. Also, for realtime reporting, the refresh rate should be higher so is there any way I can change this? Thanks
m
Hi Maria, to help us understand why your GoodData dashboards might be showing delayed data, could you tell us which data source you're using (example Redshift?), where specifically you're seeing the delay in GoodData (e.g., a certain visualization), and if you have an example of data that's out of sync? This will help us quickly figure out if the issue is with the data source's refresh rate, the connection to GoodData, or something else.
m
We are using postgres as the datasource and a few examples of the out of sync visuals are: "Number of Donations" on the Income Overview dashboard and in "Donations by type", the Regular Donations figure is out of sync. They're not extremely out of sync but a few of the numbers are slightly off.
m
Hi Maria - I think you might be seeing cached data from previous executions. If data in your underlying data source change, you should invoke uploadNotification API (there are several ways how to do it - either raw API call or python SDK or manually in the datasource UI): https://www.gooddata.com/docs/cloud/connect-data/cache-management/reload-cached-data/#invalidate-cached-data I do not think there is currently a way how to define a cache validity timeout at the moment that would empty the cache automatically after some period of time. You could also completely disable the caching on the data source level (by setting it to DirectQuery) - then every time you query the data, the cache will be skipped and you will get result directly from the source database. https://www.gooddata.com/docs/cloud/connect-data/cache-management/
m
Hi Maria, I would like to know if you had the chance to check the Michal's comment. Please, let us know if you still need more assistance.
m
Thank you Michal, I will be looking into this. And thank you for the follow up, I will let you know if any further assistance is required.