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
> SELECT connection_owner
FROM information_schema.connections