Add support for identity columns in Fabric warehouses.
Identity columns are a common method for generating surrogate keys in data warehousing scenarios implemented on SQL Server. By adding support for identity columns in Fabric, users could migrate their warehouse workloads from SQL Server to Fabric, without having to make drastic changes to thei...
Add the ability to create a shortcut using t-sql
Thinking of creating data transformation pipeline as SQL code (think DBT), it would be convenient to be able to check to see if a table shortcut exists and if not create it all from T-SQL. I realize a rest endpoint to create shortcuts is in the works but it would be really nice to be able to d...
Support TDS connections via port 443 in addition to port 1433
Our current corporate network configuration restricts outbound traffic on port 1433, which prevents establishing connections to SQL endpoints in Fabric via SSMS and other client tools. However, if we were able to enable TDS connections over port 443, it would greatly enhance our connectivity o...
Cross workspace joins.
We are planning a data mesh architecture enabled by Fabric and dbt-cloud. Separate teams within our data warehousing group will develop tables and views in their own dbt projects. dbt models will be shared across teams when appropriate to enable consistency and efficiency. This is easy to do...