Universql

Effortless
multi-engine apps

Use your compute infrastructure on your Snowflake account, powered by DuckDB and Apache Iceberg

Install LocallyGithub Run on CodespacesAWS Lambda Deploy to AWS

Use-cases

10x more efficient Snowflake compute

Universql uses DuckDB as compute layer alternating Snowflake warehouses.

Compute is the main driver of Snowflake costs and DuckDB is 90% cheaperthan X-Small warehouse.

Build customer facing analytics apps on Snowflake

Like a CDN that speeds up your website by serving content from nearby locations, Universql brings data computations closer to users. Instead of just caching files, it runs analytics at the edge, making your Snowflake-powered apps lightning-fast.

App
Universql
Snowflake

CDN for your data warehouse

Universql lets you ingest & transform & serve data from your Snowflake account without paying premium price for the warehouse.

BI Tools
dbt & SQLMesh
Reverse ETL
Snowflake

Prototype locally and deploy to Snowflake

Universql allows you to develop and test data pipelines locally, enabling you to combine local files with Snowflake data before deploying your models to Snowflake.

Local
CI

How it works

import snowflake.connector
conn = snowflake.connector.connect(
    account='xy12345.us-east-1',
    user='username',
    password='password',
    host='localhostcomputing.com',  # [✓] Use local compute
    warehouse='COMPUTE_WH',
    database='DEMO_DB'
)
cursor = conn.cursor()
cursor.execute("SELECT * FROM users")
Python
Iceberg Metadata
DuckDB Compute
Filesystem Cache
SnowflakeSnowflake

If possible locally, DuckDB runs the query; otherwise, it's sent directly to Snowflake.

01

Ingest Data

Create Iceberg tables to ingest your data with two way sync with Snowflake.
02

Transform Data

Transform data with SQL or use tools such as dbt and SQLMesh.
03

Analyze Data

Speed up your BI tools and reduce costs by using Universql as a cache layer on top of your Snowflake account.
04

Activate Data

Use Reverse ETL such as Hightouch and Census to load data from Snowflake to your favorite tools.

Latest from our Blog

View all posts

Optimizing Database Performance with Universql

Deep dive into database performance optimization techniques using Universql, from query optimization to caching strategies.

Welcome to Universql Blog

Introducing Universql's new blog where we'll share insights, updates, and best practices for database querying.

FAQs

Common Questions