Skip to content

Snowflake analytics, without the export

Snowflake is where most companies have already modelled the business, so the tables are clean and the bottleneck is getting a question answered against them.

Free plan. No credit card required.

What teams ask of Snowflake

Typed the way you would say them. Each answer comes back with its chart, its numbers and the SQL that produced them, so it can be checked before anyone acts on it.

  • “How does this month's revenue reconcile against the source system it was loaded from?”
  • “What does the funnel look like on finance's definition of a qualified account rather than marketing's?”
  • “Which customers grew their usage last quarter, and which quietly shrank?”
  • “What is retention by cohort on the gold tables?”
  • “Which accounts show up in the CRM mart but not in the billing mart?”

What it is combined with

The questions that matter rarely live in one system. An agent can hold more than one source: ask a question that spans them and Supaboard queries each one, then combines the results, so the comparison happens when the question is asked rather than in a pipeline project that has to be scoped first.

  • PostgreSQL — the modelled history in the warehouse, against what the application database says right now.
  • Microsoft SQL Server — the finance marts, against the ledger they were loaded from.

How the connection works

Snowflake is one of the 12 databases and warehouses you can connect yourself. It connects directly and is queried when a question is asked, with nothing copied ahead of time, so setting up a first analysis takes about 5 minutes.

The form takes a host, a user, a database and a schema, and it asks which warehouse should run the queries, so Supaboard's compute lands on a bill you control. A programmatic access token works in place of a password. Databases and schemas are suggested from what those credentials can actually read, and a connection pointed at one they cannot reach will not save.

  • Database and warehouse queries are read-only. Changes to connected apps require your approval.
  • Credentials are encrypted at rest, scoped per workspace, never logged and never returned to a client.
  • On the Enterprise plan the whole platform runs inside your own VPC. Supaboard receives no platform data; inference follows the model endpoint you configure. See Enterprise.
  • A free plan with no credit card, then from $19 per editor per month — see pricing.

More sources

Other connectors with a guide:

Also in Databases & warehouses: PostgreSQL, MySQL, Microsoft SQL Server, Oracle, MongoDB, Supabase, BigQuery, AWS Redshift, Databricks, ClickHouse, MotherDuck. See how files, databases and warehouses connect.

Weighing this against another tool? See the sourced comparison of 24 BI tools, or what one agent for the whole analyst job does with a connection like this one.

Data warehouses

Ask your first question from Snowflake

Start FreeBook a 30-minute demo

Free plan. No credit card required.