Getting below error while connecting Simba driver with BigQuery on OBIEE UNIX Env , any suggesting's. Do we have some license file associated with the driver. U
I am following this guide in setting up a vertex AI pipeline. I am told to supply the "BigQuery project for exporting data", except that the guide is not clear
I'm trying to get the total duration of membership types (member&casual) another application of the same problem would be to get the total count of the popu
I have two date formats 2020-01-02T10:26:47.056-04:00 and January 2, 2020, 10:10 AM that I need to transform into a comparable date format to make a subtraction
I'm working with Cloud Function. I have the following query working correctly: # this is working q = """ SELECT col1, col2 FROM `my_table` WHER
I initially extracted the weeks from a date as 1, 2, 3 using the extract clause but now, I want to have the year along with it as week1, 2022 or week 40, 2021
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