In order to be able to make use of Datalore, I’d need to be able to access a number of SQL servers.
In our case, the SQL servers are in Google Cloud SQL.
To connect to Google Cloud SQL, we need to either run a proxy in datalore, or whitelist ip addresses and set up a public ip address on Cloud SQL.
Using the proxy makes a lot more sense, and there seems to be some ability to run the proxy from python (https://github.com/GoogleCloudPlatform/cloud-sql-python-connector)
However, we need to be able to use either an ssh key or a google cloud credentials file in order to set up any proxy, and Datalore secrets seem to only support a limited number of characters.
We don’t want to store secrets in a git repository, and we don’t want to have to upload a secret file for each notebook.
Is there any way we could use Cloud SQL or add secret files?