Data Ingestion Setup Guide
Configure data ingestion for seamless integration with SyncSage
1. Account Provisioning
1.1 Sign-Up Options: SyncSage-Managed Account
Overview:
SyncSage provisions a pre-configured Fivetran account for users.
Action:
Just Sign In / Sign Up
2. Authentication
2.1 Supported Methods
| Method | Use Case |
|---|---|
| OAuth 2.0 | SaaS applications (e.g., Salesforce, Google Analytics). |
| API Key/Secret | Databases, custom APIs, or legacy systems. |
| SSH Key Pair | Secure access to SFTP/S3 buckets. |
3. Destination Configuration (Snowflake)
3.1 Snowflake Requirements (If You Have One)
Provide the following in our Data Ingestion -> Destinations tab:
| Parameter | Example Value |
|---|---|
| Host | xy12345.snowflakecomputing.com |
| Port | 443 |
| User | FIVETRAN_USER |
| Password | ************ |
| Database | RAW_DATA |
| Warehouse | FIVETRAN_WH |
| Role | FIVETRAN_ROLE |
Note: If you don't have one, we will help you provide/create one.
4. Testing & Activation
4.1 Steps to Validate and Finalize
1. Test Connection
Click Test Connection to validate Snowflake access.
2. Save & Finalize
On success, click Save & Finalize.
3. Snowflake Setup
Fivetran creates the following in Snowflake:
- Database Name: _____________
- Tables: Mirrored from the source