This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 66%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Am looking at capturing CDC rows in the SQL Server and push into Event hub through Logic Apps. Which Trigger would be a good fit
Any thoughts and direction will be helpful.
@BGAZ Just following up to see if my response helps
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 42%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Thank you for sharing the recurrence trigger option. I explored the recurrence trigger, but didnt seems to meet my need. Below is a similar solution using fucntion.
[SqlTrigger("GetCDCdata", ConnectionStringSetting = "SqlConnectionString")]
IEnumerable<SqlChangeTrackingEntry<GetCDCdata>> changes)
I was thinking where we could potentially use a last run timestamp by logic app or some option within the Azure SQL Database to trigger the changes that the calling logic app is looking for. Any thoughts?
Now that you mention it, I missed that we have a SQL Trigger that you could use. I've update my answer to include that option.
Since there is no way to know if rows are being written into the CDC Table (or any SQL Table for that matter), you will have to poll it on a regular interval.
You could use the SQL Trigger that implements this.