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.

Preparing your data for share

Identify or create the Snowflake table/view with the data you’d like to share with us.

Sumble needs the following fields for matching:

Account Id - a unique identifier for your account

• Account Name - name for the organization

• Account URL - primary URL or domain associated with the account

Additional information that’s helpful to include if available:

• Linkedin URL

• Country

• Headquarters Location

• Parent Account Id

• Ultimate Parent Account Id

• Alternate Names

• Alternate URLs

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, we create a private listing

If in AWS_US_EAST_1: Create a Data Share

• Use the CREATE SHARE command to create a new share.
• 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;

Give Sumble’s account access to the data share.

• Use ALTER SHARE to add the recipient’s account.
• The recipient must accept the share or listing and create a database from it.

ALTER SHARE my_share ADD ACCOUNT = 'SUMBLE.AWS_US_EAST_1';

If in another region: Create a Private Listing

If the data to be shared are not in AWS us-east-1, create a private data listing:

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

  • You will select the data you’re sharing in this view

  • You will share with SUMBLE.AWS_US_EAST_1

• To ensure data remains up-to-date, configure the frequency of data replication through the auto-fulfillment settings.

For further guidance, refer to Snowflake’s Data Sharing Documentation for an in-depth overview of data sharing capabilities.