Target database: Databricks SQL
STORAGE.EXTERNAL_TABLE_CREDENTIALS option specifies the predefined credentials to gain access to the external location.
This parameter is required unless EXTERNAL LOCATION is defined in Databricks.
See also:
Usage
STORAGE.EXTERNAL_TABLE_CREDENTIALS: String
Default: Empty.
Notes
Supports only Databricks External table, requires STORAGE.EXTERNAL_TABLE_LOCATION to be defined.
Examples
Snowflake: Set the STORAGE.EXTERNAL_TABLE_CREDENTIALS
Setting STORAGE.EXTERNAL_TABLE_CREDENTIALS for an External table (e.g. publish.F_TRIP):
STORAGE.EXTERNAL_TABLE_CREDENTIALS: ade-data-connection
STORAGE.EXTERNAL_TABLE_LOCATION: s3:/data/location
DDL generated by Agile Data Engine:
SQL
CREATE TABLE publish.F_TRIP (
...
)
..
LOCATION 's3:/data/location' WITH (CREDENTIAL `ade-data-connection`)
...;