When running airflow using cloudsql, I get the expected error:

Exception: Global variable explicit_defaults_for_timestamp needs to be
on (1) for mysql

With cloudsql, that flag cannot be set:


$ gcloud sql instances patch $instance --database-flags
explicit_defaults_for_timestamp=1

The following message will be used for the patch API method.

{"project": "xxxxxx-xxxxx-xxx", "name": "xxxxxxxxxxxxxxx", "settings":
{"databaseFlags": [{"name": "explicit_defaults_for_timestamp",
"value": "1"}]}}

ERROR: (gcloud.sql.instances.patch) HTTPError 404: Flag requested cannot be set


Are there any recommendations for dealing with this?

Reply via email to