I have about 25-30 dashboards with 10-15 queries each and I want to switch the existing Datasource (MSSQL) to another one (MYSQL). Most of the queries will also need to be changed due to syntax differences.
Is there any significantly faster way than to go through the dashboards one by one and replacing every query and Datasource?
You can try the JSON view
Find it handy to replace 20 times of A for B etc
But that would be easy for Datasource but Query mightn’t help unless you know to replace table name only and deal with a few other fixes
I find Saving and refreshing the page before editting the JSON in the options much easier as sometimes it fails to work