EXTERNAL_LOCATIONS
Applies to: 
Databricks SQL Databricks Runtime 10.4 LTS and above
INFORMATION_SCHEMA.EXTERNAL_LOCATIONS describes external locations.
Information is displayed only for external locations the user has permission to interact with.
This is an extension to the SQL Standard Information Schema.
Definition
The EXTERNAL_LOCATIONS relation contains the following columns:
| Name | Data type | Nullable | Description |
|---|---|---|---|
EXTERNAL_LOCATION_NAME | STRING | No | Name of the external location. |
EXTERNAL_LOCATION_OWNER | STRING | No | Owner of the external location. |
URL | STRING | No | Path URL of the external location. |
STORAGE_CREDENTIAL_ID | STRING | No | ID of the storage credential to access URL. |
STORAGE_CREDENTIAL_NAME | STRING | No | Name of the storage credential to access URL. |
READ_ONLY | STRING | No | Whether the external location is read-only. |
COMMENT | STRING | Yes | An optional comment that describes the external location. |
CREATED | TIMESTAMP | No | Timestamp when the external location was created. |
CREATED_BY | STRING | No | Principal who created the external location. |
LAST_ALTERED | TIMESTAMP | No | Timestamp when the external location was last altered in any way. |
LAST_ALTERED_BY | STRING | No | Principal who last altered the external location. |
Constraints
The following constraints apply to the EXTERNAL_LOCATIONS relation:
| Class | Name | Column List | Description |
|---|---|---|---|
| Primary key | EXTERNAL_LOCATIONS_PK | EXTERNAL_LOCATION_NAME | Unique identifier for the external location. |
| Foreign key | EXTERNAL_LOCATIONS_CREDS_FK | STORAGE_CREDENTIAL_ID, STORAGE_CREDENTIAL_NAME | References STORAGE_CREDENTIALS |
Examples
SQL
> SELECT external_location_owner
FROM information_schema.external_locations