Sharing Data with Chord via Snowflake

introduction this guide provides step by step instructions for sharing data with chord via snowflake snowflake's secure data sharing capabilities lets you share specific database objects in your snowflake account with other snowflake accounts there are two primary mechanisms by which snowflake enables sharing data across accounts a direct share use a direct share to share data with one or more accounts in the same snowflake region you do not need to copy or move data shared with a direct share a private listing use a private listing to share data directly with other snowflake accounts in any snowflake region a private listing is a managed service that will automatically handle cross region and cross cloud replication see https //docs snowflake com/en/collaboration/provider understand cost auto fulfillment for pricing details creating a direct share a direct share is appropriate when your snowflake account resides in the same cloud / region as chord's snowflake account (aws us east ohio) if your snowflake account resides in a different cloud / region, please refer to "creating a private listing" below you must use the accountadmin role or a role that has been granted the create share global privilege to create shares to create a direct share in the snowflake ui sign in to snowsight in the navigation menu, select data sharing » external sharing select the shared by your account tab select share » create a direct share in the share data dialog, select + select data and then select a source database select a target object or objects from the source database optionally, update the secure share identifier created for your share optionally, enter a description in the remaining text box, enter an account locator chord's account locator is cza77372 rk46674 entering a partial account locator lists all accounts that match the entered text repeat as required to add additional accounts you can only add accounts within the same region to the share select create share creating a private listing a private listing is used to share data directly with other snowflake accounts in any snowflake region a private listing is a managed service that will automatically handle cross region and cross cloud replication see https //docs snowflake com/en/collaboration/provider understand cost auto fulfillment for pricing details accept the terms and conditions in order to create a listing, you first need to accept the terms and conditions via https //docs snowflake com/collaboration/provider becoming#review and accept the snowflake provider and consumer terms we also recommend that you review the https //www snowflake com/provider policies/ in order to provide a free private listing, you do not need to set up a provider profile enable auto fulfillment when you share a private listing with snowflake accounts in another region, you must enable auto fulfillment auto fulfillment is a snowflake managed service that handles the automatic replication of data across clouds / regions in order to enable auto fulfillment, you need to assume the orgadmin and accountadmin roles to enable auto fulfillment open a snowflake worksheet and run the following use role orgadmin; select system$enable global data sharing for account('\<account name>'); use role accountadmin; grant manage listing auto fulfillment on account to role accoutadmin; select system$is global data sharing enabled for account('\<account name>'); if you do not know your account name, you can use the following sql select current organization name() || ' ' || current account name(); create a private listing sign in to snowsight in the navigation menu, select marketplace » provider studio select create listing » specified consumers in the edit listing title dialog, enter a name for your listing select the add data product button, then click + select to select the objects to attach to the listing if you select one or more database objects, snowflake creates a secure share with those objects you can change the name of the secure share if you select an existing secure share, the name of that share appears in the access type dropdown, select free in the who can access section, add the organization and account names for the consumers that you want to share the listing with chord's account locator is cza77372 rk46674 if you add a consumer account in a region that isn’t your local region, snowflake enables auto fulfillment to replicate data to the remote region after a consumer gets your listing complete the following additional steps in the auto fulfillment section, enter a value and select an interval to specify how often to replicate your data product from your region to the remote region if you don’t have a default warehouse set, select a warehouse to use for auto fulfillment enter a description for your listing in the legal terms section, select "terms of service will be provided offline" if you don’t see any legal terms, you must first accept the snowflake provider and consumer terms (optional) in the attributes section, add custom attributes to your listing (optional) click in the data dictionary section to add featured objects from the listing’s data dictionary (optional) click in the business needs section to add tags that describe the business needs that your data product addresses (optional) click in the quick start examples section to add sample sql queries or a notebook that demonstrate how to use the data product select publish to publish the listing to the selected consumers snowflake saves your listing if you don’t publish it immediately