Ingest semi-structured data faster and more efficiently with Variant
Databricks has launched Variant, a generally available data type for ingesting semi-structured data like JSON or XML without sacrificing query performance, supported by Predictive Optimization and Shredding.
The useful question is what changes for users, developers or buyers, and whether the announcement stays industry context or becomes something people can actually use.
For years, data teams faced a tradeoff between flexible semi-structured data ingestion and fast query performance. Databricks introduced the Variant data type to resolve this, enabling users to store JSON, XML, or CSV data in a structured-like format within Delta or Iceberg tables. This approach eliminates the need for upfront schema definition while maintaining query speed. Over 5,000 teams are already using Variant to process streaming events, API payloads, and schemaless database data, particularly where upstream schema changes complicate traditional pipelines.
Variant Shredding, now generally available, further enhances performance by automatically converting common fields into columns during ingestion. Predictive Optimization analyzes workload patterns to identify critical fields, improving file skipping and reducing unnecessary data scans. Databricks reports that this combination delivers nearly 4x faster reads than unshredded Variant and 30x faster reads than storing JSON as a string. Users can query deeply nested attributes efficiently, even at petabyte scale, addressing challenges like security log analysis.
The Variant data type integrates across Databricks’ ecosystem, supporting both Delta and Iceberg formats for interoperability. Teams can generate Auto Loader ingestion pipelines using natural language via Genie Code in Lakeflow Pipelines Editor, simplifying setup. Once ingested, Variant data can be queried directly in dashboards and reports at speeds comparable to structured data, thanks to intelligent shredding during ingestion.
Databricks plans to expand Variant support with features like Liquid Clustering by Variant fields, additional SQL functions, and broader integrations. The company emphasizes that Variant removes the traditional tradeoff between flexibility and performance, using Predictive Optimization to automatically optimize data storage for downstream queries. Users can begin experimenting with Variant through Databricks’ documentation and tools.