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
> SHOW EXTERNAL LOCATIONS;
name url comment
------------ ------------------------------------------------------------------- ----------
best_loco abfss://container@storageaccount.dfs.core.chinacloudapi.cn/best_location Nice place
three_tatami abfss://container@storageaccount.dfs.core.chinacloudapi.cn/tatami_xs Quite cozy