Tag: google_cloud
Window functions in Google BigQuery: Analyzing data over specific intervals
Window functions, often termed as analytical or OLAP (Online Analytical Processing) functions, allow users to perform calculations across a set…
Advanced string Manipulation Techniques in Google BigQuery : Techniques for splitting and concatenating strings : Crafting the perfect string
Strings are one of the most commonly used data types, representing sequences of characters. Whether it’s textual data or encoded…
Working with Structs in Google BigQuery : Encapsulate multiple fields, possibly of different data types
The STRUCT data type in Google BigQuery enables you to encapsulate multiple fields, possibly of different data types, into one…
Array handling in Google BigQuery: Storing, Querying, and Unnesting
In Google BigQuery, an array is a homogenous collection of elements, allowing for more complex data storage and operations. An…
Handling null values in Google Bigquery: Best practices for data cleaning
1. Overview of NULL in Databases In the realm of databases, the term “NULL” represents the absence of any specific…
Navigating date arithmetic in Google BigQuery : Subtracting days from a date column
In data analysis, sometimes you may need to perform arithmetic on date columns, such as subtracting a number of days…
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…
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,…
