Setup takes about 15 minutes.
Introduction
Use this connector to allow Foundational to scan BigQuery metadata and determine lineage and data quality.
To make the connection, you need to:
Create a Google Cloud service account and assign roles
Create and download a JSON service account key
Upload the key to Foundational to make the connection
Prerequisites
Ensure you have:
Google Cloud administrator access for parts of this setup
Access to the Google Cloud project that contains your BigQuery resources
Added Foundational IP addresses to the allowlist, see the article Allowing IP access to Foundational.
Access permissions
The permissions you assign to Foundational enable it to:
Read BigQuery metadata
Determine lineage
Optional: If you want data monitoring features such as NULL checks, grant Foundational access to read underlying data.
Create a service account and assign roles
In Google Cloud, open the IAM & Admin page and select Service Accounts.
Select the relevant Google Cloud project and click Create service account.
The Create service account screen opens.
Enter the details:
Service account name: foundational-reader
Service account ID: foundational-reader
On the same screen, click Create and continue.
The Grant this service account access to project screen opens.
Add the roles:
(Optional) Add additional roles: Assign two additional roles only if you want Foundational to have access to advanced data monitoring features, such as NULL checks:
BigQuery Data Viewer
BigQuery Job User
To save, click Done.
Create a service account key
From the Service Accounts page, select the newly created service account.
At the next screen, select the Keys tab (#1) and then open the ADD KEY dropdown (#2).
Select Create new key.
Select JSON as the key type and click Create.
Download the key and save it. You’ll need it to set up the connection.
Connect Foundational to BigQuery
In Foundational, open the Connectors & Integrations page.
In Warehouses, select the BigQuery card and click Connect.
Click Add Project.
The initial setup screen opens. Click Start Setup.
The Set Up New Connection screen opens.
Upload the JSON file you saved earlier.
Click Next.
The final setup screen opens. To complete the connection, click Save.
That’s it. Foundational is now connected to BigQuery.