26,332 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
3
votes
1
answer
79
views
Filtering dataset by geolocation data using SQL in BigQuery
I trying to determine if NCAA basketball games have an affect on liquor sales in the surrounding areas around the stadiums where the teams play their games. I am writing a query that filters and sorts ...
0
votes
0
answers
15
views
Airflow BigQueryInsertJobOperator and job re-attachment
The inciting problem
One of our DAGs suffers from an issue wherein a BigQueryInsertJobOperator task fails due to it becoming a "zombie task" (from Airflow's perspective); in the "Event ...
Best practices
0
votes
6
replies
79
views
How can I best optimize a Bigquery SQL by appending completely redundant filters to the query?
I have two different SQL calls to BigQuery. One completes in 22 seconds, the other is identical except that I add completely redundant filter at the end. This second completes in 8 seconds. The ...
0
votes
0
answers
69
views
GA4 BigQuery Daily Export Missing Data After Specific Date
I have a GA4 property linked to BigQuery for daily export (both iOS and Web data streams selected, "export all events" enabled, no filters).
Everything was working fine until 2025年11月23日, when the ...
-1
votes
0
answers
113
views
Facing issue in Big Query while extracting JSON Value
We are leveraging BigQuery to create reports, with some column values represented in JSON. Below is a sample payload. I can successfully retrieve the Template value, but the objectType value remains ...
Tooling
1
vote
2
replies
60
views
Windows Shortcut
What shortcuts can I use to split strings in my database (BigQuery). I have been trying a lot of functions and I make use of the google bigquery platform. I'm getting really confused now. I tried ...
0
votes
1
answer
110
views
Optional nanoseconds when using `timestamp_format` in BigQuery Load Jobs?
I'm loading data into BigQuery and using LoadJobConfig. There's a timestamp_format field where you can specify the format of timestamps.
Checking the data I have, timestamps come in different format:
...
0
votes
0
answers
66
views
"Was expecting: <EOF>" when using BigQuery
I am trying to use BigQuery and want to search from the Google Cloud SDK Shell.
I logged in and set up with gcloud config init successfully.
I used the BigQuery console to put data in my dataset table....
0
votes
0
answers
70
views
How to achieve dynamic partition pruning in BigQuery TVF using a subquery lookup?
I have a Table Valued Function (TVF) that takes an array of IDs as input.
source_table: A very large table (TBs) partitioned by day on capturedTimestamp.
selection_table: A small lookup table that ...
Tooling
0
votes
3
replies
58
views
How to enforce dynamic partition pruning in BigQuery TVF using a subquery lookup?
I have a table-valued function (TVF) that takes an array of IDs as input.
source_table: a very large table (TBs) partitioned by day on capturedTimestamp
selection_table: a small lookup table that ...
Tooling
0
votes
0
replies
40
views
BigQuery Data Transfer: Load CSV Files Using Column Headers
I’m setting up a BigQuery Data Transfer for daily CSV files.
Because the column order in these files can vary from day to day,
I’d like BigQuery to use the CSV headers to map the data to the correct ...
0
votes
0
answers
73
views
BigQuery data is not inserted in tables
I'm having random data missing/not showing up in BigQuery issues. I would seemingly write data without issues, but SELECT * would return nothing.
The control panel shows no errors. None of the quotas ...
0
votes
1
answer
99
views
Calculate percent of total per firm and filter firms above 50%
I'm trying to calculate the percentage contribution of each firm to the total amount across all firms.
Database:
google-bigquery
What I need (desired output):
Sum usde_haircut_amt per firm
Compute ...
0
votes
0
answers
85
views
Can I send a JSON object to BigQuery without stringifying it?
I am trying to figure out if there is a way to send a JSON object to a BigQuery table that has a column of type JSON. I know the current practice is to stringify the JSON and send it over which gets ...
-7
votes
1
answer
74
views
BigQuery: How to replace 0 values with NULL in a column? [closed]
I’m trying to clean a BigQuery weather dataset where missing values were entered as 0. My UPDATE query to replace 0 with NULL is throwing an error. How can I correctly convert these zeroes to null ...