DouenergyinIn the PipelineFrom Zero to dbt: Part 2 — Modeling Spotify’s Million Playlist Datasetdbt helps us encapsulate logic within individual models and promotes a more structured and manageable development workflow12 min read·6 days ago----
DouenergyinIn the PipelineAnalytical SQL Tips Series — Lateral Column AliasSimplify your SQL by reusing expressions with Lateral Column Alias2 min read·May 10, 2024--1--1
DouenergyinIn the PipelineAnalytical SQL Tips Series —Qualify ClauseIn SQL, the QUALIFY clause is essential for filtering results from WINDOW functions, serving a similar purpose as the HAVING clause does…2 min read·Apr 19, 2024--2--2
DouenergyinIn the PipelineFrom Zero to dbt: How to Analyze and Build Data Models from Spotify’s Million Playlist DataPart 1: Analyze the 30GB json dataset with DuckDb and jq, then convert to Parquet to prep for dbt10 min read·Apr 12, 2024--3--3
DouenergyinIn the PipelineAnalytical SQL Tips Series — Filter ClauseIn SQL there’s often more than one way to skin a cat, er… filter an aggregate. Here’s a SQL tip for those of you using DuckDB or Postgres2 min read·Apr 9, 2024----
DouenergyinIn the PipelineAnalytical SQL Tips Series — ORDER BY ALLORDER BY ALL helps streamline the sorting process removing the need to manually specify which columns to sort by3 min read·Apr 3, 2024----
DouenergyinIn the PipelineAnalytical SQL Tips Series — GROUP BY ALLGoogle BigQuery has recently added support for a new syntax called GROUP BY ALL, find out how this makes SQL querying more convenient…2 min read·Mar 22, 2024----