Teradata to BigQuery: function mapping
1 of 1 common Teradata functions need a change in BigQuery. Mapping table with BigQuery syntax and behavior differences.
Other targets: Teradata to Snowflake · Teradata to Databricks
Needs a rewrite (1)
No BigQuery function with the same behavior; use the construct shown.
| Teradata | BigQuery | Notes |
|---|---|---|
| ZEROIFNULL | Rewrite IFNULL(expr, 0) | COALESCE(expr, 0) is equivalent. NULLIFZERO, the inverse, is also Teradata-specific; Snowflake keeps NULLIFZERO, while Databricks and BigQuery need NULLIF(expr, 0). |