Add FOR JSON support in fabric warehouse
The FOR JSON syntax in T-SQL is a powerful way to create json objects from select statements. This can be useful both to export data but also to pass parameters to for example Data factory if working with a metadata driven framework.
As this functionality is working in most Mi...
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...