Have your CRM data in Snowflake? Skip integrating your CRM and use Snowflake Data Sharing to share data with Crossbeam's Snowflake account, allowing you to get your CRM data into Crossbeam, all via Snowflake.

Connecting Crossbeam to Snowflake

To connect Snowflake as a data source, go to Data Sources in Crossbeam and click on "Snowflake".

To get started, you'll need three pieces of information:

1. Your Snowflake account region. Currently we only support two regions:

  • US West (Oregon): this region is the only one not included in snowflake URLs
  • US East (Ohio)

Please let us know if your account is in a different region and we can work to add support for you.

2. Your Snowflake account name. Account name can be found in the url of your Snowflake instance: https://<account_name>.<region>.snowflakecomputing.com.

3. Your Snowflake data share name. We'll provide you with a data share name to use in Snowflake. It will be in the format of crossbeam_share_{123} where 123 will be a unique number to your organization. You will enter this in the Shares tab in Snowflake.

Managing your Snowflake Integration in Crossbeam

Once your Snowflake connection is set up, you can manage it by clicking on Settings on the Data Sources page in Crossbeam. Here you can:

1. Pause the sync into Crossbeam

2. Select which fields to sync into Crossbeam from Snowflake

3. Remove the Snowflake connection

Note: update frequency is not configurable for Snowflake. Contact is if you'd like to change the frequency of updates.

Configuring your Snowflake Data Share

In Snowflake, your shared database must contain a set of required tables and fields under a _crossbeam schema. We expect the following tables and fields to be shared with a share called crossbeam_share_{id} (this id is provided in the Crossbeam UI when connecting Snowflake - see above).

Also, make sure to add crossbeam as a Consumer:

Note: you don't need all of the following tables for the integration to work.

The fields marked as required need to exist in order for Crossbeam to properly integrate. The fields not marked as required can be skipped but are recommended. You can also include additional fields if there is any other data that you would like to be able to filter on or share with partners in Crossbeam.

accounts

Field

Type

Notes

Is Required?

id

VARCHAR

Account Id

website

VARCHAR

Account Website

name

VARCHAR

Account Name

type

VARCHAR

Account Type

owner_id

VARCHAR

FK to a User

created_at

TIMESTAMP_TZ

Account Created At

updated_at

TIMESTAMP_TZ

Equivalent of Salesforce's SystemModstamp. Last time record was upserted into snowflake

leads

Field

Type

Notes

Is Required?

id

VARCHAR

Lead Id

email

VARCHAR

Lead Email

name

VARCHAR

Lead Name

phone

VARCHAR

Lead Phone

title

VARCHAR

Lead Title

owner_id

VARCHAR

FK to a User

created_at

TIMESTAMP_TZ

Lead Created At

updated_at

TIMESTAMP_TZ

Equivalent of Salesforce's SystemModstamp. Last time record was upserted into snowflake

contacts

Field

Type

Notes

Is Required?

id

VARCHAR

Contact Id

email

VARCHAR

Contact Email

name

VARCHAR

Contact Name

phone

VARCHAR

Contact Phone

title

VARCHAR

Contact Title

account_id

VARCHAR

FK to an Account

created_at

TIMESTAMP_TZ

Contact Created At

updated_at

TIMESTAMP_TZ

Equivalent of Salesforce's SystemModstamp. Last time record was upserted into snowflake

deals

Field

Type

Notes

Is Required?

id

VARCHAR

Deal Id

amount

DOUBLE

name

VARCHAR

Deal name

stage_name

VARCHAR

Sales Stage

account_id

VARCHAR

FK to an Account

closed_at

VARCHAR

Close Date

created_at

TIMESTAMP_TZ

Open Date

updated_at

TIMESTAMP_TZ

Equivalent of Salesforce's SystemModstamp. Last time record was upserted into snowflake

users

Field

Type

Notes

Is Required?

id

VARCHAR

User Id

name

VARCHAR

User Name

email

VARCHAR

User Email

phone

VARCHAR

User Phone

created_at

TIMESTAMP_TZ

User Created At

updated_at

TIMESTAMP_TZ

Equivalent of Salesforce's SystemModstamp. Last time record was upserted into snowflake

Did this answer your question?