DESCRIBE EXTERNAL LOCATION (Databricks SQL)

Preview

Unity Catalog is in Public Preview. To participate in the preview, contact your Databricks representative.

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