Azure Pipeline Filter Activity

COG 1 Reputation point
2022-03-21T13:34:00.76+00:00

Hi, How do I get Copy Data activity that inside a Foreach loop to copy the folders that have ben filtered by a Filter Activity as @item().name is just capturing the name of the folders and not the contents?

185205-image.png

185233-image.png

185261-image.png

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,378 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
    2022-03-22T16:09:25.547+00:00

    Hi @COG ,

    Thank you for posting query in Microsoft Q&A Platform.

    From your ask and screenshots I understand it as correctly you are fetching folder names using GetMetaData activity and Filtering desired folder names using Filter activity and then looping those folders using ForEach activity. Inside ForEach activity using Cop activity. Now you want to make sure this copy activity to copy all parquet files data inside that folder. Please correct me if I am wrong by sharing more details.

    In the wild card path you can consider mentioning *.parquet at the end to copy all data from that folder.

    For your better idea please check below screenshot.
    185742-image.png

    Hope this helps. Please let us know if any further queries.

    ------------------

    Please consider hitting Accept Answer button. Accepted answers helps community as well.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.