Hi all, I am having issue with data connections. I am changing the configuration of the data connection to not perform any caching (real time data), I save the configuration, go to dashboards, and when I get back to the configuration, it is set to caching again.

I tried to replicate this behavior on my data sources and it is working for me. Could you please specify which data source are you using? Also once you save it, could you please check it on the API what is set there? It would be this endpoint (you can also just paste it to your browser):

https://{YOUR_HOSTNAME}/api/v1/entities/dataSources/{DATA_SOURCE_ID}

specifically what is in the “`cacheStrategy`” parameter returned by this API.

Hi @Michal Hauzírek I have tried it now again, still it reverts to: Optimize for speed and savings. "cacheStrategy": "NEVER",

I see, sorry to hear that. Which datasource are you using please (Snowflake, Databricks, Redshift, …)

Azure SQL

Thank you. I was able to replicate this on my end and I believe that is a glitch in the data source UI. The

"cacheStrategy": "NEVER"

on the API should mean “real time data”. I am going to report a bug for this as it is for sure not behaving as it should be. In the meantime, I believe as long as you have

"cacheStrategy": "NEVER"

, the calculations should not use the caching on the back-end. Thank you for reporting this.

Hi @Michal Hauzírek, thanks for the follow up. I have tried it this morning and it works. Once I change the caching and reopen the model dialog it keeps the changes.