Can Azure Function captures changes in multiple tables

Question

Hello,

We need to capture data changes across several tables. However, SQL Triggers appear to support only one table each, and each trigger can only be linked to a single Azure function. Can we combine data change tracking from multiple tables and connect them to a single Azure function?

Thanks in advance,

Answer 1

Based on this old thread :

You can develop a time-triggered function to invoke a stored procedure that integrates change tracking data from multiple tables where change tracking is enabled.

For example, assume change tracking (CT) is activated for the tables Product, Order, and Delivery.

Create a stored procedure that compiles the data changes from these tables into a JSON-formatted message in one column and the table name in another column. The output of this stored procedure should be organized into a table with two primary columns:

• ChangeContent: Contains the JSON message detailing the changes.
• TableName: Identifies the table where the changes occurred.

Additionally, you might include extra columns like ChangeOperation to describe the type of change (insert, update, delete) if needed.