Cannot insert NULL into nullable column in Synapse Analytics

Adam Eljasiak 1 Reputation point
2022-08-03T12:11:13.627+00:00

Nullability constraints do not behave as expected in our Synapse Analytics data warehouse. All columns in all tables are nullable, and primary keys are not enforced as described here, yet sometimes we get errors like "Cannot insert the value NULL into column \

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.
5,172 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.