All About BI !

Azure Data Factory - Create files from column data using Copy activity

ADF\Synapse Quick Bytes: Create zip file and retain file names

#15. Azure Data Factory - Delete contents of a folder

#82. Azure Data Factory - Nested Foreach loop activity to delete files in multiple folders

#116

#33. Azure Data Factory - Use Union in the data flow activity to combine data from different sources

#47. Azure Data Factory - Use Filter activity inside Mapping data flow task

Azure Data Factory - Read from variable and write to a file in BLOB storage

#78. Azure Data Factory - Execute Python script from ADF

Azure Data Factory - Run Powershell Script from ADF to delete folders\files in ADL

Azure Data Factory in Tamil - Copy Data Vs. Data Flow

Azure Data Factory\Synapse - Copy Folders, Files from one ADLS container to another ADLS Container

What's new - Azure Data Factory - Quick Reuse option to reduce Data Flow Cluster startup time

#95. Azure Data Factory - Copy the latest file with DATE PART to Folder using AZURE FUNCTIONS

#9. Azure Data Factory - Introduction to Array type variables

Azure Data Factory - Create Data factory pipeline using Python

Azure Data Factory - Take first row\column from file

Azure Data Factory - Parallel foreach loop and Set variable issue explained

#6.Azure Data Bricks - Read and Write CSV file from ADB to ADL

Generate Sequence Numbers using Script Component in SSIS

#108

#71. Azure Data Factory - Copy from CSV file to Azure Synapse table

#35. Azure Data Factory - Fix Mapping Column issue in Mapping Data Flow

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

#36. Azure Data Factory - Data Preview tab in Mapping Data Flow

#90. Azure Data Factory - Create dynamic folders and move files after copy

#57. Azure Data Factory - Load from BLOB storage path to SQL Server OnPremise.

#34. Azure Data Factory - Optimize Data Flow Activity

Azure Data Factory - Access Custom Activity Output from subsequent activities in ADF

#41. Azure Data Factory - Unpivot transformation in Mapping data flow

#55. Azure Data Factory - Parse XML file and load to Blob storage path

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

#37. Azure Data Factory - Use Group By in Mapping Data Flow task

#22. Azure Data Factory - Use Filter Activity to filter .txt files from Folder

#6. Azure Data Factory - What is integration runtime? What are its types?

ADF - Convert XML to .txt file using copy activity

#87. Azure Data Factory - Use Filter activity with these expressions to filter a text file content

#49. Azure Data Factory - Implement Upsert logic in Mapping data flow.

#58. Azure Data Factory - Incremental File Copy using Copy Data TOOL

#64. Azure Data Factory - Add Additional columns to the source columns in Copy Activity

#10. Azure Data Bricks - Send exception/error message from Notebook to Pipeline

Azure Functions - Basics Part II

#38. Azure Data Factory - Column Patterns in Aggregation to make it simpler

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

#5. Azure Data Factory - Use Foreach loop activity to copy multiple files - Step by Step Explanation

#20. Azure Data Factory - Load from .XLSX file to Azure SQL table

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

#4. Azure Data Bricks - Get XL sheet names dynamically and pass on to ADF Pipeline

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

Azure Data Factory\Synapse Analytics - Use Case statement in Mapping Data flow

Azure Functions: Use Azure Function & get XL Sheet names