Search code examples
datasetazure-pipelinesazure-data-factoryodataazure-data-lake-gen2

how to get selected columns from OData source Table using azure data factory?


I'm trying to get the selected column values from the OData source table using azure data factory with copy activity, but i got all the columns from the source table. i want only selected columns.


Solution

    • Give the entity name in the path of the OData dataset.

    enter image description here

    • The example dataset has 3 columns. From these three columns, query is written to select only name and lcaocode fields.
    • In source tab of copy activity, select Query option and enter $select=Name,IcaoCode in the query textbox.

    enter image description here

    • By this way, only required columns from OData source can be selected.