How to Import BigQuery Saved Queries into ContextFlo

Import your existing BigQuery saved queries into ContextFlo with a few clicks. This guide covers permissions setup, selecting queries, and keeping them in sync.

March 1, 2026•2 min read•ContextFlo Team

Before You Start

✓A BigQuery datasource already connected in ContextFlo (see our BigQuery setup guide if you haven't done this yet)
✓Saved queries in your BigQuery project (these are the queries you'll be importing)
✓Admin access in your ContextFlo workspace

Step 1: Open BI Integrations

Navigate to BI Integrations and click BigQuery Saved Queries.

Step 2: Grant Dataform Permissions

If you see "No saved queries found", your service account needs the Dataform Viewer role.

Copy the service account email shown on the integration page
In GCP Console, go to IAM & Admin → Grant Access, paste the email, and assign Dataform Viewer
Go back to ContextFlo and click Retry (IAM changes can take up to 60 seconds)

Step 3: Select and Import

Select the queries you want (or use Select All). Already-imported queries show an Imported badge.
Click Import. Re-importing updates the existing query with the latest SQL — no duplicates.
Click View imported queries to see them in your workspace.

Keeping Queries in Sync

Changes in BigQuery don't auto-sync. To update, go back to BI Integrations → BigQuery Saved Queries, select the queries, and re-import. Use Select All → Import to bulk-refresh everything at once.

Questions? Reach out at [email protected]