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?