Tonic differences and limitations with Google BigQuery
Google BigQuery is only available with a Professional or Enterprise license.
Post-job scripts run inside of transactions. They are limited to statements that are supported within transactions.
Google BigQuery workspaces cannot use the following table modes:
- Scale
- Incremental
Google BigQuery workspaces cannot use the following generators:
- Cross Table Sum
Tonic cannot process STRUCT types in Google BigQuery.
If a column has a STRUCT type, you can either:
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.