I have a question about serverless external tables

NishimuraChinatsu-9854 756 Reputation points

Why can't NOT NULLs be used in serverless external tables?

NOT NULL is not allowed for external table columns.

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.
3,810 questions
0 comments No comments
{count} votes

Accepted answer
  1. Suba Balaji 10,021 Reputation points


    In synapse while we create an external table with a primary key, we need to mention as non clustered and not enforced.

    Please check this SO thread which discusses the same issue.

    Hope it helps.

    0 comments No comments

0 additional answers

Sort by: Most helpful