DESCRIBE EXTERNAL LOCATION

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.3 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 s3://us-east-1-dev/best_location good_credential scooby@doo.com scooby@doo.com 2021-11-12 13:51 Nice place