Create External SQL Table - Failed to Detect Schema

Question

This is the first time I have come across this issue. I put a CSV file in our storage and then try to create an external table. Here is the error I get:

Answer 1

You can define the schema manually during the table creation :

CREATE EXTERNAL TABLE [your_table_name] (
    Column1 INT,
    Column2 NVARCHAR(50),
    Column3 DATETIME
    -- Add more columns as required
)
WITH (
    LOCATION = '/path/to/csv/file',
    DATA_SOURCE = [your_external_data_source],
    FILE_FORMAT = [your_file_format]
);

Here is an old thread : https://learn.microsoft.com/en-us/answers/questions/1367973/how-to-fix-failed-to-detect-schema-error-when-impo