'creating metadata of table in Sink/Target in Data Factory automatically
Is it possible on Azure Data Factory to create the table definition in the target/sink database. SSIS used to create the metadata automatically based on the Source/ Transformation in the pipeline. ADF does not seem to have that option but I am new to it so maybe non the wiser as to how to do it on the fly or any hidden options without having to script the table on the target destination
Solution 1:[1]
The Azure Data Factory (ADF) Copy activity does support creating the sink table at runtime but only for certain data sources:
- Azure SQL Database
- Azure SQL Database Managed Instance
- Azure Synapse Analytics
- SQL Server
See here for more details.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | wBob |