Use this connector to have Foundational scan and determine lineage and data quality for BigQuery.
This setup should take about 15 minutes.
Permissions: You need to be a Google Cloud admin for some parts of this setup.
Go into the IAM & Admin page of your Google Cloud account
Select “Service Accounts” in the left menu, and then select the relevant Google Cloud project
Create a new Service Account
Fill in the account details
Select a name (Can be any name you'd like)
Select the BigQuery Metadata Viewer and BigQuery Resource Viewer as the role for the account
For advanced data monitoring features, such as NULL checks, also assign "BigQuery Data Viewer" and "BigQuery Job User" role to the account
Note: This is purely optional, and if you don't need data monitoring features that check the actual underlying data, then you don't need to provide these permissions.
Click Done to save the account
Now that the new account is created, select it from the Service Accounts page
Next, we need to add a key to the account. Click on the Keys tab, and then on the Add Key button
Create a new key
Select JSON as the Key type and click Create
To finish the setup in Foundational, download the newly created key to your local machine and then upload it to the BigQuery configuration panel in Foundational.