v-vepott's avatar
v-vepott
Icon for Microsoft Employee rankMicrosoft Employee
6 months ago
Status:
New

Lakehouse SQL endpoint table data gets truncated when the data length exceeds 8,000 characters.

Hi,   I created a shortcut table in the Lakehouse where one of the columns has a length greater than 8,000 characters. However, when I reference this shortcut table in Data Warehouse views, the dat...
data engineering
data warehouse
hvdv99's avatar
hvdv99
Frequent Visitor
6 months ago
I've encountered that issued before and know its annoying. My suggestion would be to store the content exceeding 8000 chars as a file and keep a reference to that file in a separate table.

Recent ideas