Materialize v0.54
v0.54.0
SQL
-
Add
mz_internal.mz_cluster_replica_historyto the system catalog. This view contains information about the timespan of each replica, including the times at which it was created and dropped (if applicable). -
Add
envelope_state_bytesandenvelope_state_countto themz_internal.mz_source_statisticssystem catalog table. These columns provide an approximation of the state size maintained for upsert sources (i.e. sources usingENVELOPE UPSERTorENVELOPE DEBEZIUM). In the future, this will allow users to relate upsert state size to disk utilization. -
Improve and extend the base implementation of Role-based access control (RBAC):
-
Consider privileges on database objects when executing statements. If RBAC is enabled, Materialize will check the privileges for a role before executing any statements.
-
Improve the
GRANTandREVOKEprivilege commands to support multiple roles, as well as theALLkeyword to indicate that all privileges should be granted or revoked.GRANT SELECT ON mv TO joe, mike; GRANT ALL ON CLUSTER dev TO joe; -
Add support for the
DROP OWNEDcommand, which drops all the objects that are owned by one of the specified roles from a Materialize region. Any privileges granted to the given roles on objects will also be revoked.
It’s important to note that role-based access control (RBAC) is disabled by default. You must contact us to enable this feature in your Materialize region.
-