locked
Relational Table Dataset with minimumRows in python RRS feed

  • Question

  • Hi Team,

    I am copying data from from hive table using RelationalTableDataset using python.

    syntax

    RelationalTableDataset(linked_service_name, additional_properties=None, description=None, structure=None, parameters=None, annotations=None, table_name=None)

    Also using source as bellow

    RelationalSource(additional_properties=None, source_retry_count=None, source_retry_wait=None, query=query)

    Need to return when minimumRows  is more than 1  in ADF2.

    I am unable to find any attribute like minimumRows  . Currently if zero rows return by query file copied to datalake.

    Requesting urgent help.

    Thanks

    Swarup K


    • Edited by Swarup K Friday, January 11, 2019 10:19 AM
    Friday, January 11, 2019 10:17 AM

Answers

  • Hi,

    It is not working.

    Thanks

    • Marked as answer by Swarup K Monday, January 28, 2019 2:07 PM
    Wednesday, January 16, 2019 1:35 PM

All replies

  • Hi there,

    Per my understanding, your requirement is to fetch the data copied from RelationSource after the copy activity run? If so, the ActivityRun.Output.dataReads should be the attribute you're seeking for.

    Here're two useful doc for you, hope this helps.

    https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-overview#monitor-programmatically

    https://docs.microsoft.com/en-us/dotnet/api/microsoft.azure.management.datafactory.models.activityrun.output?view=azure-dotnet

    Saturday, January 12, 2019 3:43 PM
  • Hi,

    It is not working.

    Thanks

    • Marked as answer by Swarup K Monday, January 28, 2019 2:07 PM
    Wednesday, January 16, 2019 1:35 PM