SQL translator › BigQuery → T-SQL
BigQuery to SQL Server translator
BigQuery project.dataset.table becomes [schema].[table]. SAFE_CAST is TRY_CAST.
Usual swaps
| BigQuery | SQL Server |
|---|---|
| LIMIT | TOP / OFFSET FETCH |
| SAFE_CAST / SAFE_CONVERT | TRY_CAST / TRY_CONVERT |
| IFNULL / COALESCE | ISNULL / COALESCE |
| CURRENT_DATE() | CAST(GETDATE() AS date) |
| DATE_SUB / DATE_ADD | DATEADD |
| QUALIFY | subquery |
| INT64 / FLOAT64 / STRING | bigint / float / nvarchar |
| backticks | [brackets] |
| || / CONCAT | CONCAT |
ARRAY and STRUCT become a child table or OPENJSON. Do not flatten those with REPLACE.
Then write it on a ticket
Monday is free. A colleague asks, you type, we mark it.
Clock in free