Skip to main content
Snowflake is a cloud data platform that stores and queries large analytical datasets. Connecting it to Softr lets you build dashboards, reports and internal tools on top of warehouse data, without exporting it anywhere first. You connect Snowflake once at the workspace level, then point individual blocks at the tables you want to show.
Softr authenticates to Snowflake with a programmatic access token, not a password. You generate the token in Snowsight and paste it into Softr.

​
Before you start

Have these ready from your Snowflake account:
  • Your account identifier, in orgname-account_name form — for example myorg-myaccount. To find it in Snowsight, open the account selector and choose View account details. See Snowflake’s account identifiers reference if yours is in the older account-locator format.
  • The user Softr should authenticate as.
  • A programmatic access token for that user. In Snowsight, go to Governance & security → Users & roles, select the user, open Programmatic access tokens and choose Generate new token. Tokens expire after a maximum of 365 days, and your admin may have shortened that with an authentication policy.
  • A network policy that permits the connection. Snowflake requires one to use a token, and requires one up front for service users. Your Snowflake admin can attach it to the account or to the single user — see network policy requirements.
Give Softr a dedicated Snowflake user with read-only access to just the warehouse, role and database you intend to expose. It keeps the token’s blast radius small, makes it easy to revoke, and lets you scope the network policy to that one user.

​
Connect Snowflake to Softr

1

Open Integrations

In the Softr dashboard, select Integrations in the left sidebar, then click Connect new.
The Softr dashboard Integrations page with the Connect new button highlighted

The Integrations page, where all external data sources are managed.

2

Choose Snowflake

Pick Snowflake from the Select an integration list.
The Select an integration dialog with the Snowflake tile outlined in red

Snowflake in the integration picker.

3

Enter your connection details

Fill in the connection form:Leaving Warehouse, Role and Database empty uses the defaults configured for the user in Snowflake.
The Connect to Snowflake dialog with the User and Programmatic access token fields outlined in red

The Snowflake connection form. User and Programmatic access token are both required.

4

Connect

Click Connect. The button stays disabled until every required field is filled. Once the connection succeeds, Snowflake appears in your Integrations list and is available to blocks across your apps.

​
Show Snowflake data in your app

1

Point a block at a Snowflake table

Add a dynamic block — a List, Table or Chart — then open its Block source tab and select your Snowflake connection. Choose the database, schema and table you want to display.
2

Map fields

Choose which Snowflake columns map to which fields in the block, the same way you would for any other data source. See Visualize data with building blocks for the mapping options each block type offers.

​
Troubleshooting

The usual cause is a missing network policy. Snowflake requires one before a programmatic access token can be used, and requires one up front for service users. Ask your Snowflake admin to confirm a policy is attached to the account or to the user Softr connects as.Also check the token has not expired — 365 days is the maximum, and an authentication policy can shorten it.
If you left Warehouse, Role or Database empty, Softr falls back to the user’s defaults in Snowflake. If that user has no default warehouse or role, set them explicitly on the connection.
Softr expects the orgname-account_name form, not the legacy account locator and not a full URL. Open the account selector in Snowsight and choose View account details to read the current identifier.

Choosing a data source

Compare Snowflake against the other data sources Softr supports.

BigQuery

Another warehouse integration, with a similar dashboard-first setup.

SQL Database

Connect PostgreSQL, MySQL, SQL Server or MariaDB.

Snowflake documentation

Snowflake’s own reference for tokens, account identifiers and network policies.