Materialize v0.61
v0.61.0
SQL
-
Improve and extend the base implementation of Role-based access control (RBAC):
-
Include
GRANT
,REVOKE
,ALTER DEFAULT PRIVILEGES
, andALTER OWNER
events in themz_audit_events
system catalog table. -
Require connection and secret
USAGE
privileges to executeCREATE SINK
commands.
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.
-
Bug fixes and other improvements
-
Do not require a valid active cluster to run specific types of queries, like
SELECT n
health checks (#20420). This fixes a known issue in thedbt-materialize
adapter, where specific commands that run such queries as part of their execution (e.g.dbt debug
) would fail in the absence of the pre-installeddefault
cluster. -
Extend
pg_catalog
andinformation_schema
system catalog coverage for compatibility with external tools like DBeaver and PopSQL (#20429) (#20314) (#20427). -
Avoid panicking in the presence of concurrent DDL and
UPDATE
,DELETE
, orINSERT INTO
statements (#20420).