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:
Can you please let me know what needs to be added in table creation definition to identify first row in data as header?