Trying to Injest Large CSV Files

Darin Spence 1 Reputation point
2022-11-25T23:41:46.177+00:00

I'm trying to injest data using the Copy Data tool in Synapse Analytics Workspace. The files are 2 large csv files stored on Azure Data Lake Storage Gen2. When I get to the File format settings step and click Next, I get a red message that just says:

File schema is not defined

What am I doing wrong?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,401 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Evgeny Grishchenko 486 Reputation points
    2022-11-26T10:35:26.39+00:00

    Do those files have headers?

    "If your source is text file without header line, explicit mapping is required as the source doesn't contain column names."

    1 person found this answer helpful.