Time travel – BigQuery
Vishal Jadhav Table of Contents Toggle what is time travel in bigquery? Big query time travel – query for extracting data for last 24 hour. what is time travel in bigquery? Using…
data-engineering
What is a federated query in BigQuery?
Federated queries are used to query the data on external sources like Cloud Storage, BigTable, CloudSql, Spreadsheet in google Drive. Federated queries or have queries that access data that isn’t…
Understanding and Mitigating Hotspotting in Google Cloud Spanner
Learn how to prevent and mitigate hotspotting in Google Cloud Spanner to maintain optimal performance and scalability. This guide covers causes, signs, and strategies including schema design, query optimization, sharding,…
Short and wide tables in Google Cloud Bigtable.
Certainly! Let’s explore the difference between short and wide tables in Google Cloud Bigtable. In summary, short tables are best for single-keyed data with low latency, while wide tables excel…
Google Bigtable: Tall Tables vs Narrow Tables Explained
Bigtable is a NoSQL database service provided by Google Cloud Platform (GCP), designed to handle massive-scale, high-throughput workloads. While it’s commonly associated with storing and processing large amounts of data,…
GCP Dataflow – Apache beam
Most important concept In the context of data stream processing and windowing, these terms—tumbling windows, hopping windows, session windows, and global windows—describe different ways to group and analyze continuous streams…
Comprehensive Guide to Windowing Functions in Data Stream Processing: Tumbling, Hopping, Sliding, Session, and Global Windows Explained
windowing in stream processing
The Problem with Too Many Partitions in Databases and Storage Systems
Having too many partitions in a system, especially in a data storage context like a database or a distributed file system, can lead to several issues.Here’s a breakdown of the…
GCP IAM (identity access management)
who can do what on which resource who (identity) – its user (userid or email-id) what(action) – create, update, delete which(resources)- cloud storage, bigquery. in simple word user/employee(who) having given…
Google Cloud Storage Buckets – Complete Guide to All GCP Bucket Topics
following are the most important topics for the gcp bucket which is really helpful in real life as well as gcp exam perspective Bucket object Storage classes