logo-icon

By Artjoms Iškovs

blog-shape
7 min read

Airbyte, dbt, Splitgraph: how we built our modern data stack

We talk about our modernized data stack that uses Airbyte for data ingestion, dbt for transformations and Splitgraph itself for storage, versioning, discoverability and querying.

featured-img
Sep 18, 2020 · By Artjoms Iškovs
10 min read

Dogfooding Splitgraph for cross-database analytics in Metabase

Sep 18, 2020 · By Artjoms Iškovs

We talk about how we use Metabase, Splitgraph and PostgreSQL foreign data wrappers to build BI dashboards that are backed by federated queries across our Matomo and Elasticsearch instances.

Aug 19, 2020 · By Artjoms Iškovs, Miles Richardson
7 min read

Port 5432 is open: introducing the Splitgraph Data Delivery Network

Aug 19, 2020 · By Artjoms Iškovs, Miles Richardson

We launch the Splitgraph Data Delivery Network: a single endpoint that lets any PostgreSQL application, client or BI tool to connect and query over 40,000 public datasets hosted or proxied by Splitgraph.

Jul 28, 2020 · By Artjoms Iškovs
8 min read

Splitgraph infrastructure, part 3: Using Docker Compose in production

Jul 28, 2020 · By Artjoms Iškovs

We finish our overview of Splitgraph's infrastructure by talking about why and how we use Docker Compose to run the Splitgraph registry in production.

Jul 14, 2020 · By Artjoms Iškovs
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 read

Throwing away the backend: Towards a data delivery network

Jul 13, 2020 · By Artjoms Iškovs

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 Artjoms Iškovs
7 min read

Splitgraph infrastructure, part 2: Integration testing with Docker Compose

Jul 8, 2020 · By Artjoms Iškovs

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.

NaN / 2