HYBRID ANALYTICS

Best of both worlds

Keep operational data where it lives — on-prem MySQL, Oracle, SQL Server. Join it with cloud warehouse data from Snowflake or Databricks. DuckDB federates the query locally. No data leaves your network unless you want it to.

REAL-WORLD EXAMPLE

A hospital system joins on-prem Oracle EHR data with Snowflake claims analytics. Patient data never leaves the on-prem network — only aggregated insights materialize to the cloud.

DATA FLOW

WHAT ENABLES THIS

THE FEDERATION ENGINE →

the join executes locally in DuckDB — raw rows from each side never visit the other

SOURCES.YML & META.CONNECTION →

each source binds to its own connection; one model reads both worlds

PER-MODEL TARGETS →

config(target=...) decides which results land in the cloud and which stay home

RELATED USE CASES

CLOUD REPATRIATION

Bring your data home

ON-PREM BI ACCELERATION

Dashboards in minutes

Sound like your situation? You can have the first model running today.

QUICKSTART PRICING