Snowflake Share Setup

This will set up a Snowflake data share using option 2 in the Snowflake docs. These instructions are for Snowflake accounts in AWS US-East-1.

For AWS US-West-2, please see this page.
Please contact us if your account is in a different region.

Instructions

First, set up a database with the data you want to share. In this example, we’re sharing TEST_TABLE with the schema TEST in the database DATA_SHARE_TEST:

To share the data with Espresso’s Snowflake account, run the following commands one at a time in a SQL workbook as ACCOUNTADMIN:

CREATE SHARE espresso_share;

-- Espresso AI AWS US-EAST-1 account
ALTER SHARE espresso_share ADD ACCOUNTS = SYVMRPV.YCB46914;  

-- Run the following commands once for each database to be shared
GRANT USAGE ON DATABASE DATA_SHARE_TEST TO SHARE espresso_share;

CREATE DATABASE ROLE DATA_SHARE_TEST.espresso_role;

GRANT DATABASE ROLE DATA_SHARE_TEST.espresso_role TO SHARE espresso_share;

-- Run the following commands once for each table to be shared
GRANT USAGE ON SCHEMA DATA_SHARE_TEST.TEST 
  TO DATABASE ROLE DATA_SHARE_TEST.espresso_role;

GRANT SELECT ON VIEW DATA_SHARE_TEST.TEST.TEST_TABLE 
  TO DATABASE ROLE DATA_SHARE_TEST.espresso_role;

The org id and account id above are for Snowflake running in AWS US-East-1.
For AWS US-West-2, please see this page.

Please contact us if your data is in a different region.