The major components of a modern Snowflake copy into command – best practice

copy into <table-name>
from <stage-name>
storage_integration = <integration-name>

Here is a step by step on how to setup the storage integration object for the copy example above. Setting up the storage integration object is a pre-requisite to using the copy command above.

https://docs.snowflake.com/en/user-guide/data-load-s3-config-storage-integration.html

Another method not shown, (not as secure but works) is to use an external s3 location rather than an internal stage and add AWS keys to the copy command instead of using a predefined Snowflake storage integration object.

Leave a Comment

Scroll to Top