SHOW Commands

-- Show all materialized views
SHOW MATERIALIZED VIEWS;

-- Show all sources
SHOW SOURCES;

-- Show all clusters
SHOW CLUSTERS;

-- Show views in a specific schema
SHOW VIEWS FROM my_schema;

-- Show tables in a specific database and schema
SHOW TABLES FROM my_database.my_schema;

-- Show views matching a pattern
SHOW VIEWS LIKE 'order%';

-- Show sources in a schema matching a pattern
SHOW SOURCES FROM my_schema LIKE '%kafka%';

-- Show columns of a table
SHOW COLUMNS FROM orders;

-- Show the SQL used to create a view
SHOW CREATE VIEW my_view;

-- Show indexes on a specific object
SHOW INDEXES ON orders;

-- Show all sources and their status
SHOW SOURCES;

-- Check subsources for a PostgreSQL source
SHOW SUBSOURCES FROM pg_source;

-- Verify materialized views exist
SHOW MATERIALIZED VIEWS LIKE 'orders%';

-- Check if indexes are defined
SHOW INDEXES ON order_totals;

-- List all clusters and their replicas
SHOW CLUSTERS;
SHOW CLUSTER REPLICAS;

-- Find objects on a specific cluster
SELECT name, type FROM mz_catalog.mz_objects
WHERE cluster_id = (
    SELECT id FROM mz_catalog.mz_clusters WHERE name = 'my_cluster'
);

-- List all roles
SHOW ROLES;

-- Show role membership
SHOW ROLE MEMBERSHIP;

-- List secrets (names only, not values)
SHOW SECRETS;

-- Show connections
SHOW CONNECTIONS;

-- Show CREATE for different object types
SHOW CREATE VIEW my_view;
SHOW CREATE MATERIALIZED VIEW my_mv;
SHOW CREATE SOURCE my_source;
SHOW CREATE SINK my_sink;
SHOW CREATE TABLE my_table;
SHOW CREATE INDEX my_index;

SHOW CLUSTERS;

     name     | replicas
--------------+----------
 quickstart   | 1
 ingest       | 2
 compute      | 3