Azure Synapse Analytics
Translation specification for Azure Synapse Analytics Tables
Description
This section presents the translation for syntax specific to Azure Synapse Analytics Tables.
For most patterns, check the translation specification for general tables, as they share almost the same syntax and behavior.
Sample Source Patterns
WITH table options
Azure Synapse Analytics presents an additional syntax for defining table options.
Snowflake automatically handles table optimization through mechanisms like micro-partitioning. For this reason, an equivalent syntax for some of these table options does not exist in Snowflake. Therefore, it is not necessary to define some of Transact's table options.
Table options that will be omitted:
CLUSTERED COLUMNSTORE INDEX (without column)
HEAP
DISTRIBUTION
PARTITION
CLUSTERED [ COLUMNSTORE ] INDEX
with columns, will be transformed to Snowflake's CLUSTER BY
. A performance review PRF will be added as it is advised to check if defining a CLUSTER KEY is necessary.
Transact
Snowflake
Known Issues
No issues were found.
Related EWIs
SSC-PRF-0007: PERFORMANCE REVIEW - CLUSTER BY.
Last updated