Forum Discussion
Changes Not Reflected in Fabric Lakehouse table from azure sql db table using EventStream
Hi Sudip ,
1.Verify Eventstream Configuration:
Ensure that the eventstream is correctly configured to capture changes from your Azure SQL Database with CDC enabled.
Check if the eventstream is connected to the correct table in the Lakehouse.
2.Check Permissions:
Make sure you have the necessary permissions in both the Azure SQL Database and the Fabric Lakehouse.
Verify that the CDC is enabled on the specific tables you are monitoring.
3. Ensure that your Azure SQL server is running and that the Azure SQL database must be publicly accessible and not located behind a firewall or protected in a virtual network.
4.You can go to lakehouse and find the table, then click refresh to see if there are any errors, and if there are no errors go back to eventstream again to see the data preview.
For more details, please refer: Add Azure SQL Database CDC source to an eventstream - Microsoft Fabric | Microsoft Learn
Add a lakehouse destination to an eventstream - Microsoft Fabric | Microsoft Learn
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. Its not resolved yet. Here is one warning maybe thats being an obstacle.
"Message": {
"value": "First Occurred: 8/7/2024 1:24:16 PM UTC | Resource Name: dst-adventureworks | Message: Source 'dst-adventureworks' had 1 occurrences of kind 'OutputDataConversionError.TypeConversionError' between processing times '2024-08-07T13:24:16.3491817Z' and '2024-08-07T13:24:16.3542642Z'. \r\n",
"type": "string"As you can also see here, we have input events but its not writing into lakehouse. Why so??
