CONNECTIONS

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 13.1 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