We recently re-started our license to GA360, having had it 3 years ago. The old dataset which the old export sent data to is in the project where we created the
I would like to know how to calculate the total bytes which were processed by query jobs in a specified period per reference table to reduce BigQuery costs. I c
I'm very new to Google Cloud CLI, sorry for the dumb question but it's really annoying. I'm trying to execute this command: bq mk --transfer_config --target_dat
I have the total amount expected to be saved, the total amount saved, the principal amount expected to be saved and the principal amount saved, now I'm trying t
I have this table: I'm looking for this table: I have searched for array functions (array_agg) and it didn't work as expected. How can I approach this task? W
I have this table: I'm looking for this table: I have searched for array functions (array_agg) and it didn't work as expected. How can I approach this task? W
The Docs for the BigQuery BI Engine say "BI Engine is supported in the same regions as BigQuery" (https://cloud.google.com/bigquery/docs/bi-engine-intro). Also
We are using the BigQuery Data Transfer Service that is based on the AdWords API, but we're missing some of the campaigns. If we write a custom transfer for Goo
Recently I started to work on BigQuery and there's something that makes me still confused. What's the alternative for this query on Big Query? select a.abc, c.x
I am attempting to join two tables to create a visualization that shows the relationship between weight, BMI, and total steps using the following code: SELECT
I am trying to add a service account key file to access a bigquery data set in power bi. I am selecting service account login during the set up process. I added
I have following table. I need to transform this input as you can see in below output example: If you have any ideas please share. Thank you
When using BigQueryInsertJobOperator and setting the configuration to perform a dry run on a faulty .sql file/ a hardcoded query, the task succeeds even though
I have a table like below: I want to sort the port and value and then apply lead function on eventDateTime like below: I'm able to sort the port and value tog
I'm diving into metadata available on datasets and tables in BigQuery. There is enough documentation on INFORMATION_SCHEMA:https://cloud.google.com/bigquery/doc
I want to do a BQ query via the bq command. Here is my command: bq query --application_default_credential_file $GOOGLE_APPLICATION_CREDENTIALS --nouse_
I am new to BQ and experienced in OLTP RDBMS, I found the data in BQ for my company are mostly in STRING type while it was VARCHAR(255) or even less in the OLTP
I currently have a JSON array that looks like this in Big Query: [{"name":"","username":null},{"name":"Jimmy Dean","username":"iamjc"},{"name":"Ben Simmons","us
I've been struggling for a while to get a query to return the number of sessions and users per source/campaign/medium/content, based on the current session of t
I am running the following cloud function. It runs with success and indicates data was loaded to the table. But when I query the BigQuery no data has been added