Expand description
Built-in catalog items for the mz_internal schema.
Constants§
- MZ_
CLUSTER_ DEPLOYMENT_ LINEAGE_ IND - MZ_
CLUSTER_ REPLICA_ HISTORY_ IND - MZ_
CLUSTER_ REPLICA_ METRICS_ HISTORY_ IND - MZ_
CLUSTER_ REPLICA_ METRICS_ IND - MZ_
CLUSTER_ REPLICA_ NAME_ HISTORY_ IND - MZ_
CLUSTER_ REPLICA_ STATUSES_ IND - MZ_
CLUSTER_ REPLICA_ STATUS_ HISTORY_ IND - MZ_
CLUSTER_ WORKLOAD_ CLASSES_ IND - MZ_
COMMENTS_ IND - MZ_
COMPUTE_ DEPENDENCIES_ IND - MZ_
CONSOLE_ CLUSTER_ UTILIZATION_ OVERVIEW_ IND - MZ_
FRONTIERS_ IND - MZ_
HYDRATION_ STATUSES_ IND - MZ_
OBJECT_ DEPENDENCIES_ IND - MZ_
OBJECT_ HISTORY_ IND - MZ_
OBJECT_ LIFETIMES_ IND - MZ_
OBJECT_ TRANSITIVE_ DEPENDENCIES_ IND - MZ_
RECENT_ ACTIVITY_ LOG_ THINNED_ IND - MZ_
SHOW_ ALL_ OBJECTS_ IND - MZ_
SHOW_ CLUSTERS_ IND - MZ_
SHOW_ CLUSTER_ REPLICAS_ IND - MZ_
SHOW_ COLUMNS_ IND - MZ_
SHOW_ CONNECTIONS_ IND - MZ_
SHOW_ DATABASES_ IND - MZ_
SHOW_ INDEXES_ IND - MZ_
SHOW_ MATERIALIZED_ VIEWS_ IND - MZ_
SHOW_ ROLES_ IND - MZ_
SHOW_ SCHEMAS_ IND - MZ_
SHOW_ SECRETS_ IND - MZ_
SHOW_ SINKS_ IND - MZ_
SHOW_ SOURCES_ IND - MZ_
SHOW_ TABLES_ IND - MZ_
SHOW_ TYPES_ IND - MZ_
SHOW_ VIEWS_ IND - MZ_
SINK_ STATISTICS_ IND - MZ_
SINK_ STATUSES_ IND - MZ_
SINK_ STATUS_ HISTORY_ IND - MZ_
SOURCE_ STATISTICS_ IND - MZ_
SOURCE_ STATISTICS_ WITH_ HISTORY_ IND - MZ_
SOURCE_ STATUSES_ IND - MZ_
SOURCE_ STATUS_ HISTORY_ IND - MZ_
WALLCLOCK_ GLOBAL_ LAG_ RECENT_ HISTORY_ IND - MZ_
WEBHOOK_ SOURCES_ IND - PG_
ATTRDEF_ ALL_ DATABASES_ IND - PG_
ATTRIBUTE_ ALL_ DATABASES_ IND - PG_
AUTHID_ CORE_ IND - PG_
CLASS_ ALL_ DATABASES_ IND - PG_
DESCRIPTION_ ALL_ DATABASES_ IND - PG_
NAMESPACE_ ALL_ DATABASES_ IND - PG_
TYPE_ ALL_ DATABASES_ IND
Statics§
- MZ_
ACTIVITY_ LOG_ THINNED - MZ_
AGGREGATES - MZ_
ANALYTICS - MZ_
AWS_ CONNECTIONS - MZ_
AWS_ PRIVATELINK_ CONNECTION_ STATUSES - MZ_
AWS_ PRIVATELINK_ CONNECTION_ STATUS_ HISTORY - MZ_
CATALOG_ RAW - MZ_
CLUSTER_ DEPLOYMENT_ LINEAGE - Traces the blue/green deployment lineage in the audit log to determine all cluster IDs that are logically the same cluster. cluster_id: The ID of a cluster. current_deployment_cluster_id: The cluster ID of the last cluster in cluster_id’s blue/green lineage. cluster_name: The name of the cluster. The approach taken is as follows. First, find all extant clusters and add them to the result set. Per cluster, we do the following:
- MZ_
CLUSTER_ REPLICA_ HISTORY - MZ_
CLUSTER_ REPLICA_ METRICS - MZ_
CLUSTER_ REPLICA_ METRICS_ HISTORY - MZ_
CLUSTER_ REPLICA_ NAME_ HISTORY - MZ_
CLUSTER_ REPLICA_ STATUSES - MZ_
CLUSTER_ REPLICA_ STATUS_ HISTORY - MZ_
CLUSTER_ REPLICA_ UTILIZATION - MZ_
CLUSTER_ REPLICA_ UTILIZATION_ HISTORY - MZ_
CLUSTER_ SCHEDULES - MZ_
CLUSTER_ WORKLOAD_ CLASSES - MZ_
COMMENTS - MZ_
COMPUTE_ DEPENDENCIES - MZ_
COMPUTE_ ERROR_ COUNTS_ RAW_ UNIFIED - MZ_
COMPUTE_ HYDRATION_ STATUSES - MZ_
COMPUTE_ HYDRATION_ TIMES - MZ_
COMPUTE_ HYDRATION_ TIMES_ IND - MZ_
COMPUTE_ OPERATOR_ HYDRATION_ STATUSES - MZ_
CONSOLE_ CLUSTER_ UTILIZATION_ OVERVIEW - This view is used to display the cluster utilization over 14 days bucketed by 8 hours. It’s specifically for the Console’s environment overview page to speed up load times. This query should be kept in sync with MaterializeInc/console/src/api/materialize/cluster/replicaUtilizationHistory.ts
- MZ_
FRONTIERS - MZ_
GLOBAL_ FRONTIERS - DEPRECATED and scheduled for removal! Use
mz_frontiersinstead. - MZ_
HISTORY_ RETENTION_ STRATEGIES - MZ_
HYDRATION_ STATUSES - MZ_
INDEX_ ADVICE - MZ_
INTERNAL_ CLUSTER_ REPLICAS - MZ_
KAFKA_ SOURCE_ TABLES - MZ_
LICENSE_ KEYS - MZ_
MATERIALIZATION_ DEPENDENCIES - MZ_
MATERIALIZATION_ LAG - MZ_
MATERIALIZED_ VIEW_ REFRESHES - MZ_
MATERIALIZED_ VIEW_ REFRESH_ STRATEGIES - MZ_
MCP_ DATA_ PRODUCTS - Lightweight data product discovery for MCP (Model Context Protocol).
- MZ_
MCP_ DATA_ PRODUCT_ DETAILS - Full data product details with JSON Schema for MCP agents.
- MZ_
MYSQL_ SOURCE_ TABLES - MZ_
NETWORK_ POLICIES - MZ_
NETWORK_ POLICY_ RULES - MZ_
OBJECTS_ ID_ NAMESPACE_ TYPES - MZ_
OBJECT_ ARRANGEMENT_ SIZES_ IND - MZ_
OBJECT_ ARRANGEMENT_ SIZES_ UNIFIED - MZ_
OBJECT_ ARRANGEMENT_ SIZE_ HISTORY - MZ_
OBJECT_ ARRANGEMENT_ SIZE_ HISTORY_ OBJECT_ IND - MZ_
OBJECT_ ARRANGEMENT_ SIZE_ HISTORY_ TS_ IND - MZ_
OBJECT_ DEPENDENCIES - MZ_
OBJECT_ FULLY_ QUALIFIED_ NAMES - MZ_
OBJECT_ GLOBAL_ IDS - MZ_
OBJECT_ HISTORY - MZ_
OBJECT_ LIFETIMES - MZ_
OBJECT_ OID_ ALIAS - MZ_
OBJECT_ TRANSITIVE_ DEPENDENCIES - MZ_
PENDING_ CLUSTER_ REPLICAS - MZ_
POSTGRES_ SOURCES - MZ_
POSTGRES_ SOURCE_ TABLES - MZ_
PREPARED_ STATEMENT_ HISTORY - MZ_
RECENT_ ACTIVITY_ LOG - MZ_
RECENT_ ACTIVITY_ LOG_ REDACTED - MZ_
RECENT_ ACTIVITY_ LOG_ THINNED - MZ_
RECENT_ SQL_ TEXT - MZ_
RECENT_ SQL_ TEXT_ IND - MZ_
RECENT_ SQL_ TEXT_ REDACTED - MZ_
REPLACEMENTS - MZ_
SESSIONS - MZ_
SESSION_ HISTORY - MZ_
SHOW_ ALL_ MY_ PRIVILEGES - MZ_
SHOW_ ALL_ OBJECTS - MZ_
SHOW_ ALL_ PRIVILEGES - MZ_
SHOW_ CLUSTERS - MZ_
SHOW_ CLUSTER_ PRIVILEGES - MZ_
SHOW_ CLUSTER_ REPLICAS - MZ_
SHOW_ COLUMNS - MZ_
SHOW_ CONNECTIONS - MZ_
SHOW_ DATABASES - MZ_
SHOW_ DATABASE_ PRIVILEGES - MZ_
SHOW_ DEFAULT_ PRIVILEGES - MZ_
SHOW_ INDEXES - MZ_
SHOW_ MATERIALIZED_ VIEWS - MZ_
SHOW_ MY_ CLUSTER_ PRIVILEGES - MZ_
SHOW_ MY_ DATABASE_ PRIVILEGES - MZ_
SHOW_ MY_ DEFAULT_ PRIVILEGES - MZ_
SHOW_ MY_ OBJECT_ PRIVILEGES - MZ_
SHOW_ MY_ ROLE_ MEMBERS - MZ_
SHOW_ MY_ SCHEMA_ PRIVILEGES - MZ_
SHOW_ MY_ SYSTEM_ PRIVILEGES - MZ_
SHOW_ NETWORK_ POLICIES - MZ_
SHOW_ OBJECT_ PRIVILEGES - MZ_
SHOW_ ROLES - MZ_
SHOW_ ROLE_ MEMBERS - MZ_
SHOW_ SCHEMAS - MZ_
SHOW_ SCHEMA_ PRIVILEGES - MZ_
SHOW_ SECRETS - MZ_
SHOW_ SINKS - MZ_
SHOW_ SOURCES - MZ_
SHOW_ SYSTEM_ PRIVILEGES - MZ_
SHOW_ TABLES - MZ_
SHOW_ TYPES - MZ_
SHOW_ VIEWS - MZ_
SINK_ STATISTICS - MZ_
SINK_ STATISTICS_ RAW - MZ_
SINK_ STATUSES - MZ_
SINK_ STATUS_ HISTORY - MZ_
SOURCE_ REFERENCES - MZ_
SOURCE_ STATISTICS - MZ_
SOURCE_ STATISTICS_ RAW - MZ_
SOURCE_ STATISTICS_ WITH_ HISTORY - MZ_
SOURCE_ STATUSES - MZ_
SOURCE_ STATUS_ HISTORY - MZ_
SQL_ SERVER_ SOURCE_ TABLES - MZ_
SQL_ TEXT - MZ_
SQL_ TEXT_ REDACTED - MZ_
STATEMENT_ EXECUTION_ HISTORY - MZ_
STATEMENT_ EXECUTION_ HISTORY_ REDACTED - MZ_
STATEMENT_ LIFECYCLE_ HISTORY - MZ_
STORAGE_ SHARDS - MZ_
STORAGE_ USAGE_ BY_ SHARD - MZ_
SUBSCRIPTIONS - MZ_
TYPE_ PG_ METADATA - PostgreSQL-specific metadata about types that doesn’t make sense to expose
in the
mz_typestable as part of our public, stable API. - MZ_
WALLCLOCK_ GLOBAL_ LAG - MZ_
WALLCLOCK_ GLOBAL_ LAG_ HISTOGRAM - MZ_
WALLCLOCK_ GLOBAL_ LAG_ HISTOGRAM_ RAW - MZ_
WALLCLOCK_ GLOBAL_ LAG_ HISTORY - MZ_
WALLCLOCK_ GLOBAL_ LAG_ RECENT_ HISTORY - MZ_
WALLCLOCK_ LAG_ HISTORY - MZ_
WEBHOOKS_ SOURCES - PG_
ATTRDEF_ ALL_ DATABASES - Peeled version of
PG_ATTRDEF: - PG_
ATTRIBUTE_ ALL_ DATABASES - Peeled version of
PG_ATTRIBUTE: - PG_
AUTHID_ CORE - Peeled version of
PG_AUTHID: Excludes the columns rolcreaterole and rolcreatedb, to make this view indexable. - PG_
CLASS_ ALL_ DATABASES - Peeled version of
PG_CLASS: - PG_
DESCRIPTION_ ALL_ DATABASES - Peeled version of
PG_DESCRIPTION: - PG_
NAMESPACE_ ALL_ DATABASES - Peeled version of
PG_NAMESPACE: - PG_
TYPE_ ALL_ DATABASES - Peeled version of
PG_TYPE: