---
title: "#bigquery articles | Hashnode"
description: "Explore 171 articles tagged #bigquery on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/bigquery"
---

Tag

# #bigquery

171 posts · 52 followers

[Biz tech pulse hub](https://hashnode.com/@biztechpulsehub) · [2d ago](https://hashnode.com/posts/bigquery-cross-cloud-caching-how-to-improve-query-performance-and-reduce-data-transfers/6afb4ea8274706781d88ec3a)

### [BigQuery Cross-Cloud Caching: How to Improve Query Performance and Reduce Data Transfers](https://biztechpulsehub.hashnode.dev/bigquery-cross-cloud-caching-how-to-improve-query-performance-and-reduce-data-transfers?utm_source=hashnode&utm_medium=feed)

Explore how Google Cloud's Lakehouse caching helps data teams reuse remote file data, optimize cross-cloud analytics, and monitor query performance.

4 min read · [biztechpulsehub.hashnode.dev](https://biztechpulsehub.hashnode.dev/bigquery-cross-cloud-caching-how-to-improve-query-performance-and-reduce-data-transfers?utm_source=hashnode&utm_medium=feed)

[Shijith Pulikkal](https://hashnode.com/@shijithpulikkal) · [3d ago](https://hashnode.com/posts/pulling-posthog-data-into-looker-studio-with-bigquery/6af990fc1d5222494f0b7eed)

### [Pulling PostHog Data into Looker Studio with BigQuery](https://xtractstudio.hashnode.dev/pulling-posthog-data-into-looker-studio-with-bigquery?utm_source=hashnode&utm_medium=feed)

What failed, what worked, and the SQL views behind a full web analytics dashboard

11 min read · [xtractstudio.hashnode.dev](https://xtractstudio.hashnode.dev/pulling-posthog-data-into-looker-studio-with-bigquery?utm_source=hashnode&utm_medium=feed)

[Shijith Pulikkal](https://hashnode.com/@shijithpulikkal) · [3d ago](https://hashnode.com/posts/how-a-base44-app-quietly-ran-up-a-130-bigquery-bill/6af9883a2ca1cca13d27dcdc)

### [How a Base44 App Quietly Ran Up a $130 BigQuery Bill](https://xtractstudio.hashnode.dev/how-a-base44-app-quietly-ran-up-a-130-bigquery-bill?utm_source=hashnode&utm_medium=feed)

The region clue, the shared-view trap and the summary-table fix: a step-by-step investigation you can reuse on your own surprise bill.

13 min read · [xtractstudio.hashnode.dev](https://xtractstudio.hashnode.dev/how-a-base44-app-quietly-ran-up-a-130-bigquery-bill?utm_source=hashnode&utm_medium=feed)

[Shijith Pulikkal](https://hashnode.com/@shijithpulikkal) · [3d ago](https://hashnode.com/posts/building-a-google-ads-bigquery-combined-view-that-matches-the-native-connector/6af98218515d8661efba84d0)

### [Building a Google Ads BigQuery Combined View That Matches the Native Connector](https://xtractstudio.hashnode.dev/building-a-google-ads-bigquery-combined-view-that-matches-the-native-connector?utm_source=hashnode&utm_medium=feed)

Five pitfalls in the Data Transfer tables, and the SQL and Looker Studio formulas that fix them

10 min read · [xtractstudio.hashnode.dev](https://xtractstudio.hashnode.dev/building-a-google-ads-bigquery-combined-view-that-matches-the-native-connector?utm_source=hashnode&utm_medium=feed)

[Shijith Pulikkal](https://hashnode.com/@shijithpulikkal) · [5d ago](https://hashnode.com/posts/how-we-pipe-doordash-ads-api-data-into-bigquery-for-looker-studio-and-base44/6af746742fe2f39f7e8c8fdc)

### [How We Pipe DoorDash Ads API Data into BigQuery for Looker Studio and Base44](https://xtractstudio.hashnode.dev/how-we-pipe-doordash-ads-api-data-into-bigquery-for-looker-studio-and-base44?utm_source=hashnode&utm_medium=feed)

From async report downloads to dashboards: a production-ready retail media pipeline on Google Cloud

9 min read · [xtractstudio.hashnode.dev](https://xtractstudio.hashnode.dev/how-we-pipe-doordash-ads-api-data-into-bigquery-for-looker-studio-and-base44?utm_source=hashnode&utm_medium=feed)

[Shijith Pulikkal](https://hashnode.com/@shijithpulikkal) · [5d ago](https://hashnode.com/posts/from-kroger-ad-platform-api-to-bigquery-looker-studio-and-base44-app/6af6c14ef897327563d8127f)

### [From Kroger Ad Platform API to BigQuery, Looker Studio and Base44 App](https://xtractstudio.hashnode.dev/from-kroger-ad-platform-api-to-bigquery-looker-studio-and-base44-app?utm_source=hashnode&utm_medium=feed)

How I automated daily Product Listing Ad reporting with Cloud Run and BigQuery, hit an intermittent CDN block, and turned the data into dashboards and an app.

12 min read · [xtractstudio.hashnode.dev](https://xtractstudio.hashnode.dev/from-kroger-ad-platform-api-to-bigquery-looker-studio-and-base44-app?utm_source=hashnode&utm_medium=feed)

[Shijith Pulikkal](https://hashnode.com/@shijithpulikkal) · [5d ago](https://hashnode.com/posts/instacart-ads-api-to-bigquery-powering-looker-studio-dashboards-and-a-base44-app/6af72e5106c0f663a73a9aec)

### [Instacart Ads API to BigQuery: Powering Looker Studio Dashboards and a Base44 App](https://xtractstudio.hashnode.dev/instacart-ads-api-to-bigquery-powering-looker-studio-dashboards-and-a-base44-app?utm_source=hashnode&utm_medium=feed)

Pull Instacart Ads API reports into BigQuery with Cloud Run, then power Looker Studio dashboards and a Base44 app. OAuth, backfills, gotchas.

9 min read · [xtractstudio.hashnode.dev](https://xtractstudio.hashnode.dev/instacart-ads-api-to-bigquery-powering-looker-studio-dashboards-and-a-base44-app?utm_source=hashnode&utm_medium=feed)

[Shijith Pulikkal](https://hashnode.com/@shijithpulikkal) · [5d ago](https://hashnode.com/posts/same-question-four-platforms-sql-vs-bigquery-vs-python-vs-dax/6af74e3e6ab1805611344864)

### [Same Question, Four Platforms: SQL vs BigQuery vs Python vs DAX](https://xtractstudio.hashnode.dev/same-question-four-platforms-sql-vs-bigquery-vs-python-vs-dax?utm_source=hashnode&utm_medium=feed)

I solved 13 real-world analytics problems in MS SQL, BigQuery, Python (Pandas) and Power BI DAX, and learned that each engine thinks differently.

6 min read · [xtractstudio.hashnode.dev](https://xtractstudio.hashnode.dev/same-question-four-platforms-sql-vs-bigquery-vs-python-vs-dax?utm_source=hashnode&utm_medium=feed)

[Sid Mishra](https://hashnode.com/@sid-mishra) · [5d ago](https://hashnode.com/posts/crawl-website-to-bigquery-snowflake/6af69d3e38aeea8b79a3526c)

### [Crawl a website into BigQuery or Snowflake on a schedule](https://sidmishra.hashnode.dev/crawl-website-to-bigquery-snowflake?utm_source=hashnode&utm_medium=feed)

A scheduled crawler that MERGEs pages into BigQuery or Snowflake, loads only what changed, and never treats a blocked page as deleted.

10 min read · [sidmishra.hashnode.dev](https://sidmishra.hashnode.dev/crawl-website-to-bigquery-snowflake?utm_source=hashnode&utm_medium=feed)

[Shubham Baldava](https://hashnode.com/@shubham-olake) · [Nov 11](https://hashnode.com/posts/postgres-to-bigquery-cdc-on-biglake-where-the-setup-stops-and-the-exact-messages/6af4d0ad6be71b286f164931)

### [Postgres to BigQuery CDC on BigLake: Where the Setup Stops, and the Exact Messages](https://olake-blog.hashnode.dev/postgres-to-bigquery-cdc-on-biglake-where-the-setup-stops-and-the-exact-messages?utm_source=hashnode&utm_medium=feed)

Slot, service account, catalog, first query and change sync, with the message each stop returns and what clears it.

10 min read · [olake-blog.hashnode.dev](https://olake-blog.hashnode.dev/postgres-to-bigquery-cdc-on-biglake-where-the-setup-stops-and-the-exact-messages?utm_source=hashnode&utm_medium=feed)
