Forum Discussion
How to query varchar >8000 length with SQL analytics endpoint
Hi! Unfortunately, there are limitations. so, the only way is to split it. I was raising a ticket to the support team, but my case differed. I had a wide table with 1k columns, so the total number of values was more than 8k, so I was even unable to create table. Despite having delta table created, it was not appearing in endpoint
"So, when a delta table is created in Fabric Lakehouse, in background, the service will create a similar table in SQL endpoint. (which will be read only mode).
So, this operation is a SQL operation (so SQL supports only 8000 characters in a column) ". Here is the reply text
Thanks for using Microsoft Fabric Community.
I found a similar thread on the forum which might help you.
Thread link : Solved: Ingesting Varchar(MAX) to datawarehouse failure - Microsoft Fabric Community
I hope this information helps.
Thank you.
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond back with the more details and we will try to help.
Thank you.
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.Thank you.