26,287 questions
Tooling
0
votes
4
replies
198
views
Replace values in SQL
How can I replace numerical values with NULL in SQL
You’re a junior data analyst working for a local news station and your team uses BigQuery to analyze weather trends. The station’s meteorologist ...
- reputation score 1
Best practices
0
votes
8
replies
158
views
How to replace zero values with NULL in Google BigQuery without syntax errors?
My assignment is:
I am a junior data analyst working with a 2023 weather dataset in Google BigQuery. I need to analyze the relationship between wind speed and visibility. However, the raw data has ...
- reputation score 1
Score of 0
0 answers
47 views
Concurrent Queries with Remote Functions
We're intermittently hitting this error in BigQuery:
Concurrent queries with remote functions limit exceeded
The default quota for this is 10 concurrent queries, but we only have 2 scheduled queries ...
- reputation score 1
Score of 0
1 answer
80 views
How to access BigQuery Infomation_schema Columns from python
I have a Python script that connects to BigQuery, and can pull down data
from google.cloud import bigquery
import os
os.environ['GOOGLE_APPLICATION_CREDENTIALS'] = "XXXXX.json" #file ...
- reputation score 3843
Advice
0
votes
7
replies
97
views
Clarification on JOIN statements SQL
So, I am taking the Google Data Analytics class and I'm learning about using SQL and BigQuery. Some of these examples got me questioning how they work though. Take this for instance, so I know the ...
- reputation score 1
Score of 0
1 answer
57 views
How to access a different project in Google Big Query using Python?
I have been granted access to view a collaborator's Google Big Query project data from the cloud console. I can view the datasets, and the tables, and run SQL commands and view the data in the Google ...
- reputation score 3843
Score of 2
0 answers
124 views
BigQuery Python UDF creation fails with IAM policy size limit only in US and us-central1
I'm hitting a reproducible, region-specific error when creating a BigQuery Python UDF.
Problem
Creating a Python UDF fails in US and us-central1 with:
The number of members in the policy (1,501) is ...
- reputation score 1092
Score of 0
0 answers
68 views
How can I call Gemini 3.1 Flash-Lite from BigQuery ML in the EU? Bare name routes to europe-west4 where it isn't served, and I need EU data residency
What I'm trying to do
Run gemini-3.1-flash-lite as a remote model in BigQuery ML (ML.GENERATE_TEXT / AI.GENERATE) from a dataset in the EU, keeping all processing in the EU for GDPR reasons.
gemini-2....
- reputation score 103
Score of 1
1 answer
45 views
BigQuery Dataset Sharing with external user
I have a bigquery dataset that I am trying to share with an external user. I go to dataset -> share -> manage permissions -> add principal. I add the user ID in the new principal and assign ...
- reputation score 544
Advice
0
votes
4
replies
139
views
Why does my BigQuery query return NULL for AVG() when the column has values?
Problem details:
I'm working with a weather dataset in BigQuery and trying to calculate the average temperature for a specific date range. The temperature column contains numeric values, but my AVG() ...
- reputation score 1
Score of 1
0 answers
92 views
Firebase Firestore BigQuery Export extension is automatically deleted after about one day
I’m using the Firebase Firestore BigQuery Export extension. The extension installs successfully and starts streaming Firestore changes into BigQuery, but after approximately one day it disappears from ...
- reputation score 11
Score of -1
0 answers
129 views
BigQuery MERGE suddenly much slower: higher slot time despite less data processed
I use BigQuery on-demand pricing in location asia-southeast1. Since 2026-06-04, some scheduled MERGE jobs started randomly timing out. Previously the same workload usually completed successfully. Now ...
- reputation score 690
Score of -1
2 answers
372 views
BigQuery refuses to create a gemini-3.5-flash model
I struggle creating a model like
CREATE OR REPLACE MODEL `my-company-project.dvo_ocr_sandbox.dvo_flash_modelxx`
REMOTE WITH CONNECTION DEFAULT
OPTIONS (
endpoint = 'gemini-3.5-flash'
);
while the ...
- reputation score 493
Advice
0
votes
2
replies
46
views
Multiple BigQuery Updates
I have several Python processes that execute complex SQL queries using BigQuery connector.
These queries are executed as one SQL file.
Several processes are executing thin file with different input.
...
- reputation score 81
Best practices
0
votes
2
replies
140
views
Error when replacing 0 values with NULL for weather data analysis
As a data analyst using Google BigQuery to analyze 2023 weather data for a local news station. You're trying to study the relationship between wind, speed and visibility, but the dataset has missing ...
- reputation score 1
