Step 4: Link the API Integration for AWS to the Proxy Service in the Management Console¶

Previous Step¶

Step 3: Create the API Integration for AWS in Snowflake

Set Up the Trust Relationship(s) between Snowflake and the New IAM Role¶

In the AWS Management Console:

1. Select IAM.

2. Select Roles.

3. In the worksheet, look up the value in the New IAM Role Name field, then look for the same value (role name) in the AWS Management Console.

4. Click on the Trust relationships tab, then click on the button Edit trust relationship.

   This should open the Policy Document into which you can add authentication information.

5. In the Policy Document, find the Statement.Principal.AWS field and replace the value (not the key) with the value in the API_AWS_IAM_USER_ARN field of the worksheet.

6. Find the Statement.Condition field. Initially, this should contain only curly braces (“{}”).

7. Paste the following between the curly braces:

   "StringEquals": { "sts:ExternalId": "xxx" }

8. Replace the xxx with the value for the API_AWS_EXTERNAL_ID field in the worksheet.

9. After you are done editing the Policy Document for the trust relationship, it should look similar to the following:

   {
     "Version": "2012-10-17",
     "Statement": [
       {
         "Effect": "Allow",
         "Principal": {
           "AWS": "arn:aws:iam::1234567898012:user/development/development_user"
         },
         "Action": "sts:AssumeRole",
         "Condition": {"StringEquals": { "sts:ExternalId": "EXTERNAL_FUNCTIONS_SFCRole=3_8Hcmbi9halFOkt+MdilPi7rdgOv=" }}
       }
     ]
   }
   

   Copy

10. Click on Update Trust Policy.

Next Step¶

Step 5: Create the External Function for AWS in Snowflake