Connect a Google BigQuery table or view to Funnel to import its data. Each connection imports one table or view from one dataset and project.
Before you begin
You have a Business or Enterprise plan in Funnel.
You have the required project roles and permissions in BigQuery. If you don't have access to a BigQuery project, contact your project administrator.
You understand the difference between BigQuery tables and views. For more information, see Google's BigQuery documentation.
BigQuery computes costs based on whether your tables are partitioned by date. For more information, see Optimize query computation and BigQuery pricing.
Best practices for managing BigQuery costs
Always partition tables by date in BigQuery.
Avoid importing a view unless you understand the pricing structure.
Monitor query costs in the BigQuery console.
Preview the table in BigQuery to check estimated bytes.
Work with your data team to restructure large datasets where needed.
For more details, see Optimize query computation and BigQuery pricing.
Connect Google BigQuery to Funnel
Select your credentials
In the left menu, go to Data > Connect > Data sources, and click + Connect data source.
Search for Google BigQuery in the search bar, and click Connect now.
In the Select Credentials section, select your BigQuery account credentials so that Funnel can download your data. If you select a credential you already added, skip to Choose the data to import. To add a new credential, choose one of these options:
Continue with Google: You're redirected to a screen where you confirm the Google account you want to use.
Connect a service account: Enter your Google service account JSON and click Next.
Note: The rest of these steps use a Google account.
Click Continue to confirm the account.
Review the access permissions for the Funnel Connector, and click Allow.
Choose the data to import
Select a project, and click Next. You can select only one project per connection. To add another project as a data source, create another connection.
Select a dataset, and click Next. You can select only one dataset per connection. To add another dataset as a data source, create another connection.
Note: You may see additional compute pricing costs in BigQuery if you select a view. Because a view is defined by a SQL query, it may contain more than one table, and this may lead to more frequent data downloads than when you select a table.
In the Fields section, select the columns and fields you want to import.
Configure the import
If your data has columns with a monetary unit, select a currency for all your data, or select a column that specifies a currency in its rows. When you choose Select a field containing the currency, the drop-down list shows the columns with a string value. This section is greyed out if your data doesn't have any columns with a monetary unit.
If your data has columns with a date unit, select how Funnel should fetch and store your BigQuery data. This section is greyed out if your data doesn't have any columns with a date unit. You have these options:
Date by daily date: Select a column that has a date unit. The drop-down list only shows columns with a date value.
Dateless: Select this option if you want Funnel to fetch data with no date mapping. If you import large tables, the costs may be high because BigQuery scans the entire table. For best practices to optimize your query performance, see Optimize query computation.
Note: The computing costs depend on the option you select. To understand the cost expectations, see Factors affecting BigQuery computing costs below.
In the Download Configuration section, select values for these fields:
How often should Funnel download your data?: Select an option from the drop-down list. You can download data at hourly frequencies or every day.
How much historic data would you like?: Available only if you selected Date by daily date. Select the date from which Funnel should start downloading data.
How much historic data should be refreshed with each download?: Available only if you selected Date by daily date. Enter the number of days for which Funnel should refresh historical data. The days are counted backwards from the current day.
For example, today's date is 28 May 2025 and you enter these values:
How often should Funnel download your data? Every day
How much historic data would you like? 1 Apr 2025
How much historic data should be refreshed with each download? 3
Funnel then refreshes historical data only for today and the last two days, which is from 26 May 2025.
Note: The computing costs depend on the option you select. To understand the cost expectations, see Factors affecting BigQuery computing costs below.
Click Next.
Review the configuration summary, and click Connect data source.
What to expect
Funnel adds the data source and starts importing data from your table or view, using the download frequency and historical data settings you chose.
Manage your connection
Reconnect: If the connection breaks, click the warning icon on the data source and follow the re-authentication steps.
Pause or delete: Go to Data > Connect > Data sources, click the three-dot menu, and select Pause or Delete.
Factors affecting BigQuery computing costs
When you import data from a Google BigQuery data source to Funnel, you may see additional compute costs based on your configuration settings. These configurations affect the costs:
How you create a table or view in BigQuery
The options you select in the Date mapping and Download Configuration sections in Funnel
Here's how different combinations of these factors may affect the costs:
Connection configurations in Funnel | Table partitioned by date in BigQuery? | What happens in BigQuery and in Funnel | BigQuery cost expectations |
Date mapping: Date by daily date | Yes | BigQuery scans only the relevant partitions. | Query cost is optimized |
Date mapping: Date by daily date | No, but has a date column | BigQuery scans the entire table because there's no partitioning in the table, leading to higher costs. | May lead to higher costs |
Date mapping: Date by daily date | Mixed partitioning (if you select a view combining different types of tables) | BigQuery tries to optimize, but if the unpartitioned table is part of a JOIN or UNION, the entire table may be scanned. | May lead to higher costs |
Date mapping: Dateless | Not applicable | Funnel doesn't limit by time, and downloads the entire table during every run. | May lead to higher costs |
Troubleshooting
"Internal error" when selecting a project or table
If you see an Internal error message when Funnel lists your BigQuery projects or tables, your Google authorization has most likely expired or been revoked. Funnel doesn't check the credential when you select it. It first uses the credential to list your BigQuery projects, so an authorization problem shows up at that step.
To fix the error:
In the Select Credentials section, remove the existing Google credential.
Click Continue with Google and complete the full Google consent screen.
Sign in with a Google account that's active in your Google Workspace and has at least the BigQuery Data Viewer role on the project.
Continue the setup and check that your projects and tables load.
Note: Authorization is per Google user. A colleague's working credential doesn't fix an expired authorization on your account. Reconnect with your own active account.
If the error comes back, ask your Google Workspace admin to trust the Funnel app or review your organization's session-length policy.

