SHOW EXTERNAL LOCATIONS (Databricks SQL)

Preview

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

Lists the external locations that match an optionally supplied regular expression pattern. If no pattern is supplied then the command lists all the external locations in the metastore.

Syntax 

SHOW EXTERNAL LOCATIONS

Parameters

This statement does not take parameters.

Examples 

> SHOW EXTERNAL LOCATIONS;
  name         url                              comment
  ------------ -------------------------------- ----------
  best_loco    s3://us-east-1-dev/best_location Nice place
  three_tatami s3://us-west-1-dev/tatami_xs     Quite cozy