AWS Cost and Usage Reports API Configuration

For more information about authentication, accessing the Fivetran REST API, and request and response formats, see Getting Started with the Fivetran REST API.

Request

POST https://api.fivetran.com/v1/connections

{
  "group_id": "group_id",
  "service": "aws_cost_report",
  "trust_certificates": true,
  "trust_fingerprints": true,
  "run_setup_tests": true,
  "paused": false,
  "pause_after_trial": false,
  "sync_frequency": 1440,
  "data_delay_sensitivity": "NORMAL",
  "data_delay_threshold": 0,
  "daily_sync_time": "14:00",
  "schedule_type": "auto",
  "connect_card_config": {
    "redirect_uri": "https://your.site/path",
    "hide_setup_guide": true,
    "all_fields": true
  },
  "proxy_agent_id": "proxy_agent_id",
  "private_link_id": "private_link_id",
  "networking_method": "Directly",
  "hybrid_deployment_agent_id": "hybrid_deployment_agent_id",
  "destination_configuration": {
    "virtual_warehouse": "virtual_warehouse"
  },
  "destination_schema_names": "FIVETRAN_NAMING",
  "external_secrets_manager_id": "esm_id",
  "config": {
    "access_key_id": "string",
    "access_key_secret": "string",
    "auth_type": "IAM_ROLE | ACCESS_KEY",
    "bucket": "aws_region_code",
    "prefix": "folder_path",
    "role_arn": "arn::your_role_arn",
    "schema": "schema_name",
    "table": "table_name"
  },
  "external_secrets_keys_config": {
    "access_key_id": "ACCESS_KEY_ID_KEY",
    "access_key_secret": "ACCESS_KEY_SECRET_KEY"
  }
}

Config parameters

Name	Description
`access_key_id`	Access Key ID
`access_key_secret`	Access Key Secret
`auth_type`	Access approach
`bucket`	The S3 bucket name with the AWS Cost and Usage Report
`prefix`	Folder path to the aws_cost_report files within the bucket.
`role_arn`	The Role ARN required for authentication.
`schema` (required)	Destination schema name. Schema name is permanent and cannot be changed after connection creation
`table` (required)	Destination table. Table is permanent and cannot be changed after connection creation

Authorization

There are two ways to authorize this connector type:

By specifying the values for the role_arn and bucket parameters in the request.

POST https://api.fivetran.com/v1/connections

{
  "service": "aws_cost_report",
  "group_id": "group_id",
  "config": {
    "role_arn": "arn::your_role_arn",
    "bucket": "aws_region_code"
  }
}

By using the Connect Card or the Fivetran dashboard.