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. 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;
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.