Tonic differences and limitations with Google BigQuery

Google BigQuery is only available with a Professional or Enterprise license.
Post-job scripts run in transactions
Post-job scripts run inside of transactions. They are limited to statements that are supported within transactions.
Table mode limitations
Google BigQuery workspaces cannot use the following table modes:
Scale
Incremental
Generator limitations
Google BigQuery workspaces cannot use the following generators:
Cross Table Sum
Cannot process STRUCT types
Tonic cannot process STRUCT types in Google BigQuery.
If a column has a STRUCT type, you can either:
Assign the Null generator to the column.
Assign the Truncate table mode to the table.
No subsetting, but support for table filtering
Google BigQuery workspaces do not support subsetting.
However, for tables that use the De-Identify table mode, you can provide a WHERE clause to filter the table. See Using table filtering for data warehouses and Spark-based data connectors.

Last modified 14d ago