Snowflake Databases & Warehouses

Connect Snowflake


Dashboards, a full API and MCP access over your Snowflake data. Hosted in Finland. Self-hostable, or buy the platform outright and run it yourself.

Portable technical infrastructure to any cloud.

A production-ready foundation designed to scale. Plug in pre-built modules for common workflows, or build your own on top.

Enterprise-grade from day one

Live from the first day, and portable later to any system. No vendor lock-in to Jourier: take the code, the schema and the models and run them yourself.

Hosted in Finland

Data and AI run in a Finnish data centre. UpCloud in Helsinki, and Mistral trained with CSC on the LUMI supercomputer in Kajaani.

Enterprise modular architecture

Scales to any level, from a new startup to a large enterprise. Build your own modules, or change the ones that ship.

The stack behind the unicorns

Talos Linux, Kubernetes and Cilium. GitOps deployments, a separate database per customer, automated security controls and self-healing.

Snowflake API

One API over Snowflake and everything else

Most systems expose one API shaped around their own storage. Useful, but you build against that shape, handle its pagination, and repeat the exercise for every other system you own.

Jourier reads Snowflake and serves the result as modelled JSON, on one endpoint, alongside every other system you connect. It is joined, typed and reconciled to what the dashboards show.

  • Tables, schemas and load history as first-class objects
  • The same numbers the dashboards use, from one definition
  • Your Snowflake contract stays yours; Jourier resells nothing
Your data, your query
# freshness and row counts, by modelled table
GET /v1/warehouse/tables?status=modelled

{
  "source": "snowflake",
  "as_of":  "2026-08-16T06:12:00Z",
  "rows": [
    { "table": "fct_orders", "rows": 1284310,
      "fresh_min": 6, "tests_passing": true }
  ]
}
Snowflake MCP

Ask Claude about your own tables

Model Context Protocol is how an AI assistant calls a real tool instead of guessing. Jourier exposes your connected systems as MCP tools, so Claude, Cursor or any MCP client can query Snowflake directly, and answer from the modelled tables rather than from a plausible sentence about them.

Every answer resolves to rows you can open. The model retrieves; it does not compute the number, which is the only reason the answer is worth having.

  • Works with Claude Desktop, Cursor, and any MCP-compatible client
  • Scoped to what that user is allowed to see
  • Self-hosted models available, so your data never leaves the EU
Claude · jourier
You
Which modelled tables are stale,
and what feeds them?

Claude
Two are over an hour behind.
Both wait on the same upstream load.
Where the data lands

Snowflake data in the tool you already use

Each has its own setup page: what syncs, how often, and what the schema looks like on arrival.

Connecting Snowflake

Paste credentials, nothing to install

Access is granted per customer, so connecting is a matter of pasting keys. Nothing is installed and no port is opened.

What you'll need

Server URL
Required
Role
Required
Warehouse
Required
Database
Required
Username
Required
Password
Secret
Access
Read only
Questions

Snowflake and Jourier, answered

Can I get Snowflake data into a dashboard?

Yes. Jourier models on top of your existing Snowflake environment and serves the result as dashboards that are already built, reading the same tables your team already has.

Does Jourier write anything back to Snowflake?

No. The connection is read-only against Snowflake. Nothing is written back.

Where is Snowflake data stored when I use Jourier?

In Finland, on EU infrastructure, under EU law. The AI that reads it is self-hosted, so your data is never a US vendor’s training material.

How long does connecting Snowflake take?

The connector is live. Connecting is a matter of pasting credentials: nothing is installed and no port is opened, and data flows the same day.

Can I use Snowflake data from Claude or another AI tool?

Yes. Jourier exposes MCP tools, so Claude, Cursor or any MCP client can query the modelled Snowflake tables directly and answer from them rather than from a plausible sentence about them. Access is scoped to what that user is allowed to see.

Can I run it on my own infrastructure?

Yes. It is standard Kubernetes built on open components. You can take the manifests and run it on your own cluster whenever you decide to, and there is no proprietary runtime holding you in.

Does this work with other systems as well as Snowflake?

Yes. Jourier serves Snowflake alongside every other system you connect, on one endpoint, joined, typed and reconciled to what the dashboards show.

Get started
Self-serve

Try the demo

Instant access to Jourier Lens. Business email only.