Start here in GCP
The most useful guides in this topic, not just the most recent.
GCP Guides & Tutorials
Google Cloud for data — BigQuery, Dataflow, Pub/Sub, Vertex AI, Cloud Storage and the Professional Data Engineer path.
GCP articles
Partitioning and Clustering in BigQuery
Partitioning splits a BigQuery table into segments that a query can skip; clustering sorts the storage blocks inside them. This guide explains both, measures the effect with a model on 2.9 million real trip rows, shows why clustering column order matters, and lists the filters that quietly stop pruning.
GCP IAM Explained: Roles, Policies and Security
Google Cloud IAM answers one question, who can do what on which resource, with three parts: a principal, a role and a resource. This guide explains each, shows how access is inherited down the hierarchy and how deny policies override it, with a worked model on BigQuery roles, and sets out least-privilege practice.
Building a Data Pipeline on GCP End to End
A pipeline is more than a load command. This guide builds a daily batch pipeline on Google Cloud in five stages, land, load, clean, check and publish, names the service for each, and runs the flow locally on real data to show a rerun that changes nothing and a truncated delivery that is held back, not published.
BigQuery Cost Optimization: Slots, Pricing and Tips
A BigQuery bill has two parts, compute and storage, and nearly all the surprises are in compute. This guide explains both pricing models, prices three query shapes on a real table, gives the break-even between on-demand and slots, and lists the limits that stop one bad query becoming an expensive one.
Cloud Functions on GCP: Serverless Explained
A function is a few lines of code that run when something happens, with no server to manage. Google Cloud's version, Cloud Functions, is now called Cloud Run functions. This guide explains the two kinds of function, runs a storage-triggered one locally with Google's framework, and covers triggers, retries and limits.
BigQuery vs Snowflake vs Redshift: A Comparison
BigQuery, Snowflake and Amazon Redshift all separate storage from compute and all speak SQL. They differ in what you manage, what you are billed for and which levers you tune. This comparison is drawn from each vendor's documentation, with a model of how idle time drives the bill on time-based compute.