Home / Redshift
Redshift functions in Snowflake, Databricks and BigQuery
Redshift functions and syntax with their Snowflake, Databricks and BigQuery equivalents: APPROXIMATE COUNT(DISTINCT), CONVERT_TIMEZONE, DATEDIFF, GETDATE, JSON_EXTRACT_PATH_TEXT, LISTAGG, MEDIAN, SPLIT_PART.
Checklists: Redshift to Snowflake · Redshift to Databricks · Redshift to BigQuery
Date and time
| Function | Purpose | Snowflake | Databricks | BigQuery |
|---|---|---|---|---|
| CONVERT_TIMEZONE | Convert a timestamp between time zones | Same name | Same name | Rewrite |
| DATEDIFF | Difference between two dates | Same name | Same name | Rewrite |
| GETDATE | Current date and time | Same name | Same name | Rewrite |
String
| Function | Purpose | Snowflake | Databricks | BigQuery |
|---|---|---|---|---|
| SPLIT_PART | Nth part of a delimited string | Same name | Same name | Rewrite |
Aggregate
| Function | Purpose | Snowflake | Databricks | BigQuery |
|---|---|---|---|---|
| APPROXIMATE COUNT(DISTINCT) | Approximate distinct count | Rewrite | Rewrite | Rewrite |
| LISTAGG | Concatenate values of a group | Same name | Same name | Different name |
| MEDIAN | Median of a group | Same name | Same name | Rewrite |
Conversion and formatting
| Function | Purpose | Snowflake | Databricks | BigQuery |
|---|---|---|---|---|
| JSON_EXTRACT_PATH_TEXT | Extract a value from a JSON string | Different name | Rewrite | Rewrite |