Jaa


CONNECTIONS

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

INFORMATION_SCHEMA.CONNECTIONS describes foreign connections.

Information is displayed only for connections the user has permission to interact with.

This is an extension to the SQL Standard Information Schema.

Definition

The CONNECTIONS relation contains the following columns:

Name Data type Nullable Description
CONNECTION_NAME STRING No Name of the connection.
CONNECTION_TYPE STRING No The type of the connection, e.g. REDSHIFT, SNOWFLAKE, MYSQL, POSTGRESQL
CONNECTION_OWNER STRING No Owner of the connection.
COMMENT STRING Yes An optional comment that describes the connection.
CREATED TIMESTAMP No Timestamp when the catalog was created.
CREATED_BY STRING No Principal who created the connection.
CREDENTIAL_TYPE STRING No Type of the credential like ‘USERNAME_PASSWORD’, ‘OAUTH’
LAST_ALTERED TIMESTAMP No Timestamp when the connection was last altered in any way.
LAST_ALTERED_BY STRING No Principal who last altered the connection.
CONNECTION_OPTIONS STRING Yes A subset of the options used to establish the connection.
URL STRING No The URL of the connection.

Constraints

The following constraints apply to the CONNECTION relation:

Class Name Column List Description
Primary key CONNECTIONS_PK CONNECTION_NAME Unique identifier for the connection.

Examples

> SELECT connection_owner
    FROM information_schema.connections