Learn · Snowflake

KrisVen for Snowflake

KrisVen Decision Ledger is a Snowflake Native App. It gives your analysts and their AI assistants your organization's approved knowledge, and keeps a tamper-evident record of the decisions made with it. It runs entirely inside your Snowflake account: your data, the ledger and the signing key never leave it.

The Snowflake Marketplace listing is being prepared. To try it before then, contact contact@krisven.ai.

Before you start

Set up

  1. Install the app

    Get KrisVen Decision Ledger from Snowflake Marketplace. Replace KRISVEN_APP below with the name you choose.

  2. Give it a warehouse

    Bind a warehouse in the app's security settings in Snowsight, or run CALL KRISVEN_APP.CORE.REGISTER_REFERENCE('TOOL_WAREHOUSE', 'ADD', SYSTEM$REFERENCE('WAREHOUSE', 'KRISVEN_WH', 'PERSISTENT', 'USAGE'));

  3. Choose knowledge sources

    Bind the tables or views KrisVen may read, with SELECT only. KrisVen never writes to them.

  4. Give people access

    Grant application roles to your own roles, for example GRANT APPLICATION ROLE KRISVEN_APP.APP_REVIEWER TO ROLE CREDIT_REVIEWER;

Application roleCan
APP_USERRead, save drafts, seal and verify decisions
APP_REVIEWEREverything in APP_USER, plus approve or retire knowledge
APP_AUDITORRead-only views of the ledger, verification and exports
APP_ADMINEverything above, plus settings, knowledge sources and the signing key

KrisVen Studio

Studio does everything without SQL. It opens from the app's page in Snowsight. There are three Studios, and each opens only for people who hold the matching application role.

KrisVen Review

APP_REVIEWER

Approve or retire drafts, read approved knowledge for a case, seal the sample decision and verify it.

KrisVen Audit

APP_AUDITOR

List sealed decisions, verify them, and download exports that can be checked outside Snowflake.

KrisVen Admin

APP_ADMIN

Setup checklist, synthetic sample data, drafts from bound tables and views, tool settings and key rotation.

Studio records the person signed in to Snowsight as the one who acted. Four-eyes approval works the same way in Studio as it does in SQL.

Try it with sample data. In KrisVen Admin, load the synthetic sample drafts. Approve them in KrisVen Review, then seal and verify the sample decision. Sample data has its own purpose and case, so it never mixes with your knowledge.

Tools

Read approved knowledge

read-only

Returns knowledge a reviewer approved, for one case and purpose, with its source. Knowledge tied to another case or purpose is never returned.

Save a draft for review

adds a draft

Saves a new finding as a draft. Nobody can read it until a reviewer approves it. By default, reviewers can't approve their own drafts.

Seal a decision record

adds a record

Records a decision with SHA-256 fingerprints of the documents it relied on, signed with a key that stays inside the app. Repeating a seal with the same idempotency key returns the original.

Verify a sealed decision

read-only

Checks a sealed record and names what changed if anything was altered. It also states what verification does not prove, such as whether the evidence itself is true.

Every tool is also a stored procedure in the app's CORE schema. The app's readme in Snowsight lists them all.

AI assistants

One call creates a Snowflake-managed MCP server and a Cortex Agent inside the app: CALL KRISVEN_APP.CORE.CONFIGURE_AI_ACCESS('KRISVEN_WH'); Claude, Cursor and Cortex Agents can then use the four tools.

Your data

For administrators

Troubleshooting

A Studio doesn't open

Each Studio opens only for people whose role holds its application role. Ask an administrator to grant APP_REVIEWER, APP_AUDITOR or APP_ADMIN to your role.

Approval says FOUR_EYES

You created that draft, so another reviewer has to approve it. Drafts loaded as sample data are created by krisven-sample-data, so you can approve those yourself.

A tool says CONNECTOR_DISABLED or TOOL_DISABLED

An administrator turned the tools off, or turned that one tool off, in KrisVen Admin under Settings.

Read returns nothing

Read returns only approved knowledge for the exact case and purpose you ask about. Check the draft is approved and its purpose matches.

Claude sign-in says role ALL is blocked

Set the person's default role to a non-admin role that holds APP_USER, and their default secondary roles to none.

AI tool calls fail on a trial account

Snowflake refuses MCP and Cortex Agent tool calls on trial accounts. The same procedures work directly in SQL and in Studio.

Questions about KrisVen for Snowflake?

Contact KrisVen support at contact@krisven.ai.