SHOW CONNECTIONS
SHOW CONNECTIONS lists the connections configured in Materialize.
Syntax
SHOW CONNECTIONS
[FROM <schema_name>]
[LIKE <pattern> | WHERE <condition(s)>]
| Option | Description |
|---|---|
| FROM <schema_name> | If specified, only show connections from the specified schema. For available schema names, see SHOW SCHEMAS. |
| LIKE <pattern> | If specified, only show connections that match the pattern. |
| WHERE <condition(s)> | If specified, only show connections that match the condition(s). |
Examples
SHOW CONNECTIONS;
name | type
---------------------+---------
kafka_connection | kafka
postgres_connection | postgres
SHOW CONNECTIONS LIKE 'kafka%';
name | type
------------------+------
kafka_connection | kafka