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