Azure Content : Annu

25. Auto Create table option in Copy activity for SQL as sink in Azure data factory

15. How to fetch pipeline details using dynamic annotations in Azure data factory

11. Examples of wildcard pattern in copy activity of ADF

10. How to replace nulls and convert negative integer value into positive using mapping dataflow

12. How to copy latest file or last modified file of ADLS folder using ADF pipeline

Quiz drop 23:Default value of Escape character in Delimited text dataset in ADF

21. How to replace all the strings values of csv file with null using mapping dataflow

11.How to create dynamic column values using reusable local variable in mapping dataflow

29. Execute ADF pipeline via REST API call

2. Connect to SQL Server through SQL Server Authentication

23. Log pipeline execution details in azure data factory

13. How to copy last modified files from multiple folders into another folder using ADF pipeline

17. Set Custom Metadata using Copy Activity in ADF pipeline

18. Skip Line count in Copy Activity in Azure data factory pipeline

26. How to setup email alerts with Azure Log Analytics for azure Data Factory pipeline

18. How to combine Columnnames and columnvalues of two files into single file using mapping dataflow

13. How to unpivot sql columns and convert it into nested json using mapping dataflow

10. How to write filenames as separate rows in csv using adf pipeline

4. The specified SQL Query is not valid. The query doesn't return any data.

36. How to Extract distinct elements from an array of complex object using mapping dataflow

25. Auto Create table option in Copy activity for SQL as sink in Azure data factory

19. How to reverse an array using azure data factory pipelines

9. How to do full load from On Premise SQL Server till ADLS using Azure Synapse Pipelines

26. Monitor Copy activity in ADF pipeline

38. How to find the position of nth occurrence of a character in a string using mapping dataflow

1. Read JSON data from ADLS and insert into SQL table using Logic apps

6. For Each activity do not run in parallel

Quiz drop 24: Default value of Quote character in Delimited text dataset

Quiz drop 20: Which dataflow transformation is similar to left outer join in SQL

2. How to copy a specific file from folder using parameterized dataset in azure data factory

12. How to perform Upsert for Incremental records using Azure Synapse Pipelines

2. Read Multiple JSONs from ADLS and load into SQL using Logic apps

Quiz drop 22: Default column delimiter in Delimited text dataset

8. Found more columns than expected | Common Errors in ADF

2. Resilient Distributed Dataset (RDD) in Pyspark

How to pause all the dedicated SQL pools in subscription after a period of inactivity

Quiz drop 27 : Which trigger helps to backfill historical data

37. How to concatenate data of multiple rows after grouping using mapping dataflow

18. How to swap array elements using azure data factory pipelines

30. How to count number of orders based on aggregation using mapping dataflow

3. RDD partitioning | Repartition() vs Coalesce

34. How to Format datetime to a 12-hours clock and 24-hours clock

10. Magic of wildcard filters in copy activity of ADF

26. How to identify duplicate rows and load only distinct rows using mapping dataflow

12. List of files in copy activity of adf

27. How to get email notifications for pipeline failures by creating alert rules within ADF

Quiz drop 13 : What is the maximum value of TTL in ADF

Quiz drop 6 : What is the minimum timeout duration for activities in ADF Pipeline

19. Write to multiple files using Max rows per file in copy activity of ADF pipeline

7. How to convert a JSON record into NESTED JSON using mapping dataflow

7. Parameters vs. variables in ADF