adf from configtable

Question

Hi,

how to load tablename from config table and using copy activity at front end... how it will execute it.... let say copy activtiy lookup for tablename then how copy activity will take that...please help with screenshot ...

Answer 1

Hi @Vineet S
Thank you for your question and using the Microsoft Q&A platform.
To load a table name from a configuration table and use it in a Copy Activity in Azure Data Factory (ADF), you can follow these steps:

Create the Lookup Activity:

• In your ADF pipeline, add a Lookup activity.
• Configure the source dataset to point to your configuration table.
• In the "Source Output" tab, define an output schema that includes a column for the table name to be retrieved (e.g., "TableName"). You can add other columns if needed for the Copy Activity configuration. Create the Copy Activity:
  • Add a Copy Activity to your pipeline after the Lookup activity.
  • Configure the source and destination datasets as required for your data transfer.
  Set Up Dynamic Table Name:
  • In the "Sink" settings of the Copy Activity, navigate to the "Table" property.
  • Instead of a static table name, enter an expression that references the output of the Lookup activity. Use the following format:
    @activity('LookupActivityName').output.TableName

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.