Questions tagged [google-bigquery]
Google BigQuery is a Google Cloud Platform product providing serverless queries of petabyte-scale data sets using SQL. BigQuery provides multiple read-write pipelines, and enables data analytics that transform how businesses analyze data.
google-bigquery
26,204
questions
0
votes
1
answer
16
views
Huge Discrepancy in Total Users Between BigQuery and GA4
I'm experiencing a significant discrepancy in the total user count between BigQuery and GA4. I'm using Shopify and Elevar for server-side tracking. Over one week, there is a 15% discrepancy, and over ...
- 482
0
votes
0
answers
12
views
how to turn Bigquery "session mode" on from within local VS Code?
Anyone know how to turn Bigquery "session mode" on from within local VS Code? By the way, I need to create temp table, which needs the session mode to be on.
- 99
0
votes
0
answers
36
views
Complex BigQuery recursive CTE use case that joins on non-unique key and also unions at the same time
I have a complex (but highly interesting!) use case for BigQuery recursive CTE. I understand how to solve it conceptually but after hours of trying, I just can't get my head around exactly how to do ...
- 111
0
votes
0
answers
23
views
problem connecting to Google Big Query from AWS Glue job
As title says, I have a problem connecting to Google Big Query from AWS Glue job. Idea is that I pick up data from database and send it to google big query.
My script looks like this:
import os
import ...
- 690
0
votes
0
answers
10
views
How does GCP Logs Router handle conflicting rules?
I created separate Log routing sinks to capture specific logs for various services being used. All of these sinks wrote to the same dataset.
For example, the various inclusion filters looked similar ...
- 31
0
votes
1
answer
22
views
How can I rank after filtering inside a window function?
I have a huge BigQuery table "taskperformance" that attributes tasks to sales (ordered in this example for easier
understanding):
sale_id
sale_timestamp
task_id
task_timestamp
is_same_store
...
- 12.7k
-3
votes
0
answers
14
views
Not able to run query in big query [closed]
i don't understand what's my mistake here.this is the image of my query pls refer this and help me where am I getting stuck
I am learning big query but every time i run a query this error pops up I ...
0
votes
0
answers
16
views
Big query data discrepancy
I created two views
365 days
1 Year
If I run same query on both views, I see difference in results for same month.
For example, If I see June of 2023 from the 365 days view and the 1 year view. They ...
- 21
-4
votes
0
answers
23
views
Why is "There is no data to display" in a SQL query? [closed]
I use a subquery in a FROM statement: use the citibike_trips table to calculate the total number of rides started at each station that returns column: number_of_rides_starting_at_station along with ...
0
votes
1
answer
47
views
How to self reference a calculated column in SQL (BigQuery)
I have a table like shown below:
row_number
usd
cad
1
10
13
2
15
18
3
-5
null
4
2
8
5
-11
null
I'm trying to write a SQL query in BigQuery to create a new_cad column that has the following ...
- 73
0
votes
0
answers
22
views
Apache Superset Google BigQuery extended image error
I want to install Google Big Query Database Driver into my Superset configuration.
I use official documentation
I tried using this tip but it did not work.
Steps I do:
git clone https://github.com/...
0
votes
1
answer
28
views
How would I concisely provide a lookup value for multiple different fields within BigQuery SQL?
I have a requirement to translate a PostgreSQL UDF into BigQuery. This UDF takes a simple STRING input and outputs a resulting lookup value from another table. (PostgreSQL formatting applied for UDF ...
- 95
0
votes
2
answers
30
views
Unexpected end of script running Big Query
I am getting the syntax error "unexpected end of script at 13:4" when I try to run the first part of my Big Query.
Please see query below.
WITH
longest_used_bike as (
SELECT
...
- 11
0
votes
1
answer
40
views
Google Analytics's Custom Dimension Shows NULL Value in BigQuery
I have Google Analytics UA linked to BigQuery and I see there are lots of generated data having NULL value in a specific custom dimension.
I was trying to understand under what circumstance this could ...
- 37
0
votes
1
answer
24
views
How do I get a date that is a number of business days after a certain date in Big Query using SQL?
I made a CTE where I have a date table joined with a holidays table so that I can mark business days (days that are not weekends nor holidays) like this:
dateholidays AS (
SELECT
datetable....
- 1