Unable to load csv data with correct header values in External tables

[Frantz]

Hello, is there a way to load "CSV" data into an external table without the _c0, _c1 columns showing?

I've tried using the options within the sql statement that does not appear to work.

Which results in this table

[rt-slowth]

Hi, @Frantz 

Did the source data, s3://nyc-zip-codes.csv, have a header column?
Otherwise, they seem to be represented as _c0, _c1.

[Frantz]

Yes, the source data did have a header column. 

[feiyun0112 · Accepted solution]

you need set "USING data_source"

https://community.databricks.com/t5/data-engineering/create-external-table-using-multiple-paths-loca...