Share via

Azure Sql external table column length issue

SriramM-7113 1 Reputation point
2021-12-21T11:43:07.363+00:00

I have csv file in data lake with text Column length 6000, I have to create an external table in azure sql to read the csv file data. While creating external table, nvarchar(max) / varchar( max) are not allowed in external table and I can define column length only up to 4000. Can some please help me to Resolve this issue.?

Azure SQL Database
Azure SQL Edge
Azure SQL Edge

An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 35,506 Reputation points MVP Volunteer Moderator
    2021-12-21T16:08:24.56+00:00

    As a workaround a normal Azure Data Factory copy activity will import the CSV without any problem to Azure SQL and you can put the 16,000 column length data into a NVARCHAR(max) as destination on Azure SQL. Quick and simple.

    Was this answer helpful?

    0 comments
  2. SriramM-7113 1 Reputation point
    2021-12-21T11:53:44.91+00:00
    • source file column length is 16000 ( not 6000)

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.