# 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

<table><thead><tr><th width="232.203125">Field</th><th width="90.14453125" data-type="checkbox">Required</th><th>Description</th></tr></thead><tbody><tr><td>Account ID</td><td>true</td><td>unique identifier for your account</td></tr><tr><td>Account Name</td><td>true</td><td>account's organization name</td></tr><tr><td>Account URL</td><td>true</td><td>primary URL or domain associated with the account</td></tr><tr><td>Account Linkedin URL</td><td>false</td><td>URL of linkedin page associated with the account</td></tr><tr><td>Country</td><td>false</td><td>account's organization headquarter country</td></tr><tr><td>Parent Account ID</td><td>false</td><td>unique identifier of account's parent organization</td></tr><tr><td>Ultimate Parent Account ID</td><td>false</td><td>unique identifier of account's most parent organization</td></tr><tr><td>Alternate Names</td><td>false</td><td>other names the account's organization is known by</td></tr><tr><td>Alternate URLs</td><td>false</td><td>other URLs associated with the account's organization</td></tr></tbody></table>

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](https://docs.snowflake.com/en/user-guide/data-sharing-intro.html).

### Region: AWS\_US\_EAST\_1

1. Use the [`CREATE SHARE`](https://docs.snowflake.com/en/sql-reference/sql/create-share.html) command to create a new share.
2. Grant access to the specific database objects (schemas, tables, or views) that need to be shared.

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

3. Use [`ALTER SHARE`](https://docs.snowflake.com/en/sql-reference/sql/alter-share.html) to add the Sumble's account.

```sql
ALTER SHARE my_share ADD ACCOUNT = SUMBLE.AWS_US_EAST_1;
```

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

### Region: Not AWS\_US\_EAST\_1

1. Create a [private data listing](https://docs.snowflake.com/en/user-guide/data-exchange-managing-data-listings#create-and-publish-a-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](https://other-docs.snowflake.com/en/collaboration/provider-listings-auto-fulfillment#manage-other-auto-fulfillment-settings).

<a href="https://calendly.com/d/cnzk-sjk-q38/sumble" class="button primary">Book a time to chat with us</a>