Materialize/doc/user/content/releases/v0.62.md

---

title: "Materialize v0.62" date: 2023-07-26 released: true

patch: 4

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 involving string timestamps (e.g. extracted from jsonb 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 specified user has USAGE or MEMBER privileges for a specified role.

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

• Extend information_schema system catalog coverage with RBAC-specific views:

  • applicable_roles
  • enabled_roles
  • role_table_grants
  • table_privileges