VARCHAR(MAX) support in SQL analytics endpoint of Lakehouses (new metadata sync)

Data Warehouse · General availability · Shipped

Data Warehouse General availability Shipped
Last Modified: October 08, 2026 Release Date: Q3 2026

Description

SQL analytics endpoints for Lakehouses will support large string and binary data using VARCHAR(MAX) and VARBINARY(MAX) types, up to 16 MB, with the new Metadata Sync feature.

📰 Related Blog Article

Large string and binary values in Fabric Data Warehouse and SQL analytics endpoint for mirrored items (Generally Available)
🔗 community.fabric.microsoft.com

Change History

  1. 2026-10-08
    Name VARCHAR(MAX) support in SQL analytics endpoint of Lakehouses -> VARCHAR(MAX) support in SQL analytics endpoint of Lakehouses (new metadata sync)
  2. 2026-09-14
    Release Status Planned -> Shipped Feature Description SQL analytics endpoints of Lakehouses will support large string and binary data using VARCHAR(MAX) and VARBINARY(MAX) types up to 16 MB. -> SQL analytics endpoints for Lakehouses will support large string and binary data using VARCHAR(MAX) and VARBINARY(MAX) types up to 16 MB with the new Metadata Sync feature.
  3. 2026-07-29
    Release Date 2026-05-01 -> 2026-09-30
  4. 2026-06-16
    Restored to Roadmap
  5. 2026-06-16
    Removed from Roadmap
  6. 2026-06-02
    Restored to Roadmap
  7. 2026-05-13
    Removed from Roadmap
  8. 2025-11-19
    Roadmap Item Added
← Back to Roadmap 👁️ Watch this Feature View API JSON Workload: Data Warehouse