https://community.databricks.com/t5/get-started-discussions/unable-to-load-csv-data-with-correct-header-values-in-external/m-p/59533#M6462 <P>Hi,&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/99423">@Frantz</a>&nbsp;<BR /><BR /></P><P>Did the source data, s3://nyc-zip-codes.csv, have a header column?<BR />Otherwise, they seem to be represented as _c0, _c1.</P> Wed, 07 Feb 2024 02:15:28 GMT rt-slowth 2024-02-07T02:15:28Z https://community.databricks.com/t5/get-started-discussions/unable-to-load-csv-data-with-correct-header-values-in-external/m-p/59528#M6461 <P>Hello, is there a way to load "CSV" data into an external table without the _c0, _c1 columns showing?</P><P>I've tried using the options within the sql statement that does not appear to work.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Frantz_0-1707258246022.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/6132iF502ECDA58EB81FE/image-size/medium/is-moderation-mode/true?v=v2&amp;px=400" role="button" title="Frantz_0-1707258246022.png" alt="Frantz_0-1707258246022.png" /></span></P><P>Which results in this table</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Frantz_1-1707258264972.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/6133iD9BEFBB946ACCD58/image-size/medium/is-moderation-mode/true?v=v2&amp;px=400" role="button" title="Frantz_1-1707258264972.png" alt="Frantz_1-1707258264972.png" /></span></P><P>&nbsp;</P> Tue, 06 Feb 2024 22:24:41 GMT https://community.databricks.com/t5/get-started-discussions/unable-to-load-csv-data-with-correct-header-values-in-external/m-p/59528#M6461 Frantz 2024-02-06T22:24:41Z https://community.databricks.com/t5/get-started-discussions/unable-to-load-csv-data-with-correct-header-values-in-external/m-p/59533#M6462 <P>Hi,&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/99423">@Frantz</a>&nbsp;<BR /><BR /></P><P>Did the source data, s3://nyc-zip-codes.csv, have a header column?<BR />Otherwise, they seem to be represented as _c0, _c1.</P> Wed, 07 Feb 2024 02:15:28 GMT https://community.databricks.com/t5/get-started-discussions/unable-to-load-csv-data-with-correct-header-values-in-external/m-p/59533#M6462 rt-slowth 2024-02-07T02:15:28Z https://community.databricks.com/t5/get-started-discussions/unable-to-load-csv-data-with-correct-header-values-in-external/m-p/59537#M6463 <P>you need set "<SPAN class="">USING</SPAN> <SPAN class="">data_source"</SPAN></P><P><A href="https://community.databricks.com/t5/data-engineering/create-external-table-using-multiple-paths-locations/td-p/44042" target="_self">https://community.databricks.com/t5/data-engineering/create-external-table-using-multiple-paths-locations/td-p/44042</A>&nbsp;</P> Wed, 07 Feb 2024 03:35:18 GMT https://community.databricks.com/t5/get-started-discussions/unable-to-load-csv-data-with-correct-header-values-in-external/m-p/59537#M6463 feiyun0112 2024-02-07T03:35:18Z https://community.databricks.com/t5/get-started-discussions/unable-to-load-csv-data-with-correct-header-values-in-external/m-p/59616#M6464 <P>Yes, the source data did have a header column.&nbsp;</P> Wed, 07 Feb 2024 17:37:04 GMT https://community.databricks.com/t5/get-started-discussions/unable-to-load-csv-data-with-correct-header-values-in-external/m-p/59616#M6464 Frantz 2024-02-07T17:37:04Z