Azure / Azure/azure-functions-sql-extension
Add Sync Version Number/Column Changed to SQL Change
Open
enhancement
P1
trigger
- Dominant language
- C#
- Stars
- 130
- Forks
- 71
- Avg merge
- 4d 8h
- Merged PRs (30d)
- 4
Description
I am attempting to use SQL Trigger functions to generate webhooks if and only if we see specific columns change from X value to Y value, but noticed the SQL Changes only include the updated data of the row and no way to determine which change version that data belongs to, or which columns were changed.
Would it be possible to include the sync version of SQL change as well as the name of the column(s) changed (when Change Tracking with the TRACK_COLUMNS_UPDATED flag is enabled)?
Simply adding two new properties to the SQL Change with that version number and a list of columns changed would be great!
Contributor guide
Assessment
This issue has not been assessed yet.