Introducing Materialize Support in PopSQL!
SEP 12, 2023
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.
Announcing Trino Support in PopSQL!
SEP 7, 2023
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 SQL Queries: Examples & Advanced Techniques
AUG 25, 2023
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.
Mastering dbt Testing for Your Cloud Database (Best Practices)
AUG 11, 2023
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.
Normalization in SQL DBMS: 1NF, 2NF, 3NF, and BCNF Examples
JUL 26, 2023
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.
How to Write a dbt Model in SQL: Examples & Best Practices
JUL 13, 2023
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.
An Exploration of the Modern Data Stack
JUL 5, 2023
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 ways to focus, work faster and more efficiently with BigQuery using PopSQL
JUL 26, 2022
New enhancements to make PopSQL the best way for data analysts to work with their BigQuery data