#108

Azure Storage - Redundancy Options

Azure Data Factory\Synapse: Issues while Connecting to On-premise Server and fix for it

Azure Data Factory \ Synapse Analytics - Delete folders older than 7 days!

Find Latest Sub Folder in ADF\Synapse

Azure Data Factory\Synapse Analytics - Deep dive into Schema Drift

ADF\Synapse: Relialize the power of Wildcard based file copy!

ADF\Synapse: Replace space in column names just like that, using Rule-based mapping

ADF\Synapse: Interpret Script activity output json and write expressions to access column values

ADF\Synapse: Pass Pipleline Param to DataFlow Param and use it in Source query 2 filter Src data

ADF\Synapse - Use REST API to know pipeline run status

ADF\Synapse - Copy files incrementally, based on Last modified date

Azure Data Factory\Synapse:Load from different XL files with different names to Az. SQL tables

Pipeline().TriggerName system variable Use Case #azuresynapse #azuredatafactory #allaboutbi

ADF\Synapse: Validate Email ID using REGEX in data flow

ADF\Synapse : Ignore XML with no records or Process XML that has records

Azure Data Factory\Synapse: Decide name of additional column and its value dynamically

Scenario Based Question: Trigger exactly at 6am-8 am with two triggers

Azure Data Factory - Take first row\column from file

Azure Data Factory - Iterate through files in folder and get file structure

ADF\Synapse Analytics - Pass dynamic value to filename in Sink in Copy Activity & Data flow

Azure Data Factory : Use Web Activity to Call child pipeline & Pass Parent Run id via Body

Azure Functions - Basics Part II

Azure Functions - Basics - Part I

Azure Functions : How to convert .csv to .xlsx using Az Funtion & Pandas