EXTERNAL_LOCATIONS

Applies to: check marked yes Databricks SQL check marked yes 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

> SELECT external_location_owner
    FROM information_schema.external_locations