Todd Chittenden on 04 Apr 2024 16:38:06
Classic Azure Data Factory and Synapse Analytics Workspaces have a pipeline wizard for doing meta-data driven copy tasks. It give you the T-SQL to create and populate a Control Table, and a three-level nested pipeline setup. It would be great to have this in Fabric as well/ But since the connection types are so different, it would need some work. Also, you need a SQL endpoint that supports the IDENTITY construct for INT columns, which is not available yet in Fabric Warehouses.
Administrator
Planned as part of our CY24 roadmap