Snowflake share

To set up a data share with us in Snowflake, follow these steps. You’ll be sharing with our Snowflake account SUMBLE.AWS_US_EAST_1.

Prepare your data

Identify or create the Snowflake table/view with the data you’d like to share with us. Sumble uses the follow fields for matching

Field	Required	Description
Account ID		unique identifier for your account
Account Name		account's organization name
Account URL		primary URL or domain associated with the account
Account Linkedin URL		URL of linkedin page associated with the account
Country		account's organization headquarter country
Parent Account ID		unique identifier of account's parent organization
Ultimate Parent Account ID		unique identifier of account's most parent organization
Alternate Names		other names the account's organization is known by
Alternate URLs		other URLs associated with the account's organization

Use whatever column names are natural for your system — we’ll handle the column matching from there.

Identify your Snowflake region

Which region you’re in determines how you share data with us on Snowflake. If you’re in AWS_US_EAST_1 , we use a data share directly. Otherwise, you'll create a private listing. An in-depth overview of Snowflake's data sharing capabilities can be found at Snowflake's Data Sharing Documentation.

Region: AWS_US_EAST_1

1. Use the CREATE SHARE command to create a new share.
2. Grant access to the specific database objects (schemas, tables, or views) that need to be shared.

CREATE SHARE my_share;
GRANT USAGE ON DATABASE my_database TO SHARE my_share;
GRANT SELECT ON SCHEMA my_database.my_schema TO SHARE my_share;
GRANT SELECT ON TABLE my_database.my_schema.my_table TO SHARE my_share;

1. Use ALTER SHARE to add the Sumble's account.

ALTER SHARE my_share ADD ACCOUNT = SUMBLE.AWS_US_EAST_1;

1. We'll accept the share and create a database from it.

Region: Not AWS_US_EAST_1

1. Create a private data listing.
2. Navigate to the Data Products > Private Sharing in Snowflake and click Share > Publish to Specified Consumers to configure a private listing.

   1. Select the data you’re sharing in this view

   2. Share with SUMBLE.AWS_US_EAST_1

3. Ensure data remains up-to-date: configure the frequency of data replication through the auto-fulfillment settings.

Book a time to chat with us