DESCRIBE EXTERNAL LOCATION

  • Article

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.4 LTS and above check marked yes 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.chinacloudapi.cn/best_location good_credential scooby@doo.com scooby@doo.com 2021-11-12 13:51 Nice place