Import immutable snapshots of data from hundreds of sources, or connect directly to live backend data sources.
Safely publish fresh data from your warehouse or database without replicating it to Splitgraph
Import data from over 100 SaaS vendors and databases, powered by Airbyte
Go from CSV to SQL in seconds... Upload a CSV file (or files!) and start querying it
Upload your dbt Core project to Splitgraph and run data transformations
Import from other data on Splitgraph, including over 40,000 open government datasets
Write to Splitgraph directly from a PostgreSQL client with standard SQL.
# TODO: figure out caching
# TODO: fix 'where' parsing breaking
# TODO: precompute this??? DB indexes?
# TODO: migrate bash script to real language
# TODO: should i hire someone for this???
curl https://api.myproject.com/data\
\?groupBy=timestamp,month,country\
\&select=count.distinct.user\
\&where=timestamp.year.eq.2022
# TODO: add more visualizations :)
curl https://data.splitgraph.com/sql/my-app \
-d@- <<EOF
{"sql": "SELECT
date_trunc('month', date),
country,
COUNT(DISTINCT user_id)
FROM stats.users
WHERE date_part('year', date) = 2022
GROUP BY 1, 2"}
EOF
• Query and aggregate your data with a language built for querying: SQL.
• Execute queries straight from the user's browser to power interactive visualizations and dashboards without worrying about where to host the data.
• Or, connect to Splitgraph's PostgreSQL endpoint with your own clients and dashboarding tools.
• Let us worry about the REST...
• Splitgraph uses PostgreSQL and columnar storage, combining a familiar SQL syntax with fast performance for aggregation and reporting queries.
• Support for Seafowl, out new database powered by DataFusion and Parquet, coming soon.
Splitgraph makes it easy to build data-driven applications