Forum Discussion
Solved
Parquet file to delta table using Notebooks: Issue with Datetime column
I have parquet file in lakehouse with the below columns. When I try to save the file as lakhouse table I am getting error with the date field. Please suggest if any solution available? Also date colu...
The error happens because the TIMESTAMP_NTZ type (timestamp without time zone) doesn’t work with Lakehouse tables in Fabric when using Delta format.
To fix it, change the date column to a supported type like DATE or normal TIMESTAMP before saving.
If the column type isn’t supported, it won’t show up in SQL after saving — but converting it will fix that and make it visible.
The error happens because the TIMESTAMP_NTZ type (timestamp without time zone) doesn’t work with Lakehouse tables in Fabric when using Delta format.
To fix it, change the date column to a supported type like DATE or normal TIMESTAMP before saving.
If the column type isn’t supported, it won’t show up in SQL after saving — but converting it will fix that and make it visible.