Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
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. |
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 |
> SELECT external_location_owner
FROM information_schema.external_locations