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.