Splitgraph has been acquired by EDB! Read the blog post.
13 min read
Supercharging dbt with Splitgraph: versioning, sharing, cross-DB joins
Jul 14, 2020· By Artjoms Iškovs
We discuss how you can use Splitgraph with dbt to add versioning and cross-database joins to dbt models. We also show how to use dbt to reference Splitgraph datasets, including through a purpose-built Splitgraph adapter.
Jul 13, 2020 ·By Artjoms Iškovs
6 min readThrowing away the backend: Towards a data delivery network
We discuss the trends of serverless and edge computing, talk about why our SQL server is open to the public and propose the idea of a data delivery network.
Jul 8, 2020 ·By Miles Richardson
7 min readQuerying 40,000+ datasets with SQL
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.
Jul 8, 2020 ·By Artjoms Iškovs
7 min readSplitgraph infrastructure, part 2: Integration testing with Docker Compose
We continue our overview of Splitgraph's internal build infrastructure by talking about how we run end-to-end integration tests. We also discuss using Jinja to generate configuration and inject secrets into our components.
Jul 6, 2020 ·By Artjoms Iškovs
8 min readSplitgraph infrastructure, part 1: Using Make to build multiple Docker images efficiently
We begin our overview of Splitgraph's internal build infrastructure by discussing how we build Docker images in development and CI using Make and Docker BuildKit.
Jul 2, 2020 ·By Artjoms Iškovs
9 min readForeign data wrappers: PostgreSQL's secret weapon?
We talk about foreign data wrappers, a PostgreSQL feature that lets you query remote databases directly from your PostgreSQL instance. We also demonstrate how to integrate them with Splitgraph.
Jun 30, 2020 ·By Artjoms Iškovs
5 min readTreat your datasets like cattle, not pets
We talk about the "pets versus cattle" idea in software and discuss how Splitgraph helps to apply it to data science and data engineering.
Splitgraph
Made with
on four continents.