Home / SQL Server
SQL Server functions in Snowflake, Databricks and BigQuery
SQL Server functions and syntax with their Snowflake, Databricks and BigQuery equivalents: CHARINDEX, CONVERT, DATEADD, DATEDIFF, EOMONTH, GETDATE, IIF, ISNULL, LEN, STRING_AGG, STUFF, TOP.
Checklists: SQL Server to Snowflake · SQL Server to Databricks · SQL Server to BigQuery
NULL handling
| Function | Purpose | Snowflake | Databricks | BigQuery |
|---|---|---|---|---|
| ISNULL | Replace NULL with a value | Different name | Different name | Different name |
Conditional logic
| Function | Purpose | Snowflake | Databricks | BigQuery |
|---|---|---|---|---|
| IIF | Inline if-then-else | Different name | Different name | Different name |
Date and time
| Function | Purpose | Snowflake | Databricks | BigQuery |
|---|---|---|---|---|
| DATEADD | Add an interval to a date | Same name | Same name | Rewrite |
| DATEDIFF | Difference between two dates | Same name | Same name | Rewrite |
| EOMONTH | Last day of the month | Rewrite | Rewrite | Rewrite |
| GETDATE | Current date and time | Same name | Same name | Rewrite |
String
| Function | Purpose | Snowflake | Databricks | BigQuery |
|---|---|---|---|---|
| CHARINDEX | Position of a substring | Same name | Same name | Rewrite |
| LEN | Length of a string | Same name | Same name | Different name |
| STUFF | Replace part of a string | Different name | Different name | Rewrite |
Aggregate
| Function | Purpose | Snowflake | Databricks | BigQuery |
|---|---|---|---|---|
| STRING_AGG | Concatenate values of a group | Different name | Same name | Same name |
Conversion and formatting
| Function | Purpose | Snowflake | Databricks | BigQuery |
|---|---|---|---|---|
| CONVERT | Convert type, with date style codes | Rewrite | Rewrite | Rewrite |
Query syntax
| Function | Purpose | Snowflake | Databricks | BigQuery |
|---|---|---|---|---|
| TOP | Limit the number of rows | Same name | Rewrite | Rewrite |