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

[v-vepott]

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 data in that column gets truncated. How can this issue be resolved?

Thanks,

Venkat

[hvdv99]

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.