Use Snowflake in your Crisp app.
Run SQL on your Snowflake data.
Run queries and statements in your Snowflake account, list tables and show the results in tables and charts. The app signs in with a user you create for it.
What you need.
Create the keys in your Snowflake account and paste them in. Each one is saved under the name shown, and your app reads it by that name.
- Account identifier
SNOWFLAKE_ACCOUNT- app.snowflake.com, Account, View account details. The orgname-accountname part of your account URL
- User
SNOWFLAKE_USER- A user made for the app, not your own
- Password
SNOWFLAKE_PASSWORD- The password of that user
- Role optional
SNOWFLAKE_ROLE- The role the app runs as, like SYSADMIN or PUBLIC. Never ACCOUNTADMIN or SECURITYADMIN
- Warehouse optional
SNOWFLAKE_WAREHOUSE- The warehouse to run queries on
- Database optional
SNOWFLAKE_DATABASE- The default database
How to connect.
-
Open your project, or start a new one from the dashboard.
-
Open the workspace menu and choose Connectors, then pick Snowflake.
-
Paste the keys and save. Your preview restarts, and your app can use the service from then on.
Then ask for the feature
- “Show monthly revenue from my Snowflake sales table”
- “Let managers run saved reports on Snowflake”
What happens to your keys.
- Each key is saved as a private setting of your project, under the name shown above.
- The AI that builds your app sees only the names. It writes code that reads each key by name, and never the value.
- The values reach your preview and your published app, and never the chat, the code or the logs.
- Open Connectors in your project to replace a key or disconnect the service. Publish again so your live app uses the change.
Service names and logos belong to their owners; Crisp is not affiliated with them. A service changes its keys and pages now and then. Found something out of date? Tell us and we will correct it.
Ask for the feature, and Crisp builds it with Snowflake.
Free plan with $3 of AI usage a month, no credit card. Pro is $20 a month. See pricing.
No credit card. Your code and data stay yours.