When setting up a BigQuery Share you can choose between sharing data to a Single table or Multiple tables.

Single table

This is the recommended way to share your data to BigQuery.

With a 'single table', all data is shared to just one table, partitioned per month.
This requires that the Funnel 'date' dimension is included in the Share.

Having a partitioned single table will reduce the schema and metadata overhead when using multiple tables. This will improve query performance.

Read more about partitioned tables in BigQuery here

Multiple tables

With 'multiple tables', separate tables will be created for each calendar month.

Using 'multiple tables' is also called sharding in BigQuery and has some negative effects, such as schema and metadata overhead for each separate table. In most cases using a single table is the most advantageous way to set up your Share.

Using date-partitioned tables

When using multiple tables we also support partitioning on each individual table, based on date. This requires that the Funnel 'date' dimension is included in the Share.
We recommend using this when possible.

Create BigQuery View

Funnel can also create a view that combines the data in all the monthly tables. This view is called all_funnel_data_view by default and can ease the use of querying the data in all tables from a single point.

Read more about sharding vs partitioning in BigQuery here

Did this answer your question?