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

VARIABLE

<storage_integration>

Supported in file loads.

Define storage integration/external data source with OPT_STORAGE_INTEGRATION.

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
...
;

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');