Skip to main content

🔗 Fivetran File Connector Setup Guide

This guide walks through the steps required to set up a file-based data connector in Fivetran and load data into Snowflake.


📋 Prerequisites​

Before you begin, make sure you have:

  • ✅ Access to the Fivetran dashboard
  • ✅ A cloud file storage system (e.g., S3, Azure Blob, SFTP)
  • ✅ A working Snowflake destination set up in Fivetran

📂 Step-by-Step Setup​

📂 Step 1: Prepare Your File Source​

Choose a supported file source:

  • ✅ Amazon S3
  • ✅ Azure Blob Storage
  • ✅ Google Cloud Storage (GCS)
  • ✅ SFTP, FTPS
  • ✅ Dropbox, Box

Steps to set S3 as source:

  • Create a folder: s3://your-bucket/my_data/
  • Upload test files like: sales.csv, employees.json, etc.

S3 Bucket Setup Screenshot

🔗 Step 2: Set Up File Connector in Fivetran​

  1. From the Fivetran dashboard, click ➕ Add Connector
  2. Search for "Files" and select your storage type (e.g., S3)
Add Connector
Connect Target DB

🔐 Step 3: Provide Authentication to Your Cloud Storage​

To allow Fivetran to access your files stored in a cloud service (like S3), you must set up authentication.

✅ Options:​

  • IAM Role ARN (Recommended)
  • Access Key ID + Secret Access Key (for simpler setups or testing)

🛠️ Create an IAM Policy​

This policy gives Fivetran read-only access to your S3 bucket.

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

🛡️ Step 1: Create IAM Policy for S3 Access​

This policy grants Fivetran the required read-only permissions to access your S3 bucket.

IAM Policy Permissions

📝 Step 2: Edit Policy to Define Specific Permissions​

Customize the policy by specifying the correct bucket and permission actions.

Edit Permissions in Policy

✅ Step 3: Verify IAM Policy Configuration​

Ensure your IAM policy is saved correctly and reflects your intended permissions.

Verify Permissions

🔐 Step 4: Create IAM Role and Attach Policy​

Now create an IAM role and attach the policy you just created. This role will be assumed by Fivetran.

🔄 Trust Relationship Configuration​

Configure the trust relationship to allow Fivetran to assume the role.

Trust Relationship Configuration

📌 Step 5: Retrieve IAM Role ARN​

Copy the Role ARN for use when configuring the Fivetran connector.

Copy Role ARN

🔄 Step 4: Connect to S3 in Fivetran​

  1. Enter the IAM Role ARN in Fivetran
  2. Click Test Connection
Enter Role ARN and Test
  1. Set folder path and optional wildcards
    e.g., my_data/*.csv
Folder Path Pattern
  1. Choose your destination schema and destination table name

Happy syncing! 🚀