Author: user
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,…
Getting total number of elements in a NumPy array using Python NumPy’s np.ndarray.size
In NumPy, np.ndarray.size is an attribute that provides information about the total number of elements in a NumPy array. It…
Dividing an array vertically along rows, creating multiple smaller arrays using NumPy’s np.vsplit
np.vsplit is one such function that allows you to divide an array vertically along rows, creating multiple smaller arrays. It…
