This support is planned for SQL DB Managed Instances:
An error occurred while saving the commentDaniel Dodds-Wade commented
We'd like to be able to capture historical data on certain important tables and data. For instance, on our products table, we'd like a record of each time the price changes, when it was made and by who. From what I've read, it appears that Change Data Capture is not available on SQL Azure and this is the server we are using to house our DB. Change Data Capture is exactly what we are looking for.
Thanks!Daniel Dodds-Wade shared this idea ·
24 votesunplanned · AdminAzure Stream Analytics Team on UserVoice (Product Manager, Microsoft Azure) responded
We are exploring the possibility of supporting CosmosDB change feed as ingress to Stream Analytics which will solve this scenario. For reference data, we already provide a mechanism to refresh reference data in Azure Blob storage using Azure Data Factory. More details about this here: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-use-reference-data
We are listening and committed to making Stream Analytics even better! Keep your feedback coming.Daniel Dodds-Wade supported this idea ·