Error writing data to Lakehouse Table Eventstream

[bw_chec]

Hi,

I have a basic eventstream with an input from EventHub, manage Fields to rename columns, then write to an existing Lakehouse table.

The schema of the lakehouse table contains timestamp fields, and the data preview in Manage Fields shows the fields as datetime.

Lakehouse schema: 

Manage Fields Output:

I am getting the following error when writing to lakehouse.

"First Occurred: 2/12/2025 11:14:40 AM UTC | Resource Name: dst-BronzeLH | Message: Source 'dst-BronzeLH' had 1 occurrences of kind 'OutputDataConversionError.TypeConversionError' between processing times '2025-02-12T11:11:32.0625873Z' and '2025-02-12T11:14:40.6506983Z'

All help appreciated. 

[Anonymous · Accepted solution]

Hi @bw_chec ,

Please check this post, the data types supported by eventstream and lakehouse are different:
Solved: Hard error writing onto a lakehouse as an eventstr... - Microsoft Fabric Community

The following data types are supported in Lakehouse:
https://learn.microsoft.com/en-us/fabric/data-warehouse/data-types#data-types-in-warehouse 

You may need to convert the data type of the column to datetime2 using T-SQL in the KQL Database:
datetime2 (Transact-SQL) - SQL Server | Microsoft Learn

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.