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.

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

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

SQL
> SELECT external_location_owner
    FROM information_schema.external_locations