Google BigQuery: Converting Timezones in a datetime column – Sample code inside
Mastering timezone conversion in Google BigQuery In the world of global data analytics, dealing with data across multiple time zones…
Extracting minutes from timestamp in Google BigQuery and handling in PySpark
Often in data analytics, there’s a need to extract specific parts of a date or timestamp for more granular analysis….
Google BigQuery: Truncate date and timestamp – Example with sample data included
When dealing with data in Google BigQuery, especially time-series data, it’s common to want to truncate dates and timestamps to…
Comparing two tables in Snowflake – An easy to implement document
When working with Snowflake, there might be scenarios where you need to compare two tables to determine differences. These differences…
Google BigQuery: Filling null dates with previous row value
In the data world, it’s not uncommon to encounter scenarios where certain records might have missing date values. In BigQuery,…
CICD : The benefits of automating build, test, and deployment processes
In the software development world, the ability to automatically build, test, and deploy code has revolutionized the way teams deliver…
Comparing Git branch differences while ignoring specific directories
In this article, we’ll guide you through the process of comparing differences between two Git branches, and we’ll also show…
DBT : Understanding the core tenets of data mesh
To fully appreciate the innovative approach of data mesh compared to traditional monolithic structures, we must delve into its foundational…
DBT : Understanding Data mesh: Its definition and significance
Software development and data analytics share many similarities, particularly when it comes to managing large-scale tasks, intricate operations, growing collaboration,…
Understanding dbt Model Selection: A Deep Dive into +dbtModel vs dbtModel+”
Let’s dive into the difference between +dbtModel and dbtModel+ in dbt (data build tool). These two are configurations of model…