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.

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.

The following constraints apply to the CONNECTION relation:

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

SQL
> SELECT connection_owner
    FROM information_schema.connections