Snowflake and Amazon Web Services S3
If you want to use Snowflake and Amazon Web Services S3 (AWS S3) for your data warehouse, you need the following prerequisites:
- Access to Snowflake
- An Amazon Web Services S3 account
In Snowflake, create a new SQL worksheet and paste in the query shown below. The query will create a Snowflake database, a warehouse, and a user with the required permissions.
After changing the
MY_PASSWORD variables, run the entire query.
The example query will generate the following credentials:
 Region-specific account locator (opens in a new tab). You can retrieve this by hovering over your account in the account list and clicking on the
🔗 link icon that pops up.
Store these credentials in a secure location.
You'll need to create a new user in AWS with programmatic access enabled. From the search bar, navigate to
IAM and then select
Users in the left pane. Click
Add users and provide a user name (e.g.,
y42_demo_user). Now leave the other settings on their default values and create the new user.
Next, click on the newly created user and under
Permission policies find the
Add permissions button. Select
Create inline policy and navigate to the
JSON tab. Copy the JSON permissions below and paste it into the editor.
Next, provide a policy name (e.g.,
y42_demo_access) and then click
On the user page, select the
Security Credentials tab and click
Create access key. Under
Use case, select
Command Line Interface (CLI), and confirm this choice when prompted.
Store the access key and secret access keys in a secure location.
Back on Y42, select
Snowflake as the provider. Add all the Snowflake credentials generated by the query above:
Amazon S3 Storage. Enter the
Access Key ID and
Secret Access Key credentials from the previous step.
Choose a location or region where Y42 will create the AWS S3 bucket.
You can now continue with configuring the Git repository for your Y42 space.