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.

How exelens connects to Snowflake
Detailexelens on Snowflake
Preferred sign-inRSA key pair on a service user (password only if you cannot use a key)
What exelens can readSELECT on the views you import, through the EXELENS_READER role. Tables are never imported
ComputeA small dedicated warehouse with a resource monitor, created by the setup script
NetworkA Snowflake network policy that allows the exelens egress IPs
What you provideAccount identifier, warehouse, database, role, user and private key
Where the data livesIn Snowflake. Rows are loaded temporarily only while a question is answered

How it works on Snowflake

  1. 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 grants SELECT on views.
  2. Add the key pair. Put the public key on the service user and paste the private key into exelens.
  3. Allow the network. Add the exelens egress addresses to the network policy.
  4. Test, then save. exelens runs a test and warns if the role has any write privilege.
  5. 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.