YOY Calculation: How to Calculate Year-Over-Year Growth
OCT 15, 2023
Uncover the significance of Year-over-Year (YoY) growth in business analysis. Our guide offers a quick understanding of its calculation, SQL implementation, and impactful visualization. Ideal for data professionals eager to leverage YoY growth for strategic decision-making.
Snowflake vs Redshift: Key differences and comparison
OCT 12, 2023
Explore the Snowflake vs Redshift comparison to discover your ideal data warehousing match. Learn more about enhancing your data warehousing experience with PopSQL, a modern SQL editor that complements both Snowflake and Redshift.
dbt Best Practices: Superpower Your dbt Project with PopSQL
OCT 10, 2023
Maximize your dbt project's potential with PopSQL. Learn how to connect databases, streamline testing, and manage schema changes efficiently. Enhance your data analysis workflow and productivity with this comprehensive guide.
ChatGPT for SQL: How to Write SQL Queries with OpenAI
SEP 28, 2023
Data is only as good as the queries we run, and SQL remains the quintessential tool for accessing, modifying, and manipulating this data. But what if we could leverage artificial intelligence to help write and optimize SQL queries? We delved deep into how LLMs could revolutionize the SQL writing process.
How to Write dbt Macros using Jinja
SEP 22, 2023
In the dynamic world of data analytics, understanding dbt macros and their interaction with Jinja enhances efficiency. This post delves into the specifics of dbt macros, highlights the wonders of Jinja, and explores how dbt integration can improve macro creation and testing.
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.