VARCHAR(MAX)/VARBINARY(MAX) types
Data Warehouse · Public preview · Shipped
Description
Users can define columns with VARCHAR(MAX)/VARBINARY(MAX) types in Data warehouse to store string or binary data up to 1 MB. In SQL endpoint for the Lakehouse, the string types in Delta tables are represented as VARCHAR(MAX) without truncation to 8 KB. The performance differences between the queries that are working with VARCHAR(MAX) and VARCHAR(8000) types are minimized, which enables users to use large types without significant performance penalty.
Change History
-
2024-10-31
Roadmap Item Added
Workload: Data Warehouse