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

 

Thanks,

Venkat

data engineering
data warehouse

1 Comment

  • hvdv99's avatar
    hvdv99
    Frequent Visitor
    5 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