storage_integration
Target database: Snowflake, Azure SQL Database, Azure Synapse SQL, Databricks SQL
Resolved as the storage integration (Snowflake) or as the external data source (Azure SQL Database) in file load execution.
See also:
Usage
VARIABLE
<storage_integration>Notes
Supported in file loads.
Define storage integration/external data source with OPT_STORAGE_INTEGRATION.
Examples
Snowflake: Variable used in OVERRIDE_FILE_LOAD
File load customized with OVERRIDE_FILE_LOAD:
SQL
COPY INTO ...
FROM ...
STORAGE_INTEGRATION = <storage_integration>
...
;File load executed in Snowflake:
SQL
COPY INTO ...
FROM ...
STORAGE_INTEGRATION = example_storage_integration
...
;Azure SQL Database: Variable used in OVERRIDE_FILE_LOAD
File load customized with OVERRIDE_FILE_LOAD:
SQL
BULK INSERT ...
FROM ...
WITH (..., DATA_SOURCE = '<storage_integration>');File load executed in Azure SQL Database:
SQL
BULK INSERT ...
FROM ...
WITH (..., DATA_SOURCE = 'example_external_data_source');Azure Synapse SQL: Variable used in OVERRIDE_FILE_LOAD
File load customized with OVERRIDE_FILE_LOAD:
SQL
COPY INTO ...
FROM ...
WITH (<storage_integration>);File load executed in Azure SQL Database:
SQL
BULK INSERT ...
FROM ...
WITH (CREDENTIAL=(IDENTITY= 'Storage Account Key', SECRET='<Your_Account_Key>'));Databricks SQL: Variable used in OVERRIDE_FILE_LOAD
File load customized with OVERRIDE_FILE_LOAD:
SQL
COPY INTO ...
FROM ...
WITH (<storage_integration>);File load executed in Azure SQL Database:
SQL
COPY INTO ...
FROM ...
WITH (CREDENTIAL source_credential);