CREATE EXTERNAL LOCATION
Applies to: Databricks SQL
Databricks Runtime 10.3 and above
Unity Catalog only
Creates an external location with the specified name. If a location with the same name already exists, an exception is thrown.
Syntax
CREATE EXTERNAL LOCATION [IF NOT EXISTS] location_name
URL url
WITH (STORAGE CREDENTIAL credential_name)
[COMMENT comment]
Parameters
-
The name of the location to be created.
IF NOT EXISTS
Creates a location with the given name if it does not exist. If a location with the same name already exists, nothing will happen.
url
A
STRING
literal with the location of the cloud storage described as an absolute URL.-
The named credential used to connect to this location.
comment
An optional description for the location, or
NULL
. The default isNULL
.