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
Related
Palaute
https://aka.ms/ContentUserFeedback.
Tulossa pian: Vuoden 2024 aikana poistamme asteittain GitHub Issuesin käytöstä sisällön palautemekanismina ja korvaamme sen uudella palautejärjestelmällä. Lisätietoja on täällä:Lähetä ja näytä palaute kohteelle