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
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
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
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
Deleting data is always an exciting (or nerve-wracking?) task! In this article, we will explore… Read More »SQL DELETE vs TRUNCATE – Deleting Data
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
Are you considering migrating to GCP? Today, I’d like to share an example of how… Read More »Example of Building ETL Topology on GCP
In this article, we will explore how to use the SQL QUALIFY clause with window… Read More »SQL QUALIFY – Filtering Data More Precisely with Window Functions
In this article, we will explain two commonly used SQL query features: SELECT DISTINCT and… Read More »SQL SELECT – Removing Duplicates and Excluding Specific Columns
In a data analyst interview, various questions can be asked to assess data analysis and… Read More »[SQL Interview] Differences Between CTE and Subquery