v25.2 Release notes

v25.2.3

TLS Support for SQL Server Source

v25.2.3 bumps the environmentd version 0.147.4 which supports TLS connections for SQL Server. For more information, see Ingest data: SQL Server.

Basic Authentication for HTTP interface

v25.2.3 bumps the environmentd version 0.147.4 which supports basic authentication for the HTTP interface. For more information, see Integrations HTTP API.

v25.2.0

Support for SQL Server Source

Starting in v25.2, self-managed Materialize adds support for a native SQL Server source. With the new source, you can replicate data directly into Materialize, using SQL Server’s built-in Change Data Capture (CDC) functionality.

For more information, see Ingest data: SQL Server.

Authentication + RBAC

Starting in v25.2, password authentication and role-based access control are available in self-managed Materialize. For details, see:

Password authentication, now in public preview.
Role-Based Access Control.

Support for `PARTITION BY`

Starting in v25.2, self-managed Materialize adds support for a new PARTITION BY option for materialized views and tables. PARTITION BY allows you to control how Materializes internally groups and stores your data. This can lead to dramatically faster query performance and rehydration times for certain workloads.

For details, see Partitioning and filter pushdown.

Console Improvements

Self-managed v25.2 also includes various improvements to the Console:

Consolidating source lag under Freshness metrics
Copy button for queries
Syntax error highlighting

Improved `EXPLAIN`

The following improvements to EXPLAIN are now available in v25.2:

New EXPLAIN output format to highlight the most important parts of your query.
New EXPLAIN ANALYZE to help you understand long-running queries.

For more information, see the EXPLAIN and EXPLAIN ANALYZE reference pages.

Known Limitations

Item	Status
License Compliance License key support to make it easier to comply with license terms.	In progress
Network Policies Materialize Network policies are not yet supported.
AWS Connections AWS connections require backing cluster that hosts Materialize to be AWS EKS.
EKS/Azure Connections
Temporal Filtering Memory optimizations for filtering time-series data are not yet implemented.