Materialize v0.62
v0.62.0
Sources and sinks
- Support adding individual subsources in the PostgreSQL source
using the new
ALTER SOURCE...ADD SUBSOURCE
syntax.
SQL
-
Add the
try_parse_monotonic_iso8601_timestamp
function, which should be used in temporal filters involvingstring
timestamps (e.g. extracted fromjsonb
columns) 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_role
function, which reports if a specifieduser
hasUSAGE
orMEMBER
privileges 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_schema
system catalog coverage with RBAC-specific views: