Integrate the Snowflake account with the AWS S3 bucket
Learn how to create the Snowflake integration in your Snowflake environment.
To create an integration between Snowflake and AWS:
- Log in to your Snowflake environment.
- In the worksheet area, enter the integration name. For example: create storage integration s3_integration.
- Enter the following values:
- type: Enter 'external_stage' as the integration name. For example: type = external_stage.
- storage_provider: Enter 's3' as the storage provider name. For example: storage_provider = s3.
- enabled: Enter 'true' to enable the stage. For example: enabled = true.
- storage_aws_role_arn: Enter the value in the Role ARN field. For example: storage_aws_role_arn = arn:aws:iam::001234567890:role/myrole.
- storage_allowed_locations: Enter the complete path of the S3 bucket. For example: example: storage_allowed_locations = (‘s3://mybucket1/mypath1/').