Is There is Any Control/Way to Dynamically Change Database and Username?

I'm using MySQL 
This is how i connect to the database:

axonide_1-1725680208495.png

 

As you can see on the screenshoot above, database and username is gfan_smg1 and i have other database like gfan_smg2, gfan_smg3, etc others 30+ databases.

All the query used on the report is the same, it's just the database name that is different.

So is it possible to dynamically change the database and username? 

Because if not, i have to re-edit all the queries and reports everytime an update occurs.

1 REPLY 1

This is possible in Looker using user attributes in the connection panel, but I don't think this is possible in Looker Studio. I recommend creating a feature request!