Data Pipelines – Create Relative references to other Fabric items
When using Pipeline activities that references other Fabric items like notebooks, data flows and pipelines and use the option “Add dynamic content” you need to specify the object id. This is less than ideal when working with metadata driven pipelines and CI/CD as promoting an item – like a not...
Add option to parametrise batch count and sequential in for each activity
There is currently no way of parameterisng the settings "Batch count" and "Sequential" in the for each activity. Being able to parameterise the two settings would lead to more flexible solutions and reduce the number of required pipelines when building metadata driven pipelines and frameworks....
Add support for JSON_OBJECTAGG and JSON_ARRAYAGG
JSON_OBJECTAGG and JSON_ARRAYAGG are new functions in Azure SQL to build JSON objects and arrays from SQL data or columns. It would be great if these functions could be added to Fabric warehouse as well to further improve support for JSON and allow for greater flexibility when working with sem...
Add guardrails to SQL DB
There is currently no way to control the scaling of an SQL DB. There should be a way to limit the database from scaling above a certain size. And / or a way to set a fixed cost/size (similar to DTU purchasing model).