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.windows.net/best_location Nice place
three_tatami abfss://container@storageaccount.dfs.core.windows.net/tatami_xs Quite cozy
Related articles
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for