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.
-- 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.
cambridge_cases.date AS date,
chicago_cases.cases_total AS chicago_daily_cases,
cambridge_cases.new_positive_cases AS cambridge_daily_cases
FULL OUTER JOIN
date_trunc('day', chicago_cases.lab_report_date) = cambridge_cases.date::timestamp
ORDER BY date ASC;
The Splitgraph "Data Delivery Network" (DDN) is based on, and compatible with any client of, the PostgreSQL wire protocol.
Use Metabase as a BI tool for all the data you connect to Splitgraph.
Query Splitgraph from Microsoft Excel via Power Query with ODBC via psqlODBC.
Query Splitgraph from Google Data Studio.
Send SQL queries to the DDN using any PostgreSQL-compatible language driver, like psycopg2 for Python.
Configure Splitgraph as a regular Postgres database in DataGrip.