SHOW CREATE CONNECTION

SHOW CREATE CONNECTION returns the DDL statement used to create the connection.

Syntax

SHOW CREATE CONNECTION connection_name
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.
Back to top ↑