New Google BigQuery exports send all data to a single table, partitioned per month. Single table is the default table option.
Note: Multiple tables are no longer available for new exports. Since February 11, 2026, you can't create a new export with Multiple tables. Exports that already use multiple tables keep working as before. If you need a new multiple-table export, contact Funnel Support.
Single table
All data is exported to one table, partitioned per month. The Funnel Date dimension must be included in the export.
A partitioned single table has less schema and metadata overhead than many separate tables, which improves query performance. This is the recommended setup.
Multiple tables (existing exports only)
Older exports may use Multiple tables, where Funnel creates a separate table for each calendar month. This is also called sharding in BigQuery. Each table adds schema and metadata overhead, so a single table is the better choice in most cases.
For these exports:
Each monthly table can also be partitioned by date. This requires the Funnel Date dimension in the export.
Funnel can create a view that combines all monthly tables, called
all_funnel_data_viewby default. See Google BigQuery export: Create a view.