Changes Not Reflected in Fabric Lakehouse table from azure sql db table using EventStream

Sudip Bala 20 Reputation points
2024-08-01T14:06:48.36+00:00

I have a Azure SQL db with CDC enabled as a source and I want the changes to be reflected in Fabric Lakehouse.

I have initially created a pipeline to copy the table from Azure SQL db to Fabric Lakehouse. Now , I have a eventstream (Snapshot Attached). The changes can be seen in the eventstream but they are now written on corresponding table on Lakehouse.

I have tried it previously like 2-3 months ago and it was working .

Could anyone help me resolve it ? User's image

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,996 questions
Microsoft Fabric Training
Microsoft Fabric Training
Microsoft Fabric: A Microsoft unified data platform.Training: Instruction to develop new skills.
48 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Smaran Thoomu 16,735 Reputation points Microsoft Vendor
    2024-08-02T03:45:24.1933333+00:00

    Hi @Sudip Bala

    Thanks for the question and using MS Q&A platform.

    MS Fabric is currently not supported in the Q&A forums, the supported products are listed over here Supported products on MS Q&A (more to be added later on).

    You can ask the experts in the dedicated MS Fabric community forum.

    Can you please open as a new thread in MS Fabric community: https://community.fabric.microsoft.com/t5/General-Discussion/bd-p/ac_generaldiscussion

    User's image

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.