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