Materialize v0.62
v0.62.0
Sources and sinks
- Support adding individual subsources in the PostgreSQL source
using the new
ALTER SOURCE...ADD SUBSOURCEsyntax.
SQL
-
Add the
try_parse_monotonic_iso8601_timestampfunction, which should be used in temporal filters involvingstringtimestamps (e.g. extracted fromjsonbcolumns) to benefit from filter pushdown optimization.For a given JSON-formatted source, the following query cannot benefit from filter pushdown:
SELECT * FROM foo WHERE (data ->> 'timestamp')::timestamp > mz_now();But can be optimized as:
SELECT * FROM foo WHERE try_parse_monotonic_iso8601_timestamp(data ->> 'timestamp') > mz_now();It’s important to note that temporal filter pushdown is disabled by default. You must contact us to enable this feature in your Materialize region.
-
Improve and extend the base implementation of Role-based access control (RBAC):
- Add the
pg_has_rolefunction, which reports if a specifieduserhasUSAGEorMEMBERprivileges for a specifiedrole.
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.
- Add the
Bug fixes and other improvements
-
Extend
information_schemasystem catalog coverage with RBAC-specific views: