[google-cloud-sql-discuss] Automating Google SQL queries in Cloud Shell

Hi!

I have a project which requires me to automate a select statement on a Google SQL database and FTP the result to a client.  It seems like the only way to connect through Cloud Shell is via "gcloud beta sql connect my-instance --user=readOnlyUser".  This then prompts for a password and I can perform queries through the command line.  What's the best way to safely (and securely) automate this process so I can run a query once an hour through Cron?

Thanks,

Mike

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/25467919-bd6f-415c-ba0d-b9fb48099e0d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.