Search…
⌃K
Links

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.