📊 CRM to Snowflake Using Fivetran
🔗 Overview
Fivetran provides a fully managed connector to sync data from various CRM systems to Snowflake. It automates schema creation, incremental updates, and handles changes without manual intervention.
💡 Supported CRM Sources
- Salesforce
- HubSpot
- Zoho CRM
- Microsoft Dynamics 365
- Pipedrive
- Freshsales
🔄 Data Flow: CRM → Fivetran → Snowflake
- Fivetran Connector Setup for your CRM system
- Fivetran pulls data using CRM's APIs
- Fivetran syncs data into Snowflake
- Tables auto-created based on selected CRM objects
- Optionally transform data using dbt in Snowflake
🛠️ Steps to Configure
✅ Step 1: Set Up Source (CRM)
- Go to Fivetran dashboard → Add Connector
- Choose your CRM (e.g., Salesforce)
- Authenticate via OAuth or API token
- Select CRM objects (e.g., Leads, Contacts, Opportunities)
✅ Step 2: Configure Destination (Snowflake)
- Provide:
- Account Name (e.g.,
xy12345.ap-south-1) - Warehouse
- Database
- Schema
- Username/Password or use Key-Pair Auth
- Account Name (e.g.,
✅ Step 3: Sync Settings
- Choose sync frequency (e.g., every 15 minutes)
- Enable history mode (optional)
- Enable or disable transformations (dbt)
🗂️ Snowflake Table Layout Example
<schema_name>
├── salesforce__contact
├── salesforce__lead
├── salesforce__opportunity
└── ...