Published inWren AIPowering AI-driven workflows with Wren Engine and Zapier via the Model Context Protocol (MCP)Use semantic understanding, SQL generation, and email automation to streamline data requests with LLM agents and Wren’s powerful query…5d ago5d ago
No Bandwidth? No Problem: Why We Think Local Cache is Great for DuckdBIf, in some cataclysm, all of scientific knowledge were to be destroyed, and only one sentence passed on to the next generations of…Mar 8Mar 8
Published inIn 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 workflowMay 13, 2024May 13, 2024
Published inIn the PipelineAnalytical SQL Tips Series — Lateral Column AliasSimplify your SQL by reusing expressions with Lateral Column AliasMay 10, 20241May 10, 20241
Published inIn 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…Apr 19, 20242Apr 19, 20242
Published inIn 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 dbtApr 12, 20245Apr 12, 20245
Published inIn 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 PostgresApr 9, 2024Apr 9, 2024
Published inIn 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 byApr 3, 2024Apr 3, 2024
Published inIn 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…Mar 22, 2024Mar 22, 2024
