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

Frantz
New Contributor III

‎02-06-2024 02:24 PM

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.

Frantz_0-1707258246022.png

Which results in this table

Frantz_1-1707258264972.png

 

0 Kudos

rt-slowth
Contributor

‎02-06-2024 06:15 PM

Hi, @Frantz 

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

0 Kudos

Frantz
New Contributor III
In response to rt-slowth

‎02-07-2024 09:37 AM

Yes, the source data did have a header column. 

0 Kudos