Forum Discussion
amaaiia
Skilled Sharer
Skilled SharerUse Dataflow Gen2 for multiple tables ingest dinamically
I have a Data Pipeline to ingest in my Lakehouse several tables located in an on-premise SQL Server, and the tables are going to be daily reloaded incrementally. They have a date field, and every day...
amaaiiaSkilled Sharer
Skilled SharerHi Element115, thanks for the response. Is it possible to ingest data from SQL Server on-prem through gateway? I dind't tell you but I need data to be accessed thorugh gateway, and I think DFg2 is the only way for the moment.
I could
Element115
Memorable Member
Memorable MemberLook what I found!
Use this capability to make your data flows general-purpose, flexible, and reusable. You can parameterize data flow settings and expressions with these parameters.I am assuming the Fabric Data Factory is just a rebranding of Azure Data Factory, so it should work the same.
Parameterizing mapping data flows - Azure Data Factory & Azure Synapse | Microsoft Learn