For Snowflake
AI analytics for Snowflake
Last updated
Short answer
exelens connects to Snowflake with a read-only service user, ideally on an RSA key pair, reads only the views you import and answers business questions in plain language with an AI model on your own key. Your data stays in Snowflake.
| Detail | exelens on Snowflake |
|---|---|
| Preferred sign-in | RSA key pair on a service user (password only if you cannot use a key) |
| What exelens can read | SELECT on the views you import, through the EXELENS_READER role. Tables are never imported |
| Compute | A small dedicated warehouse with a resource monitor, created by the setup script |
| Network | A Snowflake network policy that allows the exelens egress IPs |
| What you provide | Account identifier, warehouse, database, role, user and private key |
| Where the data lives | In Snowflake. Rows are loaded temporarily only while a question is answered |
How it works on Snowflake
- Run the setup script. In Data → Connect, pick Snowflake and choose Show read-only setup script. An administrator runs it once. It creates
EXELENS_READER, a small warehouse with a resource monitor, and grantsSELECTon views. - Add the key pair. Put the public key on the service user and paste the private key into exelens.
- Allow the network. Add the exelens egress addresses to the network policy.
- Test, then save. exelens runs a test and warns if the role has any write privilege.
- Import views, ask. Choose the views people may ask about, then ask in plain language.
Why views
A view is where your team has already decided what "revenue" or "active customer" means. Pointing the AI at views, not raw tables, keeps answers consistent. Read more in why views beat tables for AI analytics.
Cost
Warehouse compute is billed by Snowflake on the small warehouse you dedicate to exelens, and AI usage is billed by the provider whose key you add. A pinned board refreshed in data-only mode costs nothing in AI. See cost control.
Book a demo and we will connect it with you.
Frequently asked questions
- Does exelens write to Snowflake?
- No. The role only has SELECT on views, and every statement runs read-only.
- Which Snowflake account format do I paste?
- The account identifier, such as xy12345.us-east-1 or myorg-analytics. Do not paste the full snowflakecomputing.com URL.
- Can I use Snowflake Cortex and exelens together?
- Yes. They are independent. exelens uses the AI key you add, not Snowflake's models.
See exelens on your Snowflake
A short walkthrough with the founder: connect read-only, ask a real question, pin the answer.