Skip to main content
Does your Salesforce data already land in your own Snowflake account — through Data Cloud, an ETL tool, or a nightly export? Then you don’t need to connect Salesforce to allGood directly. Inbound Snowflake sharing lets Mary read that data where it already sits. No dedicated allGood user in your Salesforce org. No second copy of your CRM to keep patched.

Why use Snowflake instead of the direct integration

The direct Salesforce integration uses Salesforce’s API. allGood gets its own read/write user in your org. It can act on Leads, Contacts, and Campaigns right away — useful for routing, conversion, and Email Reply Management write-backs. Snowflake sharing works differently. It’s read-only, and one step removed. allGood reads the Salesforce tables your warehouse already holds, on the same schedule your own replication runs. Use it when you’d rather not add a Salesforce API user. It also fits well when the data Mary needs already flows into Snowflake as part of your pipeline.
The two aren’t exclusive. Many customers connect Salesforce directly for real-time actions like lead routing. They also share Salesforce-in-Snowflake tables for the broader account and territory context those actions depend on.

How it works

You publish a Snowflake share containing the Salesforce tables allGood needs. allGood mounts it read-only. Inbound Sharing covers the full setup: the grant script, connecting the share, and binding a table to a record type. This page lists what to include in that share for Salesforce.

Salesforce tables allGood requests

Grant select on these tables, in the schema you share with allGood:
  • Account
  • Campaign
  • Campaign Member
  • Campaign Member Status
  • Contact
  • Dated Conversion Date
  • Group
  • Lead
  • Object Territory 2 Association
  • Opportunity
  • Opportunity Contact Role
  • Task
  • Territory 2
  • User
  • User Role
  • User Territory 2 Association
This is the baseline set Mary uses for account, opportunity, campaign, and territory context. Does your instance have custom objects Mary should also read? Grant those to the same share, then contact allGood support to confirm what to bind into a record type.

Inbound Sharing

The full setup procedure — publish a share, connect it, and bind tables to record types.

Salesforce

The direct API integration, for real-time read/write access instead of a Snowflake share.