SQL Data Type Conversions: Understanding and Using cast and safe_cast
Data type conversions play a crucial role in data processing and analysis, particularly in SQL… Read More »SQL Data Type Conversions: Understanding and Using cast and safe_cast
How to Filter Specific URLs in SQL: Using regexp_contains
When managing or analyzing web analytics data, you often need to exclude test URLs or… Read More »How to Filter Specific URLs in SQL: Using regexp_contains
DBT Guide for Beginners in Data Engineering
DBT (Data Build Tool) is an open-source tool designed for data engineers and analysts, enabling… Read More »DBT Guide for Beginners in Data Engineering
Version Control Guide for Beginner Data Engineers
Version control using GitHub is essential for systematically managing collaboration and maintaining code quality in… Read More »Version Control Guide for Beginner Data Engineers
String Concatenation in BigQuery: Comparing CONCAT Function and || Operator
In BigQuery, there are two main ways to concatenate strings: the CONCAT function and the… Read More »String Concatenation in BigQuery: Comparing CONCAT Function and || Operator
PM techniques to prevent failure and help you launch successfully: Pre-Mortem
This article summarizes the contents of “How Meta and Instagram Use Pre-Mortems to Avoid Post-Mortems.”… Read More »PM techniques to prevent failure and help you launch successfully: Pre-Mortem
A Comprehensive Guide to Rebuilding Persistent Derived Tables (PDTs) in Looker
Exploring Persistent Derived Table (PDT) Rebuilding in Looker In this article, we delve into the… Read More »A Comprehensive Guide to Rebuilding Persistent Derived Tables (PDTs) in Looker
Mastering _TABLE_SUFFIX in BigQuery: Query Multiple Daily Tables with Ease
Let’s explore the _TABLE_SUFFIX feature in BigQuery SQL, which is frequently used and particularly helpful… Read More »Mastering _TABLE_SUFFIX in BigQuery: Query Multiple Daily Tables with Ease
SQL DELETE vs TRUNCATE – Deleting Data
Deleting data is always an exciting (or nerve-wracking?) task! In this article, we will explore… Read More »SQL DELETE vs TRUNCATE – Deleting Data
How to fix WordPress HTTP ERROR 500 and Memory Issue
I was about to write a new blog post after a long time, but suddenly… Read More »How to fix WordPress HTTP ERROR 500 and Memory Issue