Snowflake works just like BigQuery: measure any number in your database, and there's nothing to generate yourself.
What you can measure
Pick any numeric column in the connected database and Jents will count, sum, average, min or max it over a window, or build a ratio of two. Column names drive the dollar math (money / time / percent / count).
Good things to measure: revenue, bookings, usage, fulfilment time, quality scores.
Connect it
In Jents (step 1), Settings → Integrations → Snowflake → Connect. Enter your account identifier, warehouse, and database. Jents generates a read-only key pair for you (the private key is created and kept encrypted by Jents, it never touches your browser) and hands you a ready-to-run SQL snippet.
In Snowflake (step 2), open a Snowsight worksheet as an admin, paste the snippet and hit Run All. It creates a read-only user (JENTS_SVC) scoped to that database and registers Jents' public key.
Back in Jents, click I ran it, Verify & connect. Done, no openssl, no terminal, no private-key handling.
What Jents reads
Only scoped aggregate SELECTs, one number per read, from the read-only role, bounded to the database you chose. Never rows or record contents.
Specs
| Spec | Detail |
|---|---|
| Auth | Key-pair (Jents-generated), read-only role |
| API | Snowflake SQL API v2 |
| Access | Read-only, scoped to one database |
| Reads | One server-side aggregate per metric |
| Refresh | Daily, plus on-demand |
Privacy & security
The role is read-only and scoped to a single database; revoke it anytime with DROP USER JENTS_SVC. Numbers only, never rows or content. Every read goes through one audited, aggregate-only path and lands in your audit log. Credentials are encrypted at rest, we never train on or share your data, and you can disconnect anytime, see Privacy and Trust.