Chord Data Platform
Overview
Setting up a Snowflake Share with Chord
12 min
https //docs snowflake com/en/user guide/data sharing intro (or secure data sharing) lets you share selected objects in a database in your snowflake account with other snowflake accounts you can allow enable chord to access your data without the data ever leaving your databases you need to have an accountadmin or similar role to create a snowflake share about data providers and consumers providers a data provider is any snowflake account that creates shares and makes them available to other snowflake accounts providers have granular access control over the selected object and can create as many shares as they want consumer a data consumer is any account that chooses to create a database from a share made available by a provider after importing the database the consumer you only access and query objects as defined by the provider also following the grants and blockages defined by the provider options for sharing via snowflake snowflake offers multiple options for sharing we recommend using the free private listing option as the quickest and easiest way more information on direct shares and listings is provided below listing in order to create a listing , you need to have an accountadmin or similar role a listing allows you to share data across regions, and have access to more metadata related to it, like consumer usage metrics chord utilizes free private listings for purposes of the snowflake data share accepting 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 to create a listing, you can follow the steps below create the listing log into your snowflake account go to data sharing > provider studio on the top right corner, select the +create listing button and click on specified consumers edit the listing title with an easy and descriptive name you should now see a listing page click on the add data product button, and select which objects you want to share note you may select one, multiple or all tables, views and other objects from the database you choose to share once you confirm what data you are sharing, select the relevant access type free listing select add consumer accounts and fill the chord's identifier cza77372 rk46674 add a description to your data click publish limitations limitations may apply to hipaa compliant, business critical, or governmental accounts for more information, please contact snowflake's support the following cloud providers and cloud regions are currently supported by snowflake aws aws azure azure gcp gcp ca central 1 canadacentral us central1 sa east 1 centralus us east4 us west 2 eastus2 us east 2 mexicocentral us east 1 southcentralus westus2 for more information please check the https //docs snowflake com/en/user guide/intro regions docs direct share in order to create a direct share , you need to have an accountadmin or similar role direct shares are used when you want to share data with an account in the same cloud provider and cloud region chord's account is hosted on aws us east 2 create the direct share to enable a direct share, you can either use sql statements or using the snowflake ui via the following steps log into your snowflake account go to data sharing > private sharing click on the share button in the top right corner and choose create a direct share select the data you want to share you can select one, few, or all tables in a database you can also select views and a number of different objects you can learn more about the different options https //docs snowflake com/en/user guide/data sharing intro select an easy and clear identifier for your share you can also add a description you will also need to confirm the chord account identifier to create the direct share cza77372 rk46674 click create share ensure that all the necessary grants are given you can select one of the following options to confirm that all of the necessary grants have been given select the get object references table function and check if the grants are given; run the grants on the share itself with show grants to share \<share name> ; or, run the following sql statements grant usage on database \<database name> to share \<share name>; grant usage on schema \<database name> \<schema name> to share \<share name>; reference usage on database \<referenced database name> to share \<share name>; grant select on view \<database name> \<schema name> \<secure view 1> to share \<share name>; grant select on view \<database name> \<schema name> \<secure view 2> to share \<share name>; grant select on view \<database name> \<schema name> \<secure view n> to share \<share name>;