AWS Cost Explorer Setup Guide Sunset
Follow our setup guide to connect AWS Cost Explorer to Fivetran.
Prerequisites
To connect AWS Cost Explorer to Fivetran, you need an AWS account with Administrator privileges.
Setup Instructions
Find the External ID
Find the automatically generated External ID in your connector setup form and make a note of it. You will need it to configure AWS to connect with Fivetran.
NOTE: The automatically generated External ID is tied to your account. If you close and re-open the setup form, the ID will remain the same. For convenience, you can keep the browser tab open in the background while you configure your source.
Create IAM policy
Open the Amazon IAM console.
Go to Access management > Policies, then select Create policy.
Go to the JSON tab.
Copy the following policy and paste it to the JSON tab:
{ "Version": "2012-10-17", "Statement": [ { "Sid": "VisualEditor0", "Effect": "Allow", "Action": [ "ce:GetCostAndUsageWithResources", "ce:GetCostCategories", "ce:GetCostAndUsage", "ce:GetSavingsPlansUtilization", "ce:GetReservationCoverage", "ce:GetSavingsPlansCoverage" ], "Resource": "*" } ] }
Click Review policy.
Name the policy (for example, 'fivetran-cost-access').
Click Create policy.
Create IAM role
Go to Access management > Roles, then select Create role.
In the Create role window, select Another AWS account. In the Account ID field, enter Fivetran's account ID,
834469178297
.Select the Require external ID checkbox.
In the External ID field, enter the External ID you got from Step 1.
Click Next: Permissions.
Select the policy that you created in Step 2.
Click Next: Tags.
You do not need to add any tags.
Click Next: Review.
Name your new role 'Fivetran' and click Create role.
Select Fivetran, which is the role you just created.
In the Summary section, make a note of the Role ARN value. You will need it to configure Fivetran.
(Optional) Set Permissions
You can specify permissions for the Role ARN that you designate for Fivetran. Grant selective permissions to this role to allow Fivetran to sync only what it has permissions to see.
Finish Fivetran configuration
In the connector setup form, enter your chosen Destination schema name.
Enter the Role ARN you found in Step 3.
Click Save & Test. Fivetran will take it from here and sync your AWS Cost Explorer data.
Related articles
description Connector Overview
account_tree Schema Information
settings API Connector Configuration