Skip to main content

DESCRIBE CONNECTION

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

Returns the metadata of an existing connection. The metadata information includes connection name, comment, owner and select options.

Syntax

{ DESC | DESCRIBE } CONNECTION connection_name

You can also specify SERVER instead of CONNECTION.

Parameters

  • connection_name: The name of an existing connection in the Unity Catalog metastore. If the name does not exist, an exception is thrown.

Returns

A report with the following rows:

  • name: The name of the connection.
  • Connection Type: The type of the connection.
  • Credential Type: The type of the credential (e.g. username_password)
  • Url: The URL of the remote server.
  • Owner: The principal that owns the connection.
  • Created At: The timestamp when the connection was created, in ISO 8601 format.
  • Created By: The principal who created the connection.
  • Comment: User specified comments, if any.
  • Options: A selective list of options that are considered safe to display.

Examples

SQL
> DESCRIBE CONNECTION postgresql_connection;
---- ---------------------
name postgresql_connection
Connection Type postgresql
Credential Type username_password
Url jdbc://...
Owner alf@melmak.et
Created At 2022-01-01T00:00:00.000+0000
Created By alf@melmak.et
Comment This is a postgresql connection
Options ((host, '...'), (port, '5432'), ...)