Forum Discussion
arkiboys2
Helper IV
Helper IVtrigger a pipeline on change
I am ingesting data from sql server using fabric Data Factory How is it possible to trigger a pipeline as soon as the sql server table has upsert? Thank you
You can use Azure function to generate the token at run time but you can even add the already generated token within database scoped credentails in Azure SQL database which would eliminate the need for Az function
you can go throgh this doc :
mariussve1
Solution Sage
Solution SageHi,
I have a log table in data Warehouse that logs when sql table is updated. Then you can create a view that sets a flag to 1 or 0 depends if its updated today.
In the pipeline you can just create a lookup and if it returns 1 it continue else stop. Then you can schedule this every 15,30,60 min or What you think is best.
br
Marius