Salesforce logo
→
Snowflake logo

Fix Salesforce → Snowflake Sync Issues (Not Working, Errors, Duplicates)

🔧 1 Common Issues

Diagnose and resolve common sync problems. We've documented the 1 most common issues, their root causes, and exactly how to fix them. See step-by-step fixes for duplicates, missing fields, rate limit errors, and connection issues.

medium High Frequency

Custom fields from Salesforce appear as NULL or missing in Snowflake views.

Also searched as: "Salesforce Snowflake custom fields from salesforce appear as null or missing in snowflake views."

#1 Schema Drift / New Field 95% likely

📋 How to Diagnose

  1. 1. A Salesforce Admin added a new field yesterday.
  2. 2. The ETL pipeline (Fivetran/Stitch) might take 6-12 hours to detect the schema change.
  3. 3. Or the Snowflake View definition wasn't updated to include the new column.

✓ Solution

Force a schema refresh in your ETL tool. Update the SQL view in Snowflake to select the new column.

⏱️ Est. time: 15 min

View Setup Guide

Ready to automate? We have a template for you.

Copy this Salesforce → Snowflake blueprint, open Make.com, paste it into the canvas, and your workflow is ready to configure.

Make.com
salesforce-snowflake-blueprint.json 
{
  "name": "Salesforce → Snowflake Sync",
  "flow": [
    {
      "id": 1,
      "module": "salesforce:WatchRecords",
      "version": 1,
      "parameters": {},
      "mapper": {},
      "metadata": {
        "designer": {
          "x": 0,
          "y": 0
        },
        "restore": {},
        "expect": [
          {
            "name": "body",
            "type": "text",
            "label": "Body"
          }
        ]
      }
    },
    {
      "id": 2,
      "module": "http:ActionSendData",
      "version": 1,
      "parameters": {
        "url": "https://api.snowflake.com/v1/records"
      },
      "mapper": {},
      "metadata": {
        "designer": {
          "x": 300,
          "y": 0
        }
      }
    }
  ],
  "metadata": {
    "instant": false,
    "version": 1,
    "scenario": {
      "roundtrips": 1,
      "maxErrors": 3,
      "autoCommit": true,
      "sequential": false
    }
  }
}
Download .json
Open Make.com ->

Step 1: Try the Official Integration

Direct connection

Start with the native integration if available. It's usually the most reliable, but may have limitations.

View Setup Guide

Free with your subscription

Step 2: Use Make for Custom Flows

No code automation

Create custom integration workflows with Make's visual designer. It works with almost any API.

Try Make Free ->

1000 ops/mo free. No credit card.

Step 3: Self-Hosted with n8n

Full data control

Need complete data privacy? n8n is open-source and self-hostable. Build custom integrations with full control over your data.

Try n8n Free ->

Open source. Self-host or cloud. Unlimited ops.

Step 4: Add Human Review

Approval automation

Relay adds human-in-the-loop approvals, Slack/Teams alerts, and conditional logic to your automation.

Try Relay Free ->

1000 actions/mo free. No credit card.