View Categories

Getting Started with Cypher

Table of Contents

Cypher identifies and masks sensitive data (such as PII, PCI, or custom keywords) from unstructured documents like PDFs, Word files, text files, and images. It ensures organizations comply with privacy regulations by safeguarding sensitive information when reusing historical data stored in unstructured formats. 

Create a New Warehouse #

Before starting, ensure that a warehouse is available in your current connection. If not, create a new warehouse using the following SQL command:

CREATE WAREHOUSE IF NOT EXISTS edna_consumer_warehouse;

Important pre installation step #

As a best practice the application should be installed with a role. The Snowflake Administrator using the AccountAdmin role should execute the following SQL

Switch to the ACCOUNTADMIN role: #

USE ROLE ACCOUNTADMIN;
CREATE ROLE IF NOT EXISTS EDNA_APPS_CONSUMER_ROLE;
GRANT CREATE DATABASE ON ACCOUNT TO ROLE EDNA_APPS_CONSUMER_ROLE;
GRANT CREATE WAREHOUSE ON ACCOUNT TO ROLE EDNA_APPS_CONSUMER_ROLE;
GRANT CREATE COMPUTE POOL ON ACCOUNT TO ROLE EDNA_APPS_CONSUMER_ROLE;
GRANT CREATE INTEGRATION ON ACCOUNT TO ROLE EDNA_APPS_CONSUMER_ROLE;
GRANT CREATE APPLICATION  ON ACCOUNT TO ROLE EDNA_APPS_CONSUMER_ROLE ;
GRANT IMPORT SHARE ON ACCOUNT TO EDNA_APPS_CONSUMER_ROLE;
GRANT CREATE SHARE ON ACCOUNT TO EDNA_APPS_CONSUMER_ROLE;
GRANT MANAGE EVENT SHARING ON ACCOUNT TO EDNA_APPS_CONSUMER_ROLE;
GRANT BIND SERVICE ENDPOINT ON ACCOUNT TO ROLE EDNA_APPS_CONSUMER_ROLE WITH GRANT OPTION;
 
GRANT ROLE EDNA_APPS_CONSUMER_ROLE to USER <add-usernames>;  -- or add  to existing role

Prepare objects in account #

Execute the following commands with the ACCOUNTADMIN role to set up the necessary database, schema, table, and view that will be used in the application.

Create the database and schema: #

CREATE DATABASE IF NOT EXISTS EDNA_APP_CONSUMER_DB;
CREATE SCHEMA IF NOT EXISTS EDNA_APP_CONSUMER_DB.DATA;

Create the table for EDNA_APP_URL: #

CREATE TABLE IF NOT EXISTS EDNA_APP_CONSUMER_DB.DATA.EDNA_APP_URL(
  APP_URL VARCHAR, 
  APP_NAME VARCHAR
);

Once the pre-installation steps are completed, click on ‘Grant’ to grant privileges. Thereafter click on ‘Activate’ to start the configuration process.  

Note: #

Objects with references are created within stored procedures in the setup_script.sql, not inside user-defined functions (UDFs), as UDFs resolve references only at build-time.

What are your Feelings