6.02 User Defined Functions, Stored Procedures and execution automation options in Synapse Warehouse

   • Microsoft Fabric For Beginners  
In this video, I explore different programmatic components of the Synapse Warehouse Service like User Defined Functions and Stored Procedures
I also explain the code automation options like Get Metadata, Lookup, Script And Stored Procedure activities from Data Pipelines. Next, I demonstrate the creation and usage of Table Value Functions and Stored Procedures and show how they can be triggered from Data Pipelines.

Chapters:
00:00- Introduction
00:46- Overview of User-Defined Functions and Stored Procedures
02:38- Demo 1: Creating and using User-Defined Functions
06:58- Demo 2- Creating and using Stored Procedures
08:59- Demo 3: Triggering Warehouse queries and Stored Procedures from Data Pipelines

You can download the demo artifacts here:
SQL Script: https://github.com/fazizov/youtube/bl...

Please subscribe:    / @fazizov  
Follow me on Linkedin: www.linkedin.com/in/fikrat-azizov-865a0528
and X: @fikrat_azizov


Official Documentation:
https://learn.microsoft.com/en-us/fab...
https://learn.microsoft.com/en-us/sql...

Hashtags:
#microsoftfabric ,#datawarehouse, #dataengineering, #azure,#microsoft,#cloudcomputing, #dataanalytics, #lakehouse, #azuretutorial, #azuretraining, #datapipeline, #dataextraction , #dataintegration, #datatransfer, #dataflow, #spark, #deltalake, #synapse, #synapsedataenginering, #demo, #datalake, #transformation, #ingested, #dataintegration, #azuredatabricks ,#databricks, #bigdata, #bigdatatechnologies, #pyspark, #sparksql, #notebook ,#transformationvideo, #bronze, #medallion , #modeling, #facts, #silver, #gold, #historical data, #timetravel, #incremental,#datafactory, #dataactivator, #mirroring