I am trying to use analytical functions (e.g. FIRST_VALUE), while still benefiting from from partition pruning. This while the table is partitioned on a DATETIM
Is there anyway to avoid formatting the comments? To reproduce, paste below example SQL code to BQ: --important comment on table info select * from mytable1;
I'm trying to run the following query but it keeps throwing this error after it keeps running for around 1 to 2 hours An internal error occurred and the reques
I want to use unnest in the following function to use INkeyword but it is throwing error unexpected keyword UNNEST while using unnest. CREATE TEMPORARY FUNCT
I want upload JSON data which is in the below form {a:[1,2,3]}, into BigQuery, I am familiar Record Field-Type with repeat Mode. I am getting error Array spe
Is there a way I can match SAS logistic regression results with BigQuery ML logistic regression results (coefficient / intercept values for same data)?
I am using Firebase as my authentication and database platform in my React Native-Expo app. I have not yet decided if I will be using the realtime-database or F
I am trying to load some CSV files into BigQuery from Google Cloud Storage and wrestling with schema generation. There is an auto-generate option but it is poor
Hello im currently trying to establish daily data transfers from Google Cloud Storage to Big Query tables. Theses tables are just meant to store raw data (JSON
I'm using the Google BigQuery and looking on the default audit dataset. I know that this dataset contains various data about the queries the users are running.
Across project level when trying to Copying the tables in big query, it works fine using bq CLI but not from Console. Big Query --> Project:Dataset.tableXYZ
I run daily commands to insert new records into a BigQuery table, and would like to log how many records get inserted each day. I create a QueryJob object that
I want to input string data into bigquery by implied by pyhton's zlib library. Here is an example code that uses zlib to generate data: import zlib import p
I have a table that records all the different statuses for a list of Jobs with timestamps. So the ID column has many Ids that appear several times as their stat
Hi All trying to figure out a way to transpose data in columns dynamically. In the data the distinct number of Traits will increase/decrease. I know I can hardc
I am trying to save the results of a BigQuery query to a Panda DataFrame using bigquery.Client.query.to_dataframe() This query can return millions of rows. Gi
I am building an application/script for users that do not have write access to the database. Normally I would use Execute Immediate and save that result into a
I'm trying to use BigQuery ML to load a saved tensorflow model to make predictions. However when I run the query that read the saved model in GCS I got the foll
My table has two columns, id and a. Column id contains a number, column a contains an array of strings. I want to count the number of unique id for a given arra
I'm trying to develop a query against Firebase Analytics data linked to BigQuery to reproduce the "Daily user engagement" graph from the Firebase Analytics dash