Expand description
Built-in catalog items.
Builtins exist in the mz_catalog ambient schema. They are automatically
installed into the catalog when it is opened. Their definitions are not
persisted in the catalog, but hardcoded in this module. This makes it easy
to add new builtins, or change the definition of existing builtins, in new
versions of Materialize.
Builtin’s names, columns, and types are part of the stable API of Materialize. Be careful to maintain backwards compatibility when changing definitions of existing builtins!
More information about builtin system tables and types can be found in https://materialize.com/docs/sql/system-catalog/.
Modules§
Structs§
- Builtin
Cluster - Builtin
Cluster Replica - Builtin
Connection - Builtin
Continual Task - Builtin
Func - Builtin
Index - Note: When creating a built-in index, it’s usually best to choose a key that has only one
component. For example, if you created an index
ON mz_internal.mz_object_lifetimes (id, object_type), then this index couldn’t be used for a lookup forWHERE object_type = ..., and neither for joins keyed on justid. See https://materialize.com/docs/transform-data/optimization/#matching-multi-column-indexes-to-multi-column-where-clauses - Builtin
Log - Builtin
Role - Builtin
Source - Builtin
Table - Builtin
Type - Builtin
View
Enums§
- Builtin
- Unsafe
Builtin Table Fingerprint Whitespace - Allows tests to inject arbitrary amounts of whitespace to forcibly change the fingerprint and trigger a builtin migration.
Constants§
- ANALYTICS_
SELECT 🔒 - BUILTIN_
CLUSTERS - BUILTIN_
CLUSTER_ REPLICAS - BUILTIN_
CLUSTER_ 🔒REPLICA_ NAME - BUILTIN_
PREFIXES - BUILTIN_
ROLES - MONITOR_
REDACTED_ 🔒SELECT - MONITOR_
SELECT 🔒 - MZ_
ANALYTICS_ CLUSTER - MZ_
ANALYTICS_ ROLE - MZ_
CATALOG_ SERVER_ CLUSTER - MZ_
CATALOG_ SERVER_ CLUSTER_ REPLICA - MZ_
CLUSTERS_ IND - MZ_
CLUSTER_ DEPLOYMENT_ LINEAGE_ IND - MZ_
CLUSTER_ REPLICAS_ 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_ SIZES_ IND - MZ_
CLUSTER_ REPLICA_ STATUSES_ IND - MZ_
CLUSTER_ REPLICA_ STATUS_ HISTORY_ IND - MZ_
CLUSTER_ WORKLOAD_ CLASSES_ IND - MZ_
COLUMNS_ IND - MZ_
COMMENTS_ IND - MZ_
COMPUTE_ DEPENDENCIES_ IND - MZ_
CONNECTIONS_ IND - MZ_
CONSOLE_ CLUSTER_ UTILIZATION_ OVERVIEW_ IND - MZ_
CONTINUAL_ TASKS_ IND - MZ_
DATABASES_ IND - MZ_
FRONTIERS_ IND - MZ_
INDEXES_ IND - MZ_
KAFKA_ SOURCES_ IND - MZ_
MATERIALIZED_ VIEWS_ IND - MZ_
MONITOR_ REDACTED - This role is like
MZ_MONITOR_ROLE, but can only query the redacted versions of the objects. - MZ_
MONITOR_ ROLE - This role can
SELECTfrom various query history objects, e.g.mz_prepared_statement_history. - MZ_
OBJECTS_ IND - MZ_
OBJECT_ DEPENDENCIES_ IND - MZ_
OBJECT_ HISTORY_ IND - MZ_
OBJECT_ LIFETIMES_ IND - MZ_
OBJECT_ TRANSITIVE_ DEPENDENCIES_ IND - MZ_
PROBE_ CLUSTER - MZ_
PROBE_ CLUSTER_ REPLICA - MZ_
RECENT_ ACTIVITY_ LOG_ THINNED_ IND - MZ_
ROLES_ IND - MZ_
SCHEMAS_ IND - MZ_
SECRETS_ 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_ CONTINUAL_ TASKS_ 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_
SINKS_ IND - MZ_
SINK_ STATISTICS_ IND - MZ_
SINK_ STATUSES_ IND - MZ_
SINK_ STATUS_ HISTORY_ IND - MZ_
SOURCES_ IND - MZ_
SOURCE_ STATISTICS_ IND - MZ_
SOURCE_ STATISTICS_ WITH_ HISTORY_ IND - MZ_
SOURCE_ STATUSES_ IND - MZ_
SOURCE_ STATUS_ HISTORY_ IND - MZ_
SUPPORT_ CLUSTER - MZ_
SUPPORT_ ROLE - MZ_
SYSTEM_ CLUSTER - MZ_
SYSTEM_ CLUSTER_ REPLICA - MZ_
SYSTEM_ ROLE - MZ_
TABLES_ IND - MZ_
TYPES_ IND - MZ_
VIEWS_ IND - MZ_
WALLCLOCK_ GLOBAL_ LAG_ RECENT_ HISTORY_ IND - MZ_
WEBHOOK_ SOURCES_ IND - PG_
ATTRDEF_ ALL_ DATABASES_ IND - PG_
ATTRIBUTE_ ALL_ DATABASES_ IND - PG_
CLASS_ ALL_ DATABASES_ IND - PG_
DESCRIPTION_ ALL_ DATABASES_ IND - PG_
NAMESPACE_ ALL_ DATABASES_ IND - PG_
TYPE_ ALL_ DATABASES_ IND - PUBLIC_
SELECT 🔒 - RUNTIME_
ALTERABLE_ FINGERPRINT_ SENTINEL - A sentinel used in place of a fingerprint that indicates that a builtin object is runtime alterable. Runtime alterable objects don’t have meaningful fingerprints because they may have been intentionally changed by the user after creation.
- SUPPORT_
SELECT 🔒 - TYPE_
ACL_ ITEM - TYPE_
ACL_ ITEM_ ARRAY - TYPE_
ANY - TYPE_
ANYARRAY - TYPE_
ANYCOMPATIBLE - TYPE_
ANYCOMPATIBLEARRAY - TYPE_
ANYCOMPATIBLELIST - TYPE_
ANYCOMPATIBLEMAP - TYPE_
ANYCOMPATIBLENONARRAY - TYPE_
ANYCOMPATIBLERANGE - TYPE_
ANYELEMENT - TYPE_
ANYNONARRAY - TYPE_
ANYRANGE - TYPE_
BOOL - TYPE_
BOOL_ ARRAY - TYPE_
BPCHAR - TYPE_
BPCHAR_ ARRAY - TYPE_
BYTEA - TYPE_
BYTEA_ ARRAY - TYPE_
CHAR - TYPE_
CHAR_ ARRAY - TYPE_
DATE - TYPE_
DATE_ ARRAY - TYPE_
DATE_ RANGE - TYPE_
DATE_ RANGE_ ARRAY - TYPE_
FLOA T4 - TYPE_
FLOA T8 - TYPE_
FLOA T4_ ARRAY - TYPE_
FLOA T8_ ARRAY - TYPE_
INT2 - TYPE_
INT4 - TYPE_
INT8 - TYPE_
INT2_ ARRAY - TYPE_
INT2_ VECTOR - TYPE_
INT2_ VECTOR_ ARRAY - TYPE_
INT4_ ARRAY - TYPE_
INT4_ RANGE - TYPE_
INT4_ RANGE_ ARRAY - TYPE_
INT8_ ARRAY - TYPE_
INT8_ RANGE - TYPE_
INT8_ RANGE_ ARRAY - TYPE_
INTERNAL - TYPE_
INTERVAL - TYPE_
INTERVAL_ ARRAY - TYPE_
JSONB - TYPE_
JSONB_ ARRAY - TYPE_
LIST - TYPE_
MAP - TYPE_
MZ_ ACL_ ITEM - TYPE_
MZ_ ACL_ ITEM_ ARRAY - TYPE_
MZ_ TIMESTAMP - TYPE_
MZ_ TIMESTAMP_ ARRAY - TYPE_
NAME - TYPE_
NAME_ ARRAY - TYPE_
NUMERIC - TYPE_
NUMERIC_ ARRAY - TYPE_
NUM_ RANGE - TYPE_
NUM_ RANGE_ ARRAY - TYPE_
OID - TYPE_
OID_ ARRAY - TYPE_
RECORD - TYPE_
RECORD_ ARRAY - TYPE_
REGCLASS - TYPE_
REGCLASS_ ARRAY - TYPE_
REGPROC - TYPE_
REGPROC_ ARRAY - TYPE_
REGTYPE - TYPE_
REGTYPE_ ARRAY - TYPE_
TEXT - TYPE_
TEXT_ ARRAY - TYPE_
TIME - TYPE_
TIMESTAMP - TYPE_
TIMESTAMPTZ - TYPE_
TIMESTAMPTZ_ ARRAY - TYPE_
TIMESTAMP_ ARRAY - TYPE_
TIME_ ARRAY - TYPE_
TSTZ_ RANGE - TYPE_
TSTZ_ RANGE_ ARRAY - TYPE_
TS_ RANGE - TYPE_
TS_ RANGE_ ARRAY - TYPE_
UINT2 - TYPE_
UINT4 - TYPE_
UINT8 - TYPE_
UINT2_ ARRAY - TYPE_
UINT4_ ARRAY - TYPE_
UINT8_ ARRAY - TYPE_
UUID - TYPE_
UUID_ ARRAY - TYPE_
VARCHAR - TYPE_
VARCHAR_ ARRAY
Statics§
- BUILTINS_
STATIC - List of all builtin objects sorted topologically by dependency.
- BUILTIN_
LOG_ LOOKUP - BUILTIN_
LOOKUP - Keys are builtin object description, values are the builtin index when sorted by dependency and the builtin itself.
- INFORMATION_
SCHEMA_ APPLICABLE_ ROLES - INFORMATION_
SCHEMA_ CHARACTER_ SETS - INFORMATION_
SCHEMA_ COLUMNS - INFORMATION_
SCHEMA_ ENABLED_ ROLES - INFORMATION_
SCHEMA_ KEY_ COLUMN_ USAGE - INFORMATION_
SCHEMA_ REFERENTIAL_ CONSTRAINTS - INFORMATION_
SCHEMA_ ROLE_ TABLE_ GRANTS - INFORMATION_
SCHEMA_ ROUTINES - INFORMATION_
SCHEMA_ SCHEMATA - INFORMATION_
SCHEMA_ TABLES - INFORMATION_
SCHEMA_ TABLE_ CONSTRAINTS - INFORMATION_
SCHEMA_ TABLE_ PRIVILEGES - INFORMATION_
SCHEMA_ TRIGGERS - INFORMATION_
SCHEMA_ VIEWS - MZ_
ACTIVE_ PEEKS - MZ_
ACTIVE_ PEEKS_ PER_ WORKER - MZ_
ACTIVITY_ LOG_ THINNED - MZ_
AGGREGATES - MZ_
ANALYTICS - MZ_
ARRANGEMENT_ BATCHER_ ALLOCATIONS_ RAW - MZ_
ARRANGEMENT_ BATCHER_ CAPACITY_ RAW - MZ_
ARRANGEMENT_ BATCHER_ RECORDS_ RAW - MZ_
ARRANGEMENT_ BATCHER_ SIZE_ RAW - MZ_
ARRANGEMENT_ BATCHES_ RAW - MZ_
ARRANGEMENT_ HEAP_ ALLOCATIONS_ RAW - MZ_
ARRANGEMENT_ HEAP_ CAPACITY_ RAW - MZ_
ARRANGEMENT_ HEAP_ SIZE_ RAW - MZ_
ARRANGEMENT_ RECORDS_ RAW - MZ_
ARRANGEMENT_ SHARING - MZ_
ARRANGEMENT_ SHARING_ PER_ WORKER - MZ_
ARRANGEMENT_ SHARING_ RAW - MZ_
ARRANGEMENT_ SIZES - MZ_
ARRANGEMENT_ SIZES_ PER_ WORKER - MZ_
ARRAY_ TYPES - MZ_
AUDIT_ EVENTS - MZ_
AWS_ CONNECTIONS - MZ_
AWS_ PRIVATELINK_ CONNECTIONS - MZ_
AWS_ PRIVATELINK_ CONNECTION_ STATUSES - MZ_
AWS_ PRIVATELINK_ CONNECTION_ STATUS_ HISTORY - MZ_
BASE_ TYPES - MZ_
CLUSTERS - 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_ REPLICAS - MZ_
CLUSTER_ REPLICA_ FRONTIERS - MZ_
CLUSTER_ REPLICA_ FRONTIERS_ IND - MZ_
CLUSTER_ REPLICA_ HISTORY - MZ_
CLUSTER_ REPLICA_ METRICS - MZ_
CLUSTER_ REPLICA_ METRICS_ HISTORY - MZ_
CLUSTER_ REPLICA_ METRICS_ HISTORY_ CT - MZ_
CLUSTER_ REPLICA_ NAME_ HISTORY - MZ_
CLUSTER_ REPLICA_ SIZES - MZ_
CLUSTER_ REPLICA_ STATUSES - MZ_
CLUSTER_ REPLICA_ STATUS_ HISTORY - MZ_
CLUSTER_ REPLICA_ STATUS_ HISTORY_ CT - MZ_
CLUSTER_ REPLICA_ UTILIZATION - MZ_
CLUSTER_ REPLICA_ UTILIZATION_ HISTORY - MZ_
CLUSTER_ SCHEDULES - MZ_
CLUSTER_ WORKLOAD_ CLASSES - MZ_
COLUMNS - MZ_
COMMENTS - MZ_
COMPUTE_ DATAFLOW_ GLOBAL_ IDS_ PER_ WORKER - MZ_
COMPUTE_ DEPENDENCIES - MZ_
COMPUTE_ ERROR_ COUNTS - MZ_
COMPUTE_ ERROR_ COUNTS_ PER_ WORKER - MZ_
COMPUTE_ ERROR_ COUNTS_ RAW - MZ_
COMPUTE_ ERROR_ COUNTS_ RAW_ UNIFIED - MZ_
COMPUTE_ EXPORTS - MZ_
COMPUTE_ EXPORTS_ PER_ WORKER - MZ_
COMPUTE_ FRONTIERS - MZ_
COMPUTE_ FRONTIERS_ PER_ WORKER - MZ_
COMPUTE_ HYDRATION_ STATUSES - MZ_
COMPUTE_ HYDRATION_ TIMES - MZ_
COMPUTE_ HYDRATION_ TIMES_ IND - MZ_
COMPUTE_ HYDRATION_ TIMES_ PER_ WORKER - MZ_
COMPUTE_ IMPORT_ FRONTIERS - MZ_
COMPUTE_ IMPORT_ FRONTIERS_ PER_ WORKER - MZ_
COMPUTE_ LIR_ MAPPING_ PER_ WORKER - MZ_
COMPUTE_ OPERATOR_ DURATIONS_ HISTOGRAM - MZ_
COMPUTE_ OPERATOR_ DURATIONS_ HISTOGRAM_ PER_ WORKER - MZ_
COMPUTE_ OPERATOR_ DURATIONS_ HISTOGRAM_ RAW - MZ_
COMPUTE_ OPERATOR_ HYDRATION_ STATUSES - MZ_
COMPUTE_ OPERATOR_ HYDRATION_ STATUSES_ PER_ WORKER - MZ_
CONNECTIONS - 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_
CONTINUAL_ TASKS - MZ_
DATABASES - MZ_
DATAFLOWS - MZ_
DATAFLOWS_ PER_ WORKER - MZ_
DATAFLOW_ ADDRESSES - MZ_
DATAFLOW_ ADDRESSES_ PER_ WORKER - MZ_
DATAFLOW_ ARRANGEMENT_ SIZES - MZ_
DATAFLOW_ CHANNELS - MZ_
DATAFLOW_ CHANNELS_ PER_ WORKER - MZ_
DATAFLOW_ CHANNEL_ OPERATORS - MZ_
DATAFLOW_ CHANNEL_ OPERATORS_ PER_ WORKER - MZ_
DATAFLOW_ GLOBAL_ IDS - MZ_
DATAFLOW_ OPERATORS - MZ_
DATAFLOW_ OPERATORS_ PER_ WORKER - MZ_
DATAFLOW_ OPERATOR_ DATAFLOWS - MZ_
DATAFLOW_ OPERATOR_ DATAFLOWS_ PER_ WORKER - MZ_
DATAFLOW_ OPERATOR_ PARENTS - MZ_
DATAFLOW_ OPERATOR_ PARENTS_ PER_ WORKER - MZ_
DATAFLOW_ OPERATOR_ REACHABILITY - MZ_
DATAFLOW_ OPERATOR_ REACHABILITY_ PER_ WORKER - MZ_
DATAFLOW_ OPERATOR_ REACHABILITY_ RAW - MZ_
DATAFLOW_ SHUTDOWN_ DURATIONS_ HISTOGRAM - MZ_
DATAFLOW_ SHUTDOWN_ DURATIONS_ HISTOGRAM_ PER_ WORKER - MZ_
DATAFLOW_ SHUTDOWN_ DURATIONS_ HISTOGRAM_ RAW - MZ_
DEFAULT_ PRIVILEGES - MZ_
EGRESS_ IPS - MZ_
EXPECTED_ GROUP_ SIZE_ ADVICE - MZ_
FRONTIERS - MZ_
FUNCTIONS - MZ_
GLOBAL_ FRONTIERS - DEPRECATED and scheduled for removal! Use
mz_frontiersinstead. - MZ_
HISTORY_ RETENTION_ STRATEGIES - MZ_
HYDRATION_ STATUSES - MZ_
INDEXES - MZ_
INDEX_ ADVICE - MZ_
INDEX_ COLUMNS - MZ_
INTERNAL_ CLUSTER_ REPLICAS - MZ_
KAFKA_ CONNECTIONS - MZ_
KAFKA_ SINKS - MZ_
KAFKA_ SOURCES - MZ_
KAFKA_ SOURCE_ TABLES - MZ_
LIR_ MAPPING - MZ_
LIST_ TYPES - MZ_
MAPPABLE_ OBJECTS - MZ_
MAP_ TYPES - MZ_
MATERIALIZATION_ DEPENDENCIES - MZ_
MATERIALIZATION_ LAG - MZ_
MATERIALIZED_ VIEWS - MZ_
MATERIALIZED_ VIEW_ REFRESHES - MZ_
MATERIALIZED_ VIEW_ REFRESH_ STRATEGIES - MZ_
MESSAGE_ BATCH_ COUNTS_ RECEIVED_ RAW - MZ_
MESSAGE_ BATCH_ COUNTS_ SENT_ RAW - MZ_
MESSAGE_ COUNTS - MZ_
MESSAGE_ COUNTS_ PER_ WORKER - MZ_
MESSAGE_ COUNTS_ RECEIVED_ RAW - MZ_
MESSAGE_ COUNTS_ SENT_ RAW - MZ_
MYSQL_ SOURCE_ TABLES - MZ_
NETWORK_ POLICIES - MZ_
NETWORK_ POLICY_ RULES - MZ_
OBJECTS - MZ_
OBJECTS_ ID_ NAMESPACE_ TYPES - MZ_
OBJECT_ DEPENDENCIES - MZ_
OBJECT_ FULLY_ QUALIFIED_ NAMES - MZ_
OBJECT_ HISTORY - MZ_
OBJECT_ LIFETIMES - MZ_
OBJECT_ OID_ ALIAS - MZ_
OBJECT_ TRANSITIVE_ DEPENDENCIES - MZ_
OPERATORS - MZ_
PEEK_ DURATIONS_ HISTOGRAM - MZ_
PEEK_ DURATIONS_ HISTOGRAM_ PER_ WORKER - MZ_
PEEK_ DURATIONS_ HISTOGRAM_ RAW - MZ_
PENDING_ CLUSTER_ REPLICAS - MZ_
POSTGRES_ SOURCES - MZ_
POSTGRES_ SOURCE_ TABLES - MZ_
PREPARED_ STATEMENT_ HISTORY - MZ_
PSEUDO_ TYPES - 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_
RECENT_ STORAGE_ USAGE - MZ_
RECENT_ STORAGE_ USAGE_ IND - MZ_
RECORDS_ PER_ DATAFLOW - MZ_
RECORDS_ PER_ DATAFLOW_ OPERATOR - MZ_
RECORDS_ PER_ DATAFLOW_ OPERATOR_ PER_ WORKER - MZ_
RECORDS_ PER_ DATAFLOW_ PER_ WORKER - MZ_
RELATIONS - MZ_
ROLES - MZ_
ROLE_ MEMBERS - MZ_
ROLE_ PARAMETERS - MZ_
SCHEDULING_ ELAPSED - MZ_
SCHEDULING_ ELAPSED_ PER_ WORKER - MZ_
SCHEDULING_ ELAPSED_ RAW - MZ_
SCHEDULING_ PARKS_ HISTOGRAM - MZ_
SCHEDULING_ PARKS_ HISTOGRAM_ PER_ WORKER - MZ_
SCHEDULING_ PARKS_ HISTOGRAM_ RAW - MZ_
SCHEMAS - MZ_
SECRETS - 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_ CONTINUAL_ TASKS - 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_
SINKS - MZ_
SINK_ STATISTICS - MZ_
SINK_ STATISTICS_ RAW - MZ_
SINK_ STATUSES - MZ_
SINK_ STATUS_ HISTORY - MZ_
SOURCES - 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_
SSH_ TUNNEL_ CONNECTIONS - MZ_
STATEMENT_ EXECUTION_ HISTORY - MZ_
STATEMENT_ EXECUTION_ HISTORY_ REDACTED - MZ_
STATEMENT_ LIFECYCLE_ HISTORY - MZ_
STORAGE_ SHARDS - MZ_
STORAGE_ USAGE - MZ_
STORAGE_ USAGE_ BY_ SHARD - MZ_
STORAGE_ USAGE_ BY_ SHARD_ DESCRIPTION - MZ_
SUBSCRIPTIONS - MZ_
SYSTEM_ PRIVILEGES - MZ_
TABLES - MZ_
TIMEZONE_ ABBREVIATIONS - MZ_
TIMEZONE_ NAMES - MZ_
TYPES - 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_
VIEWS - 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_
WALLCLOCK_ LAG_ HISTORY_ CT - MZ_
WEBHOOKS_ SOURCES - PG_
ACCESS_ METHODS - PG_
AGGREGATE - PG_
ATTRDEF - PG_
ATTRDEF_ ALL_ DATABASES - Peeled version of
PG_ATTRDEF: - PG_
ATTRIBUTE - PG_
ATTRIBUTE_ ALL_ DATABASES - Peeled version of
PG_ATTRIBUTE: - PG_
AUTHID - PG_
AUTH_ MEMBERS - PG_
CLASS - PG_
CLASS_ ALL_ DATABASES - Peeled version of
PG_CLASS: - PG_
COLLATION - PG_
CONSTRAINT - PG_
DATABASE - PG_
DEPEND - PG_
DESCRIPTION - Note: Databases, Roles, Clusters, Cluster Replicas, Secrets, and Connections are excluded from this view for Postgres compatibility. Specifically, there is no classoid for these objects, which is required for this view.
- PG_
DESCRIPTION_ ALL_ DATABASES - Peeled version of
PG_DESCRIPTION: - PG_ENUM
- PG_
EVENT_ TRIGGER - PG_
EXTENSION - PG_
INDEX - PG_
INDEXES - PG_
INHERITS - PG_
LANGUAGE - PG_
LOCKS - PG_
MATVIEWS - PG_
NAMESPACE - PG_
NAMESPACE_ ALL_ DATABASES - Peeled version of
PG_NAMESPACE: - PG_
OPERATOR - PG_
POLICY - PG_PROC
- PG_
RANGE - PG_
REWRITE - PG_
ROLES - PG_
SETTINGS - PG_
SHDESCRIPTION - PG_
TABLES - PG_
TABLESPACE - PG_
TIMEZONE_ ABBREVS - PG_
TIMEZONE_ NAMES - PG_
TRIGGER - PG_TYPE
- PG_
TYPE_ ALL_ DATABASES - Peeled version of
PG_TYPE: - PG_USER
- PG_
VIEWS - UNSAFE_
DO_ NOT_ CALL_ THIS_ IN_ PRODUCTION_ BUILTIN_ TABLE_ FINGERPRINT_ WHITESPACE
Traits§
- Fingerprint
- Uniquely identifies the definition of a builtin object.