Webhooks Setup Guide

Follow our setup guide to connect Webhooks to Fivetran.

Prerequisiteslink

To connect Webhooks to Fivetran, you need an HTTP client setup on your website, application, or any other place.

IMPORTANT: Only use an HTTPS URL with TLS version 1.2 or above.

Setup instructionslink

Begin Fivetran configurationlink

1. In the connector setup form, enter the Destination schema name of your choice.

2. Enter the Destination table name.

3. Select the Sync format in which form you’d like your data to be loaded, Packed or Unpacked. For more information, see the Sync Overview section.

4. Find the Webhook URL and make a note of it. The URL is in the format https://webhooks.fivetran.com/webhooks/<endpoint_ID>. You will need it to configure Webhooks to connect with Fivetran.

5. Select the container service you want to use:

   • Fivetran: We will store the events in our own container service.

   • AWS S3: We will store the events in your S3 bucket.

   Note: If you choose AWS S3, find the automatically-generated External ID and make a note of it. You will need it to configure AWS to connect with Fivetran.

Create an IAM Policylink

To allow Fivetran access to your S3 bucket, follow the instructions below.

1. Open the Amazon IAM console.

2. Go to Policies, then select Create Policy.

   

3. Go to the JSON tab.

   

4. Copy the following policy, replacing {your-bucket-name} with the name of your S3 bucket.

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

5. Click Review Policy.

   

6. Name the policy “Fivetran-S3-Access”.

   

7. Click Create Policy.

Create an IAM rolelink

1. Go to Roles, then select Create New Role.

   

2. Select Another AWS Account, then enter Fivetran’s account ID, 834469178297, in the Account ID field.

   

3. Select the Require external ID checkbox.

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

   

5. Click Next: Permissions.

6. Select the ‘Fivetran-S3-Access’ policy that you created in Step 2.

   

7. Click Next: Tags, which is optional.

8. Click Next: Review.

9. Name your new role ‘Fivetran’, then click Create Role.

   

10. Select the Fivetran role you just created.

    

11. Find the Role ARN and make a note of it. You will need to enter this value in the connector setup form.

    

Finish Fivetran configurationlink

1. (If you selected AWS S3) Enter the S3 bucket name and the Role ARN that you created in AWS.

2. Click Save & Test. Fivetran will load events into your destination.

IMPORTANT: It takes us around 10 to 15 minutes to load the first event into your destination.

Related Contentlink

description Connector Overview

account_tree Schema Information

assignment Release Notes

settings API Connector Configuration

home Documentation Home