9 min read

PostgreSQL FDW aggregation pushdown part II: Snowflake speedup

Feb 9, 2022· By Marko Grujić
We demonstrate a concrete application of aggregation pushdown mechanism in the form of our Snowflake FDW. Actual performance benefits are quantified for a selection of real-life examples.
Read more
 
featured-img
Feb 8, 2022 ·By Artjoms Iškovs
3 min read

Share datasets like Notion pages

Splitgraph now supports advanced data sharing settings. Make a repository private, invite a collaborator and control their level of access, all from a simple Web UI.
Read more
 
Feb 4, 2022 ·By Marko Grujić
15 min read

PostgreSQL FDW aggregation pushdown part I: modifying Multicorn

We recently implemented support for aggregation and grouping pushdown in the Multicorn FDW. In this post, we'll demonstrate it on a simple toy example and discuss how PostgreSQL aggregation pushdown works in general.
Feb 3, 2022 ·By Artjoms Iškovs
10 min read

Scheduling, versioning and cataloging: introducing our dbt integration

We showcase the ability to run dbt models on Splitgraph, triggering them on a schedule as well as using GitHub Actions. We also talk about how it works and share more plans for our dbt integration.
Feb 2, 2022 ·By Miles Richardson
3 min read

Drag, drop and share CSV files as queryable SQL tables

You can now upload CSV files to Splitgraph from the web, so that you can query them with SQL by pointing your Postgres client to the Data Delivery Network (DDN). Share data publicly or with only those you invite – all discoverable and queryable from a single unified interface.
Dec 23, 2021 ·By Artjoms Iškovs
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.
Dec 20, 2021 ·By Marko Grujić
5 min read

Preview Environments: Spinning up temporary Splitgraph instances from any commit

We talk about how we use GitLab's review apps functionality to preview and test Splitgraph Cloud deployments.
 
2 / 4