Splitgraph has been acquired by EDB! Read the blog post.
Loading...Loading...Loading...Loading...Loading...

Query anything and everything.

Query 40,000 public data tables on the Data Delivery Network. Connect to private data sources and import them as versioned snapshots, or query them live. Give every table an address.

  • Joins
  • Time Travel
  • Standard SQL
  • PostGIS & GeoSpatial
Join across tables from live datasets
-- Join across two tables at different government data portals (Chicago and Cambridge)
-- Splitgraph will rewrite the queries into the providers' query language, get the data
-- and run the JOIN, returning the results over the PostgreSQL protocol.
SELECT
    cambridge_cases.date AS date,
    chicago_cases.cases_total AS chicago_daily_cases,
    cambridge_cases.new_positive_cases AS cambridge_daily_cases
FROM
    "cityofchicago/covid19-daily-cases-deaths-and-hospitalizations-naz8-j4nc".covid19_daily_cases_deaths_and_hospitalizations chicago_cases
FULL OUTER JOIN
    "cambridgema-gov/covid19-case-count-by-date-axxk-jvk8".covid19_case_count_by_date cambridge_cases
ON
    date_trunc('day', chicago_cases.lab_report_date) = cambridge_cases.date::timestamp
ORDER BY date ASC;

Most SQL Clients

The Splitgraph "Data Delivery Network" (DDN) is based on, and compatible with any client of, the PostgreSQL wire protocol.

View more
 

Metabase

Use Metabase as a BI tool for all the data you connect to Splitgraph.

Excel and Power Query via ODBC

Query Splitgraph from Microsoft Excel via Power Query with ODBC via psqlODBC.

Google Data Studio

Query Splitgraph from Google Data Studio.

Python (psycopg2)

Send SQL queries to the DDN using any PostgreSQL-compatible language driver, like psycopg2 for Python.

DataGrip (datagrip)

Configure Splitgraph as a regular Postgres database in DataGrip.