DESCRIBE EXTERNAL LOCATION

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.3 and above

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

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