CONNECTIONS

Applies to: Databricks SQL Databricks Runtime 13.3 LTS and above 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

SQL

> SELECT connection_owner
    FROM information_schema.connections

Related

• DESCRIBE CONNECTION
• Information schema
• INFORMATION_SCHEMA.CONNECTION_PRIVILEGES
• SHOW CONNECTIONS