DESCRIBE EXTERNAL LOCATION

Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above Unity Catalog only

Returns the metadata of an existing external location. The metadata information includes location name, URL, associated credential, owner, and timestamps of creation and last modification.

Syntax

DESCRIBE EXTERNAL LOCATION location_name

If location_name includes special characters, such as hyphens (-), it must be surrounded by backticks (` `). See Names.

Parameters

• location_name

  The name of an existing external location in the metastore. If the name does not exist, an exception is thrown.

Examples

> DESCRIBE EXTERNAL LOCATION best_loco;
  name      url                                                                 credential_name owner          created_by     created_at       comment
  --------- ------------------------------------------------------------------- --------------- -------------- -------------- ---------------- ----------
  best_loco abfss://container@storageaccount.dfs.core.windows.net/best_location good_credential scooby@doo.com scooby@doo.com 2021-11-12 13:51 Nice place

Related articles

• ALTER EXTERNAL LOCATION
• CREATE EXTERNAL LOCATION
• DROP EXTERNAL LOCATION
• SHOW EXTERNAL LOCATIONS
• INFORMATION_SCHEMA.EXTERNAL_LOCATIONS