'How to handle unexpected data length in Azure Synapse?
How do I handle a column with unexpected data length in Azure synapse like we have in SQL server VARCHAR(MAX) what data type should I use in synapse?
Solution 1:[1]
In synapse you cannot have varchar(max) while you are using { CLUSTERED COLUMNSTORE Ip put Therefore we need to use heap instead of clusted columnstore index { | HEAP }}
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Ramesh |