Blog

Our platform now supports connections to Materialize. If you've ever wished you could just write materialized views and let the database handle keeping results up to date, your dreams just came true.

We're excited to unveil the latest addition to our PopSQL database connections: Trino SQL engine! For those who may not be familiar, Trino is an exceptional open-source, distributed SQL query engine.

Complex queries in SQL don't need to be hard to write. Learn what they are, how to create them, and some examples in this article.

In this guide, we aim to provide an in-depth understanding of the importance of dbt testing in data engineering, explore various types of dbt tests, and offer effective strategies to incorporate these tests into your data workflow.

In this article, you'll learn what normalization is, what the benefits are, and how to perform normalization in SQL using some database normalization examples.

Unlock the power of dbt, a transformative tool for designing, implementing, and testing data model workflows. Our comprehensive guide demonstrates how to use dbt models, streamline workflow standardization, and effectively manage dependencies.

The modern data stack provides efficient, cost-effective data processing solutions. This article delves into its makeup, advantages, contrasts with traditional stacks, practical implementation advice, and PopSQL's contribution in this landscape.

New enhancements to make PopSQL the best way for data analysts to work with their BigQuery data