Materialize v0.69
v0.69.0
Sources and sinks
-
Support validating the parameters provided in a
CREATE CONNECTION
statement against the target external system. For most connection types, Materialize automatically validates connections on creation.For connection types that require additional setup steps after creation (AWS PrivateLink, SSH tunnel), you can manually validate connections using the new
VALIDATE CONNECTION
syntax:VALIDATE CONNECTION ssh_connection;
SQL
- Add support for new SQL functions:
Function Description mz_is_superuser
Reports whether the current role is a superuser with administration privileges in Materialize. regexp_replace
Replaces the first occurrence of the specified regular expression in a string with the specified replacement string. regexp_split_to_array
Splits a string by the specified regular expression into an array. regexp_split_to_table
Splits a string by the specified regular expression.
-
Add the
IN CLUSTER
option to theSHOW { SOURCES | SINKS }
commands to restrict the objects listed to a specific cluster.SHOW SOURCES;
name | type | size | cluster --------------------+----------+-------+--------- my_kafka_source | kafka | | c1 my_postgres_source | postgres | | c2
SHOW SOURCES IN CLUSTER c2;
name | type | size | cluster -----------+-------+----------+-------- my_postgres_source | postgres | c2
-
Make the syntax for
GROUP SIZE
query hints more intuitive by deprecating theEXPECTED GROUP SIZE
hint and introducing three new hints:AGGREGATE INPUT GROUP SIZE
,DISTINCT ON INPUT GROUP SIZE
andLIMIT INPUT GROUP SIZE
; which more clearly map to the target operation to optimize.The old
EXPECTED GROUP SIZE
hint is still supported for backwards compatibility, but its use is discouraged. -
Add
savings
to themz_internal.mz_expected_group_size_advice
system catalog table. This column provides a conservative estimate of the memory savings that can be expected by usingGROUP SIZE
query hints.
Bug fixes and other improvements
- Support SQL parameters in
SUBSCRIBE
andDECLARE
statements.