topic Error writing data to Lakehouse Table Eventstream in Eventstream

Error writing data to Lakehouse Table Eventstream

bw_chec — Wed, 12 Feb 2025 11:18:23 GMT

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.

Re: Error writing data to Lakehouse Table Eventstream

Anonymous — Thu, 13 Feb 2025 01:40:43 GMT

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.