SHOW CREATE CONNECTION
SHOW CREATE CONNECTION returns the DDL statement used to create the connection.
Syntax
SHOW [REDACTED] CREATE CONNECTION <connection_name> | Option | Description |
|---|---|
| REDACTED | If specified, literals will be redacted. |
For available connection names, 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.us-east-1.aws.confluent.cloud: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.