Connecting to BigQuery with Streamlit

The first step to getting BigQuery connected to your Streamlit app is to gather the authentication information necessary from BigQuery. There is a wonderful Quickstart doc that Google keeps (and maintains!) that you should follow, which can be found here: https://cloud.google.com/bigquery/docs/quickstarts/quickstart-client-libraries. This link will help you sign up for a free account, and create a project. After you create your project, you need to create a service account (https://console.cloud.google.com/apis/credentials) and download the credentials as a JSON file. Once you have this file, you have all the data needed and can return to this chapter.

For this section, we will create a new file in our database_example folder called bigquery_app.py, and we will add a new section to the secrets.toml file we already created. First, we can add to the secrets.toml file and finally, let you create and view your service account credentials using...