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

• ALTER EXTERNAL LOCATION
• CREATE EXTERNAL LOCATION
• DESCRIBE EXTERNAL LOCATIONS
• DROP EXTERNAL LOCATION
• INFORMATION_SCHEMA.EXTERNAL_LOCATIONS