Snowflake Prerequisites

Integrating PrivaceraCloud with Snowflake requires establishing a PrivaceraCloud Warehouse and Database for use with PrivaceraCloud PolicySync.

  1. Create a Warehouse to be used by Privacera Policy Sync.

    CREATE WAREHOUSE PRIVACERA_POLICYSYNC_WH WITH 
    WAREHOUSE_SIZE = XSMALL 
    WAREHOUSE_TYPE = STANDARD 
    AUTO_SUSPEND = 600 
    AUTO_RESUME = TRUE 
    MIN_CLUSTER_COUNT = 1 
    MAX_CLUSTER_COUNT = 1 
    SCALING_POLICY = ECONOMY';
    
  2. Create a Privacera Sync Role, and grant it SECURITYADMIN and ACCOUNTADMIN rights so it can create users and additional roles.

    CREATE ROLE PRIVACERA_SYNC_ROLE;
    GRANT ROLE SECURITYADMIN TO ROLE PRIVACERA_SYNC_ROLE;
    GRANT ROLE ACCOUNTADMIN TO ROLE PRIVACERA_SYNC_ROLE;
    
  3. Create a Role for the default owner for user-created resources.

    CREATE ROLE PRIVACERA_DEFAULT_OWNER;
    
  4. Create a Privacera Sync User and assign it a password.  Set the default Warehouse and default roles. Assign it the Privacera Sync Role

    CREATE USER PRIVACERA_SYNC  PASSWORD='<CHANGE_ME-PRIVACERA_SYNC_PASSWORD> 
    MUST_CHANGE_PASSWORD=FALSE 
    DEFAULT_WAREHOUSE='PRIVACERA_SYNC_WH 
    DEFAULT_ROLE='PRIVACERA_SYNC_ROLE';
    
    GRANT ROLE PRIVACERA_SYNC_ROLE TO USER PRIVACERA_SYNC
    
  5. Create the database to store policies.

    create database privacera_db;
    

Last update: August 19, 2021