Adjust Setup Guide

The way Fivetran connects Adjust to your destination depends on whether Adjust’s CSV uploads export raw data to your Amazon S3 or Google Cloud Storage (GCS) bucket. Follow the setup instructions for your cloud storage bucket type.

Prerequisites

To connect Adjust to Fivetran, you need:

• An Adjust account
• A CSV export created in the Adjust portal that exports data to a GCS or S3 bucket.

S3 setup instructions

Find CSV definition

Find the exact CSV definition for the CSV export that you want Fivetan to pull data from.

Find External ID

1. In the connector setup form, go the Cloud Storage field and select Amazon S3.

2. Find the automatically-generated External ID and make a note of it. You will need it to configure your IAM role.

Create IAM policy

1. Open the Amazon IAM console.

2. In the left menu, go to Policies, then click Create Policy.

   

3. Go to the JSON tab.

   

4. Copy the following policy and paste it in the JSON tab. Replace {your-bucket-name} with the name of your S3 bucket.

            {
             "Version": "2012-10-17",
             "Statement": [
               {
                "Effect": "Allow",
                "Action": [
                   "s3:Get*",
                   "s3:List*"
                ],
                "Resource": "arn:aws:s3:::{your-bucket-name}/*"
               },
               {
                "Effect": "Allow",
                "Action": [
                    "s3:Get*",
                    "s3:List*"
                ],
                "Resource": "arn:aws:s3:::{your-bucket-name}"
               }
             ]
            }
   

5. Click Review Policy.

6. Name the policy something memorable (for example, Fivetran-Adjust-Access).

7. Click Create Policy.

Create IAM role

1. In the left menu, go to Roles, then click Create Role.

   

2. Select Another AWS Account. In the Account ID field, enter Fivetran's account ID, 834469178297.

   

3. Select the Require external ID checkbox.

4. Enter the External ID you found in Step 2.

   

5. Click Next: Permissions.

6. Select the IAM policy that you created in Step 3.

7. Click Next: Tags. Entering tags is optional, but you must click through the step.

8. Click Next: Review.

9. Name your new role something memorable (for example, Fivetran).

10. Click Create Role.

11. Select the Fivetran role you just created.

    

12. Find the Role ARN and make a note of it. You will need it to configure Fivetran.

    

Finish Fivetran configuration

1. Enter your chosen destination schema name in the connector setup form.
2. Enter the CSV definition.
3. Enter the name of your S3 bucket.
4. Enter the Role ARN you found in Step 4.
5. Click Save & Test. Fivetran will take it from here and sync your Adjust data.

GCS setup instructions

Find CSV definition

Find the exact CSV definition for the CSV export that you want Fivetan to pull data from.

Find Fivetran email

1. In the connector setup form, go the Cloud Storage field and select Google Cloud Storage.

2. Find the automatically-generated email address and make a note of it. You will need it to edit your GCS bucket permissions.

Authorize Fivetran in GCS

1. Go to your Google Cloud Storage console.

2. Find the bucket that you have configured Adjust exports for and make a note of the bucket name. You will need it to configure Fivetran.

3. Click Edit bucket permissions.

   

4. Grant Storage Object Viewer access to the email you found in Step 2.

   

Finish Fivetran configuration

1. Enter your chosen destination schema name in the connector setup form.
2. Enter the CSV definition.
3. Enter the name of your GCS bucket that you found in Step 3.
4. Click Save & Test. Fivetran will take it from here and sync your Adjust data.

Related articles

description Connector Overview

account_tree Schema Information

assignment Release Notes

settings API Connector Configuration

home Documentation Home