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:
USAGE
privileges on the schema containing the connection.