Fabric Data Warehouse allows reading Parquet and CSV files using the OPENROWSET function. However, it does not support external tables that reference Parquet or CSV files (CREATE EXTERNAL TABLE (Transact-SQL) - SQL Server | Microsoft Learn). This limitation hinders the straightforward migration of Polybase external tables from Synapse dedicated/serverless pools or SQL Server. The only available workarounds for migration involve either converting Parquet/CSV files to Delta Lake format or rewriting the code to use OPENROWSET, which lacks the same security model.
As a result, migrating from Synapse or SQL Server to Fabric Data Warehouse requires data or code conversion.
Supporting external tables with Parquet and CSV files is crucial for seamless migration and ensuring compatibility with other SQL Server/Data Warehouse offerings.
on:
Conditional formatting in row header in Matrix tab...
frithjof_v
on:
Monitoring hub show detailed error logs