Materialize v0.51
v0.51.0
Sources and sinks
-
Add support for replicating tables from specific schemas in the PostgreSQL source, using the new
FOR SCHEMAS(...)
option:CREATE SOURCE mz_source FROM POSTGRES CONNECTION pg_connection (PUBLICATION 'mz_source') FOR SCHEMAS (public, finance) WITH (SIZE = '3xsmall');
With this option, only tables that are part of the publication and namespaced with the specified schema(s) will be replicated.
SQL
-
Add
disk_bytes
to themz_internal.mz_cluster_replica_{metrics, sizes}
system catalog tables. This column is currentlyNULL
. In the future, it will allow users to inspect disk utilization for each cluster replica. -
Add the
translate
string function, which replaces a set of characters in a string with another set of characters (one by one, regardless of the order of those characters):SELECT translate('12345', '134', 'ax'); translate ----------- a2x5
-
Add new configuration parameters:
Configuration parameter Scope Description enable_session_rbac_checks
Session Read-only. Boolean flag indicating whether RBAC is enabled for the current session. enable_rbac_checks
System Boolean flag indicating whether to apply RBAC checks before executing statements. Setting this parameter requires superuser privileges. This is part of the work to enable Role-based access control (RBAC) in a future release (#11579).
Bug fixes and other improvements
- Improve the reliability of SSH tunnel connections in the presence of short idle TCP connection timeouts.