Facing issue while creating Delta Live Table on top of csv file

Manasi_Sarang
New Contributor II

Hello Everyone,

I am trying to create Delta Live Table on top of csv file using below syntax:

CREATE OR REFRESH LIVE TABLE employee_bronze_dlt

COMMENT "The bronze employee dataset, ingested from /mnt/lakehouse/PoC/DLT/Source/."

AS SELECT * FROM csv.`/mnt/lakehouse/PoC/DLT/Source/Employee.csv`;

Table is getting created but headers are appearing as part of data in table as shown below:

imageCan you please let me know what needs to be added in table creation definition to identify first row in data as header?