Teradata to Snowflake: function mapping
0 of 1 common Teradata functions need a change in Snowflake. Mapping table with Snowflake syntax and behavior differences.
Other targets: Teradata to Databricks · Teradata to BigQuery
Works as written (1)
The same call runs, but check the notes for behavior differences.
| Teradata | Snowflake | Notes |
|---|---|---|
| ZEROIFNULL | Same name ZEROIFNULL(expr) | Returns 0 if the argument is NULL, otherwise the argument. NULLIFZERO, the inverse, is also Teradata-specific; Snowflake keeps NULLIFZERO, while Databricks and BigQuery need NULLIF(expr, 0). |