Expand description
Read-only catalog introspection queries.
Methods on IntrospectionClient query the mz_catalog and
information_schema to inspect the live environment without modifying it.
Provides batch existence checks for schemas, clusters, and objects, as well
as dependency lookups used during deployment planning and sink repointing.
Structsยง
- Dependent
Sink - A sink that depends on an object in a schema being dropped.
Functionsยง
- check_
catalog_ ๐objects_ exist - Check which objects from the given set exist in a specific catalog table.
- check_
clusters_ ๐exist - Check which clusters from a set of names exist.
- check_
connection_ ๐exists - Check if a connection exists in the specified database and schema.
- check_
connections_ ๐exist - Check which connections from the given set exist in the database.
- check_
objects_ ๐exist - Check which objects from a set exist in the production database.
- check_
schemas_ ๐exist - Check which schemas from a set of (database, schema) pairs exist.
- check_
secrets_ ๐exist - Check which secrets from the given set exist in the database.
- check_
sinks_ ๐exist - Check which sinks from the given set exist in the database.
- check_
sources_ ๐exist - Check which sources from the given set exist in the database.
- check_
tables_ ๐exist - Check which tables from the given set exist in the database.
- cluster_
exists ๐ - Check if a cluster exists.
- drop_
objects ๐ - Drop specific objects by their ObjectIds.
- drop_
schema_ ๐objects - Drop all objects in a schema.
- drop_
staging_ ๐clusters - Drop staging clusters by name.
- drop_
staging_ ๐schemas - Drop staging schemas by name.
- find_
sinks_ ๐depending_ on_ schemas - Find sinks that depend on objects in the specified schemas.
- get_
cluster ๐ - Get a cluster by name.
- get_
cluster_ ๐config - Get cluster configuration including replicas and grants.
- get_
cluster_ ๐grants - Get privilege grants on a cluster by name.
- get_
connection_ ๐create_ sql - Get the
CREATE CONNECTIONSQL for an existing connection. - get_
current_ ๐user - Get the current Materialize user/role.
- get_
database_ ๐object_ grants - Get privilege grants on a database object (table, source, secret, connection).
- get_
default_ ๐privilege_ grants_ for_ cluster - Get default privilege grants for a cluster by name.
- get_
default_ ๐privilege_ grants_ for_ database_ object - Get default privilege grants for a database object (table, source, secret, connection).
- get_
default_ ๐privilege_ grants_ for_ named_ object - Get default privilege grants for a named infrastructure object (cluster, network policy).
- get_
default_ ๐privilege_ grants_ for_ network_ policy - Get default privilege grants for a network policy by name.
- get_
named_ ๐object_ grants - Get privilege grants on a named infrastructure object (cluster, network policy).
- get_
network_ ๐policy_ grants - Get privilege grants on a network policy by name.
- get_
role_ ๐members - Get the members granted to a role.
- get_
role_ ๐parameters - Get session default parameter names for a role.
- get_
staging_ ๐clusters - Get staging cluster names for a specific deployment.
- get_
staging_ ๐schemas - Get staging schema names for a specific deployment.
- list_
clusters ๐ - List all clusters.
- mz_
type_ ๐to_ drop_ keyword - Map a Materialize object type string to its DROP keyword.
- network_
policy_ ๐exists - Check if a network policy exists.
- object_
exists ๐ - Check if an object (MV, table, source) exists in the specified schema.
- role_
exists ๐ - Check if a role exists.
- schema_
exists ๐ - Check if a schema exists in the specified database.