Snowflake

フォーカスモード

Snowflake - Amazon AppFlow

このページはお客様の言語に翻訳されていません。翻訳のリクエスト

The following are the requirements and connection instructions for using Snowflake with Amazon AppFlow.

You can use Snowflake as a destination only.

Requirements

Amazon AppFlow uses the Snowflake COPY command to move data using an S3 bucket. To configure the integration, see Configuring Secure Access to Amazon S3 in the Snowflake documentation.
You must also add access to the kms:Decrypt action so that Snowflake can access the encrypted data that Amazon AppFlow stored in the Amazon S3 bucket.
```
{
    "Effect": "Allow",
    "Action": "kms:Decrypt",
    "Resource": "*"
}
```
You must provide Amazon AppFlow with the following information:
- the name of the stage and the S3 bucket for the stage
- the user name and password for your Snowflake account
- the S3 bucket prefix
- the warehouse that you want to use to move the data

Sign in to the AWS Management Console and open the Amazon AppFlow console at https://console.aws.amazon.com/appflow/.
Choose Create flow.
For Flow details, enter a name and description for the flow.
(Optional) To use a customer managed CMK instead of the default AWS managed CMK, choose Data encryption, Customize encryption settings and then choose an existing CMK or create a new one.
(Optional) To add a tag, choose Tags, Add tag and then enter the key name and value.
Choose Next.
Choose Snowflake from the Destination name dropdown list.
Choose Connect or Connect with PrivateLink to open the Connect to Snowflake dialog box.
1. Under Warehouse, enter the Snowflake warehouse that you want to use to move the data.
2. Under Stage name, enter the Amazon S3 stage name in the following format: <Database> <Schema> <Stage name>
3. Under Bucket details, select the S3 bucket where Amazon AppFlow will write data prior to copying it.
4. Under Account name, enter your Snowflake account name. You can find your account name in the URL of your Snowflake instance. For example, if your Snowflake URL is https://vna33034.snowflakecomputing.com, your account name is vna33034.
5. Under User name, enter the user name you use to log into Snowflake.
6. Under Data encryption, enter your AWS KMS key.
7. Under Connection name, specify a name for your connection.
8. Choose Connect.