SQL users: Halve the length of (some of) your queries with this one trick
In this article, I’m going to introduce you to the SQL QUALIFY clause: a trick that will help you write shorter and more readable SQL queries. If you work in Data Science/Analytics or Machine Learning, this is a must-have SQL tool for four reasons:- 20555Murphy ≡ DeepGuide
Cooking with Snowflake
Snowflake optimisation The Snowflake community is rife with information dumps on how to optimize expensive queries. We know because we combed through a ton of them. What we present here are three tactical ways in which we’ve done this at Toplyne. To- 26759Murphy ≡ DeepGuide
Why Your Data Pipelines Need Closed-Loop Feedback Control
As data teams scale up on the cloud, data platform teams need to ensure the workloads they are responsible for are meeting business objectives, our main mission here at Sync. At scale with dozens of data engineers building hundreds of production jobs, con- 29654Murphy ≡ DeepGuide
dbt Core, Snowflake, and GitHub Actions: pet project for Data Engineers
Pet Project for Data/Analytics Engineers: Explore Modern Data Stack Tools - dbt Core, Snowflake, Fivetran, GitHub Actions.- 28441Murphy ≡ DeepGuide
The Unstructured Data Funnel
Why a funnel is the centre of the war between data's heaviest hitters- 22739Murphy ≡ DeepGuide
5 More Snowflake Query Tricks You Should Be Using
Even fewer lines, and faster execution time, and some NLP- 22782Murphy ≡ DeepGuide
Monitor Data Pipelines Using Snowflake's Data Metric Functions
Build Trusted Data Platforms with Google SRE Principles- 25821Murphy ≡ DeepGuide
Mastering SQL Optimization: From Functional to Efficient Queries
Six Simple Yet Effective SQL Tips That Helped Me Reduce 50 Hours of Snowflake Query Time Every Day- 21801Murphy ≡ DeepGuide
Creating Dynamic Pivots on Snowflake Tables with dbt
Leverage dbt and its advanced scripting functionality to generate dynamic pivot tables that adapt to changing pivot values- 28625Murphy ≡ DeepGuide
Synthetic Data in Practice: A Shopify Case Study
Testing new Snowflake functionality with a 30k records dataset- 28778Murphy ≡ DeepGuide
We look at an implementation of the HyperLogLog cardinality estimati
Using clustering algorithms such as K-means is one of the most popul
Level up Your Data Game by Mastering These 4 Skills
Learn how to create an object-oriented approach to compare and evalu
When I was a beginner using Kubernetes, my main concern was getting
Tutorial and theory on how to carry out forecasts with moving averag