This is about table creation in synapse's dedicated sql pool.

NishimuraChinatsu-9854 756 Reputation points
2023-02-08T05:14:36.4666667+00:00

This is about table creation in synapse's dedicated sql pool.

Regarding the role of the primary key in synapse's dedicated sql pool, it is stated that "PRIMARY KEY is only supported when both NONCLUSTERED and NOT ENFORCED are in use." The following is a description of the Is there actually any benefit to a primary key in a DEDICATED SQL POOL in SYNAPSE?

I am thinking of migrating data from MYSQL to synapse's dedicated sql pool. Please let me know for reference.

Translated with www.DeepL.com/Translator (free version)

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,356 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 29,886 Reputation points MVP
    2023-02-08T06:30:31.6+00:00

    User's image

    normal benefits of Primary Key