Delta Changes on Mirrored Database · Learn Microsoft Fabric

Delta Changes on Mirrored Database

I don't know if anyone has messed around with this, but it seems like you can't get table changes from a mirrored database, which feels odd since it's still delta format and change-fed in.

Example notebook query:

SELECT * FROM table_changes('SafariZone_RentalVehicle', 1);

The error recommends using ALTER TABLE table_name SET TBLPROPERTIES (delta.enableChangeDataFeed=true), which would make sense, but is not available for shortcuts, and the TSQL endpoint for the mirrored DB does not support the sp to enable change feed.

Does this mean if I really want to get each change I should be using the CDC event stream processing for Azure SQL instead of Mirroring? Is mirroring really only useful for snapshot and limited time travel queries?

0 comments