storage_integration
Target database: Snowflake, Azure SQL Database
Resolved as the storage integration (Snowflake) or as the external data source (Azure SQL Database) in file load execution.
See also:
Usage
<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:
COPY INTO ...
FROM ...
STORAGE_INTEGRATION = <storage_integration>
...
;
File load executed in Snowflake:
COPY INTO ...
FROM ...
STORAGE_INTEGRATION = example_storage_integration
...
;
Azure SQL Database: Variable used in OVERRIDE_FILE_LOAD
File load customized with OVERRIDE_FILE_LOAD:
BULK INSERT ...
FROM ...
WITH (..., DATA_SOURCE = '<storage_integration>');
File load executed in Azure SQL Database:
BULK INSERT ...
FROM ...
WITH (..., DATA_SOURCE = 'example_external_data_source');