Run Metabase on Google App Engine.
env_variables
in app.yaml
, especially:
CLOUD_SQL_INSTANCE
MB_DB_NAME
MB_DB_USER
MB_DB_PASS
Given a CloudSQL database name of "foo" you can use the following to get the correct CLOUD_SQL_INSTANCE
value (assuming you have installed and configured the Google Cloud SDK):
gcloud sql instances describe foo --format='value(connectionName)'
gcloud app deploy