Forum Discussion
Changes Not Reflected in Fabric Lakehouse table from azure sql db table using EventStream
Hi Sudip ,
Ensure that the data types in your Azure SQL Database match those in your Fabric Lakehouse. The error message indicates a type conversion error, which often occurs when there is a mismatch in data types.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
i get that but the problem is there is no datetime column in my source.
Hi Sudip ,
Do you mean you want to add a datetime column? You can refer to the following operation:
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
No. i dont need any other extra columns. I am expecting the eventstream to write data on existing table inside Lakehouse.
here is the simple workflow:
1. Azure SQL db (CDC) as source, single table selected for now to pass into eventstream
2. Lakehouse as destination where the table already exists
3. Made some changes in the source table (which i expect to be reflected in lakehouse table)
4. Its not happening . I see the changed in EventStream but its not written in Lakehouse table.
Could you help on this??
