extent storage capacity of varchar(8000) to varchar(max)
The maximum string length of 8000 is often considered too short to store longer descriptive data or embed a JSON value within a text field in a database. Dividing the data into smaller chunks and store them across multiple text fields or in separate tables is unnecessarily cumbersome.
da...
Support for more delta/parquet data types
The nested types array, map, and struct, along with the unnest function, are widely used by other vendors. Adding T-SQL support to the SQL Server/Warehouse family would greatly improve and enable interoperability between third-party delta/parquet-based systems.
support openrowset/polybase
Data providers typically deliver data in formats such as parquet, JSON, or CSV. In traditional data warehouse scenarios, these files often land in a persistent staging area. Many organize these staging folders in a structured manner such as year/month/week/day. Currently, these files need to b...
Managed Apache Airflow
For more advanced dynamic orchestrations, the no/low code capabilities of Data Factory can be cumbersome. The addition of the Azure ADF Managed Airflow to Fabric would enable code-based orchestrations.
Add the warehouse delta write functionality to Sql Server Polybase
Creating an Sql Server 2022 option to generate a delta with vorder and export it via CREATE EXTERNAL TABLE AS SELECT to OneLake would be a valuable asset for hybrid scenarios involving on-premises SQL Server and Fabric.