SHOW EXTERNAL LOCATIONS
Applies to: 
Databricks SQL Databricks Runtime 10.4 LTS and above Unity Catalog only
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
SQL
> SHOW EXTERNAL LOCATIONS;
name url comment
------------ -------------------------------- ----------
best_loco gs://us-east-1-dev/best_location Nice place
three_tatami gs://us-west-1-dev/tatami_xs Quite cozy