Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

8000 Character limit SQL Endpoint For Lakehouse Fabric

Hi! We saw this blog post.  https://blog.fabric.microsoft.com/en-us/blog/working-with-large-data-types-in-fabric-warehouse/   It mentioned expanding capabiltiy of fabric warehouse to handle varch...
data engineering
lakehouse
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

 

This update allows you to use Fabric Lakehouse's SQL endpoint on fields larger than 8,000 characters.The introduction of the VARCHAR(MAX) and VARBINARY(MAX) types allows for storing larger data, such as text in JSON format, without truncation issues.

 

However, there may still be some ongoing tweaks and improvements after the update, so please feel free to contact community support if you need help.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

  • prabhatnath's avatar
    prabhatnath
    Advocate III
    1 year ago

    Thanks @v-huijiey-msft for your response.
    I am also exploring similar solution. I am not sure how do I save more than 8000 chars inside a table column? Are there VARCHAR(MAX) and VARBINARY(MAX)  column types supported in Lakehouse table. Can you please point me to some reference / documentation please?

    For now I have stored my large text (about 9000 chars) data in a String column but unable to pull the same using the Endpoint as the endpoint only gets me 8000 chars. Can you help on this please?

    Thanks,
    Prabhat