Splitgraph has been acquired by EDB!
Read the blog post.
Product
Community
Data Delivery Network (DDN)
Public Postgres DB with 40k+ data products
Enterprise
Managed Data Platform
Private deployments of Splitgraph
Email Us
Schedule Zoom conversation
Data Consumers
Data Catalog
Build a shared metadata layer with your team
Queryable Data Models
Deploy dbt models as self-updating data products
Unified SQL interface
Query all data through a single Postgres endpoint
Data Producers
Live Data Federation
Connect live data sources directly to Splitgraph
Versioned Data Ingestion
Schedule data imports into object storage
Data Sources
PostgreSQL
Snowflake
MySQL
Google BigQuery
CSV files in S3/HTTP
Stripe
Facebook Marketing
Google Sheets
Shopify
Google Ads
View all 100+ data sources
Docs
Basics
Introduction
Learn the basics of Splitgraph
5 Second Demo
Run a sample SQL query in milliseconds
Frequently Asked Questions
See if we can answer your question
All Documentation
Jumpstart Guides
Mapbox Dashboard
Plot geographic query results with Mapbox
Observable Notebook
Query private data from observable notebooks
Google Sheets
Query data directly from Google Sheets
BigQuery
Query BigQuery through Splitgraph
All Jumpstarts
Reference
PostgreSQL Clients
Learn how to connect specific SQL clients to the DDN
sgr
CLI
Manage and orchestrate Splitgraph with
sgr
splitgraph.yml
Orchestrate declarative data infrastructure
Blog
Seafowl
NEW!
Try Now
Add Data
Connect External Data
Import or mount data from 100+ sources
Generate
splitgraph.yml
Setup scheduled ingestion pipelines
Upload CSV to SQL
Query CSV with SQL in 60 seconds
Docs Overview
Explore Data
Public Data
Explore public data on Splitgraph
Query Data
Web IDE
Query Splitgraph from the browser
Get Credentials
Connect your Postgres client to the DDN
Search Data
Loading...
Sign In
Create free account
Sign into Splitgraph
Get SQL credentials
data
7 min read
Querying 40,000+ datasets with SQL
Jul 8, 2020
·
By
Miles Richardson
Learn about how Splitgraph indexes over 40,000 datasets from government and public sources using the Socrata API, Splitgraph mounting, and PostgreSQL foreign data wrappers.
Read more