Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

v-vepott

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

Submitted by Microsoft Employee on ‎03-05-2026 04:04 PM

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

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
hvdv99
Frequent Visitor
‎03-09-2026 02:04 AM
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.