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
-
In the connector setup form, enter the Destination schema name of your choice.
-
Enter the Destination table name.
-
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.
-
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. -
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.
-
Open the Amazon IAM console.
-
Go to Policies, then select Create Policy.
-
Go to the JSON tab.
-
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}*" } ] }
-
Click Review Policy.
-
Name the policy “Fivetran-S3-Access”.
-
Click Create Policy.
Create an IAM rolelink
-
Go to Roles, then select Create New Role.
-
Select Another AWS Account, then enter Fivetran’s account ID,
834469178297
, in the Account ID field. -
Select the Require external ID checkbox.
-
Enter the External ID you found in Step 1.
-
Click Next: Permissions.
-
Select the ‘Fivetran-S3-Access’ policy that you created in Step 2.
-
Click Next: Tags, which is optional.
-
Click Next: Review.
-
Name your new role ‘Fivetran’, then click Create Role.
-
Select the Fivetran role you just created.
-
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
-
(If you selected AWS S3) Enter the S3 bucket name and the Role ARN that you created in AWS.
-
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
settings API Connector Configuration