ADF: (Un)parameterized Linked Services

Tom Lous 101 Reputation points
2020-10-02T11:53:20.68+00:00

I have 2 Linked Services: A Oracle DB service and an Azure Data Lake Service. The oracle service has parameter options and has fields that allow dynamic content. The Azure DataLake Gen 2 service has neither.
Why is this? How can I parameterize my Azure Data Lake services?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,865 questions
0 comments No comments
{count} votes

Accepted answer
  1. Tom Lous 101 Reputation points
    2020-10-05T06:55:03.177+00:00

    Actually the parameter / dynamic content UI that works only for a few types. I found that editing the json allows it for other types as well

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Evgeny Grishchenko 486 Reputation points
    2020-10-04T09:26:54.613+00:00

    Hi @Tom Lous ,

    You could define and use parameters for the sink dataset, which uses your DataLake Gen2 service.

    For example, if you sinking using parquet format into your datalake storage...

    30053-datasetproperties.png

    30052-parquet.png

    0 comments No comments

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.