SQL Triggers for Azure Functions

We dig into the preview bits of SQL Triggers that is now available for Azure Functions. Get a feed of data operations as they happen so that changes can be processed downstream into other systems.
▶️ Azure SQL bindings for Azure Functions docs
learn.microsoft.com/en-gb/azu...
▶️ mssql-cli: A command-line query tool for SQL Server
learn.microsoft.com/en-us/sql...
▶️ SQL Extensions for Azure Functions NuGet Package
www.nuget.org/packages/Micros...
00:00 - Intro
00:55 - Enabling change tracking in SQL
02:42 - Creating a new Azure Function app
03:23 - Adding the SQL extensions NuGet package
04:00 - Creating a function for the trigger
04:55 - Binding the trigger parameter
06:09 - Creating a model for the data
07:00 - Writing the data operations change feed to the log
09:37 - Adding the database connection string
10:07 - Running the function
11:57 - SQL Trigger configuration documentation
12:23 - Enable runtime-driven scaling in Azure
12:49 - Outro
#azure #serverless #sql #azurefunctions

[@schmiroh]

Very well explained 👍

[@dareljohnson5770]

This is amazing content! Thanks.

[@yaroslavmilanich489]

Thanks 😊 going to use it

[@tarunbablani5555]

How do we deploy this to an azure function which will do a sql trigger on a table for an azure sql database

[@giosefer]

Hy Fanie, can you help me? I created my first SQL Triggers for Azure Functions with MySqlDB but the function has problem with the connection. In in the file local.settings.json the parameters is set: "Server=tcp:,; Integrated Security=true; Database=test; Uid= ; Pwd=" The db is up&running on azure cloud. What am I doing wrong ?

[@manipathak7721]

Hey Fanie, nicely explained. I have few clarification points 1. Is it possible to track the changes on a single column of table rather than whole table . For ex I only want to run my function on insert. So as soon as a new record is inserted then only my function should run. 2 . Any practical example to wait the function for few interval of time after a new record inserted. 😊

[@jcnet2008]

Amazing.!! Do you have an example using output bindings?

[@diptanusaha6597]

Thank you for a lovely tutotial, however the code doesn't work for me ! do you have a repo that I can refer to please ?

[@Astral100]

Have you tried to deploy it and make it work in Azure? It doesn't work in Azure for me, although it works locally.

[@DeepakShaw]

Excellent Demo, does such notification works also with SQLite? Thanks.

[@FanieReynders]

Have not tested it, would be interested to know tho.

[@DeepakShaw]

@@FanieReynders Yes, I have tested and it works perfectly with SQL Server. Thanks for the idea. But I need to achieve the SQLite.. no luck yet.

[@shyampramanik780]

Is this feature can be used in production ?

[@FanieReynders]

The trigger functionality is still in preview, so it has no SLA, but nothing stops you from implementing it in production. It depends.