SHOW CREATE CONNECTION
SHOW CREATE CONNECTION returns the DDL statement used to create the connection.
Syntax
| Field | Use |
|---|---|
| connection_name | The connection you want to get the CREATE statement for. For available connections, see SHOW CONNECTIONS. |
Examples
SHOW CREATE CONNECTION kafka_connection;
name | create_sql
------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
kafka_connection | CREATE CONNECTION "materialize"."public"."kafka_connection" TO KAFKA (BROKER 'unique-jellyfish-0000-kafka.upstash.io:9092', SASL MECHANISMS = 'PLAIN', SASL USERNAME = SECRET sasl_username, SASL PASSWORD = SECRET sasl_password)
Privileges
The privileges required to execute this statement are:
USAGEprivileges on the schema containing the connection.