Snowflake

​

Prepare Snowflake

1. Create a key pair. Keep the private key (PEM) for Coverbase, and set the public key on the Snowflake user as RSA_PUBLIC_KEY.
2. Give the user a role with:
   • USAGE on the warehouse, the database and the schema;
   • CREATE TABLE and CREATE VIEW on the schema.
3. Use a schema of its own, so Coverbase’s tables and views do not mix with others.

CREATE ROLE coverbase_share;
GRANT USAGE ON WAREHOUSE reporting_wh TO ROLE coverbase_share;
GRANT USAGE ON DATABASE risk TO ROLE coverbase_share;
GRANT USAGE ON SCHEMA risk.coverbase TO ROLE coverbase_share;
GRANT CREATE TABLE, CREATE VIEW ON SCHEMA risk.coverbase TO ROLE coverbase_share;
CREATE USER coverbase_share_user DEFAULT_ROLE = coverbase_share RSA_PUBLIC_KEY = '<public key>';
GRANT ROLE coverbase_share TO USER coverbase_share_user;

​

Add the destination in Coverbase

1. Open Configuration → Data Share and click Add destination.
2. Choose Snowflake, give it a Name, and choose Hourly or Daily.
3. Enter the Account, User, Role, Warehouse, Database and Schema, paste the Private Key (PEM), and add the Key passphrase if the key has one.
4. Click Add destination, then Test connection, then Sync now.

​

What lands in Snowflake

• One table per contract table, created on the first sync. A column the contract adds later is added to the table.
• Each sync appends the rows that changed, stamped with _cb_synced_at.
• A <table>_current view per table keeps the newest version of each row. For the services snapshot table, it keeps only the latest run.

​

Related