Skip to main content

SHOW CONNECTIONS

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 13.3 LTS and above

Lists all the connections in the system.

Syntax​

SHOW CONNECTIONS

You can also use SERVERS instead of CONNECTIONS.

Parameters​

None

Returns​

A result set of connections with the following columns:

  • name STRING NOT NULL: names of connections in the metastore.
  • connection_type STRING NOT NULL: The type of the connection. For example: postgresql.
  • created_at STRING NOT NULL: The timestamp when the connection was created, in ISO 8601 format.
  • created_by STRING NOT NULL: The principal who created the connection.
  • comment STRING : An optional user specified comment on a connection.

Examples​

SQL
> SHOW CONNECTIONS;
 name                connection_type created_at                   created_by    comment
 ------------------- --------------- ---------------------------- ------------- ---------------------
 mysql_connection    mysql           2022-01-01T00:00:00.000+0000 alf@melmak.et mysql connection
 postgres_connection postgresql      2022-06-12T13:30:00.000+0000 alf@melmak.et postgresql connection
Last updated on