Add OPENXML support to Fabric DataWarehouse
We have OPENJSON support which is very useful when we have Json in data tables.
However many vendors and sources today use XML for extensibility and not JSON.
Lack of OPENXML is limiting our ability to migrate from SqlDBEngine to Fabric and prevents in db querying of XM...
HashBytes returns incorrect length in Fabric DW
HASHBYTES returns the wrong length on Fabric DW as compared to SqlPool or SqlDbEngine
For example
SELECT len(HASHBYTES('MD5', 'a'))
returns 10 on Fabric which is not as expected but returns 16 on other SQL Editions.
Note that the length...
Add Support for OPENJSON with Default Schema with tables
Currently OPENJSON with Default Schema only works with json variables and not tables. This means that we cannot use OPENKSON when the json is in rows in a table.
Please add support for this so we can migrate Json based solutions from SqlPool or SqlDbEngine to Fabric.
Exa...
Add support for office PIPs into Fabric Notebooks (Python)
Its very common to need to integrate Fabric PySpark into office to download excel files. Currently this is difficult to do and if we do a pip install at Library level, the startup times is too slow.
Can we get the following PIP installs into the standard Spark "Started" image ...
Bug in auto rollback when error inside a TRAN in Fabrc
The code below behaves differently on Fabric DW v Synapse SqlPool in that an error does not auto rollback the transaction and @@TRANCOUNT =1 instead of @@TRANCOUNT=0 as expected,
The impact here is if we drop a table and accidently query it (race condition), we end up with tr...
Add support for SSDT Schema Compare for DW and LH
Current Visual Studio supports All editions of SQL except Fabric.
This is an essential tool quick ad hoc schema compares.
Please consider adding support to SSDT for Fabric artefacts so that we can use SSDT.
https://learn.microsoft.com/en-us/sql/ssdt/how-...
Add support for SET XACT_ABORT
Currently Fabric does not support SET XACT_ABORT ON.
We request to add this support to reduce breaking changes when migrating and to improve transaction support for the scenario below
This results in a breaking change in how transactions are handled and makes ...
Add SQLDB for Fabric
Its great that Fabric gives us many ways to write delta-parquet files, but for meta data and logging we really need a different storage. One that has super low latency and optimised for small non-analytical queries.
Ideally, what we need here is to be able to create a Fabric "...
Fix RowCount on QueryInsights for Cancelled Statements
When We cancel a query. QueryInsights reords the RowCount as 576163540566540507 in the view exec_requests_history
We assume that this should be "Null" as the query was cancelled, so no rows returned.
Support public connection to master in Fabric DB
Currenlty when connecting to a Database using SSMS we get an error if we dont put the name of the database in the COnneciton Properties (and no one ever remembers to do this).
This leads for poor user experience and goes against "it just works"
If the user had...