| CARVIEW |
Splitgraph has been acquired by EDB! Read the blog post.
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 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.
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.
Splitgraph
Splitgraph Inc, registered in Delaware, USA
Splitgraph Limited, registered in England and Wales No. 11657324
Made with
on four continents.