Tag: gcp
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,…
Understanding Data Encryption in Google Dataflow
Google Dataflow is designed to ensure data is encrypted both at rest and in transit. Here’s a brief overview of…
Bigquery : Allows BigQuery to return query results much faster
Understanding Google Cloud BigQuery Storage API v2.10.0: A Comprehensive Guide Google Cloud BigQuery is a fast, scalable, and cost-effective multi-cloud…
GCP : The user account authentication flow no longer works as of Febuary 1, 2023.
Since the user account authentication flow has changed, you should go ahead with the Cloud SDK installation to authenticate and…
BigQuery : How do you set up and manage user access to BigQuery ? Step by Step explanation
BigQuery provides several ways to manage user access to its resources, including projects, datasets, and tables. Here’s an overview of…