This message was deleted.

Thanks for bringing this up! So BigQuery can be used just like a db in this example if you use an ODBC/JDBC connection. You can use it securely in a similar manner to the blog (keyring). Any thoughts?

Hey @Ido (Ploomber), thanks for the response! I'm currently using sqlalchemy and the following code to connect to BigQuery:

engine = create_engine(
    "bigquery://",
credentials_path="bigquery_credentials.json",
)

The json file has 10 key:value pairs. I'm not sure how to proceed from here in storing the credentials securely and whether keyring is appropriate for this use case? At first glance, keyring looks to be storing username and password pairs?

Got it, so you can use the get_credential() function, it allows you to store a full credential object for that matter that way you can store the full json and consume it. You can also use other ways to connect to it, like with drivers, or a private key.