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

> SELECT external_location_owner
    FROM information_schema.external_locations

Related

• DESCRIBE EXTERNAL LOCATION
• Information schema
• INFORMATION_SCHEMA.EXTERNAL_LOCATION_PRIVILEGES
• SHOW EXTERNAL LOCATIONS