Google BigQuery integration is similar to GoogleSheets. To start, click “Create New Flow” and select Google BigQuery as the primary input. This will take you to the Project Selection page, which will be empty. Select 'Connect Dataset' to begin connecting Google BigQuery.
This will trigger a dialog box to sign in with your Google account connected to your BigQuery instance.
To use the integration, you'll need to give the required scopes. Read the information carefully before clicking allow.
Once your account is connected, you can select your project and bring in datasets.
Due to the structure of Google BigQuery, there are a few layers to getting to what we would consider the dataset. With the project selected, you will select the BigQuery dataset.
This contains a collection of tables (the datasets the flow will be able to interact with).