Articles by Tag #bigquery
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
Observability in Action: A Google Cloud Next demo
Quick run-down of one of the interactive demos that was presented at Next 2025, from the architecture to the products and features showcased.
Google Sheets x BigQuery Sync using Google Apps Script
If you haven't discovered Google Apps Script yet (ahem, me a week ago) then you are seriously missing...
Day 13 : Understanding Google Cloud Billing API & BigQuery Exports
The Google Cloud Billing API programmatically accesses your cloud billing data. It lets you retrieve...
Building a Legal Document Intelligence Platform with BigQuery AI: 99% Efficiency Implementation Guide
Building a Legal Document Intelligence Platform with BigQuery AI: 99% Efficiency...
BigQuery: query and table optimization to save some money
What is BigQuery? BigQuery belongs to the Google Cloud Platform suite and it is one of the...
Mastering Big Data with GCP: My Capstone Journey in Cloud Data Analysis
Introduction As a data enthusiast, I’ve always been fascinated by the power of cloud...
Streamline data transfer: The ultimate data integration guide SFTP to BigQuery
Link to original article written by Mage DevRel, Cole Freeman:...
BigQuery's Capacity-Based Compute Pricing Model Explained
TL;DR BigQuery has two pricing models: On-demand, charging per byte processed, and...
Study Note DE Zoomcamp 3.1.1 - Data Warehouse and BigQuery
Introduction This lecture covers data warehouses, with a focus on BigQuery. Topics...
BigQuery Legacy SQL vs Standard SQL
No Google BigQuery, existem dois dialetos de SQL disponíveis para consulta de dados: Legacy SQL e...
Study Notes 2.2.7: Managing Schedules and Backfills with BigQuery in Kestra
Overview This study note covers the details from the video "DE Zoomcamp 2.2.7 - Manage...
Taxi Drivers Efficiency Analysis with SQL & Tableau
I recently completed a hands-on SQL project using the Chicago Taxi Trips dataset on BigQuery, where I...
Data Synchronization from Google BigQuery to ClickHouse in an AWS Air-Gapped Environment
Understanding the Key Components Airgap Environment An airgapped environment enforces strict...
BigQuery SQL
Aqui está uma coleção de consultas avançadas em SQL, incluindo técnicas poderosas como funções de...
구글 빅쿼리 @run_date 함수에 관하여
구글 빅쿼리에는 @run_date라는 함수가 있는데 이 함수를 이용하면 쿼리를 실행할 때 데이터 집계 기준 시간을 쿼리 실행시각으로 자동 설정할 수 있다. 단, 어디까지나 구글...
Study Notes 3.3.1: BigQuery Machine Learning (BQML)
Overview & Key Benefits Target Audience: Data analysts and managers No Python/Java...
Study Note 3.2.1: BigQuery Best Practices
Cost Reduction Strategies Column Selection Avoid using SELECT * Always specify required...
Study Notes 3.2.2: BigQuery Internal Architecture
Core Components 1. Storage (Colossus) Uses columnar storage format Separated...
What Is Change Data Capture (CDC) and How It Works on Google Cloud
Keeping analytics pipelines real‑time and resource‑efficient is table stakes in 2025. That’s where...
Study Notes 3.1.2: Partitioning and Clustering in BigQuery
1. Introduction Partitioning and clustering are key optimization techniques in Google...
Why do AWS dashboards keep breaking — and is there a better way?
We’ve been running dashboards on AWS — mainly using Redshift with Power BI — and honestly, it's been...
Study Notes 5.6.3-4 Setting up a Dataproc Cluster & Connecting Spark to Big Query
Study Notes 5.6.3 - Setting Up a Dataproc Cluster in GCP 1. Introduction GCloud...
BigQuery
BigQuery é um serviço de análise de dados altamente escalável e rápido fornecido pela Google Cloud....
Peer Review 2: Data Warehousing, Transformation, and Reproducibility in tfl-data-visualization (Part 2)
Welcome to the second part of my peer review series of the tfl-data-visualization project—a...
📊 Explorando tu facturación en Google Cloud con BigQuery (de forma sencilla)
¿Quieres tener visibilidad clara sobre en qué se va tu presupuesto en Google Cloud? Con BigQuery...
Top 5 self-service BI solutions for BigQuery
What is Google BigQuery? Google BigQuery is a cloud service for processing large datasets,...
BigQuery’s Ridiculous Pricing Model Cost Us $10,000 in Just 22 Seconds!
Yes, you read that right. $10,000 burned in less than half a minute. Not because of inefficient...
Google Cloud, new APIs in your existing BigQuery projects | Quick Update
Google Cloud Update We’re writing to remind you that we are adding additional services to...
How to connect multiple data tools into a unified customer journey dashboard?
Hey dev/data folks I’m working on a project where we need to visualize the entire customer journey —...
Chapter 5: The Unified Data Blueprint – Architecting Your Data Warehouse
Ever feel like your business is drowning in data but starving for wisdom? 🤔 You're not alone! Making...