Search code examples
google-cloud-sql

How to change CloudSQL global setting


I'm testing apache airflow and I would like to make CloudSQL it's database but for it to work I need to change a global setting called 'explicit_defaults_for_timestamp' on my database.

I would like to know how I can make this change since I don't have SUPER user privilege on CloudSQL.


Solution

  • As Google Cloud SQL is fully managed by Google, you cannot perform actions that requires SUPER user privileges. There is a list of supported flags that you can change without having SUPER user privileges. However, the flag that you are trying to import is not supported in that list, so, sadly you'll be unable to change that global setting.