Snowflake

USE ROLE SECURITYADMIN;
CREATE USER INVIOLET_SVC PASSWORD = '<rotate>' DEFAULT_ROLE = 'INVIOLET_RO';
CREATE ROLE INVIOLET_RO;
GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE INVIOLET_RO;
GRANT USAGE ON DATABASE ANALYTICS TO ROLE INVIOLET_RO;
GRANT USAGE ON SCHEMA ANALYTICS.SALES TO ROLE INVIOLET_RO;
GRANT SELECT ON ALL TABLES IN SCHEMA ANALYTICS.SALES TO ROLE INVIOLET_RO;
GRANT ROLE INVIOLET_RO TO USER INVIOLET_SVC;

import { Inviolet } from "@inviolet/sdk"

const inviolet = new Inviolet({ apiKey: process.env.INVIOLET_API_KEY! })

const decision = await inviolet.intent.evaluate({
  userId: "analyst_42",
  toolCall: {
    name: "run_sql",
    arguments: {
      query: "SELECT region, SUM(amount) FROM ANALYTICS.SALES.OPPORTUNITIES GROUP BY 1",
    },
  },
  dataSourceId: "snowflake_prod",
})