Top "Google-bigquery" questions

Google BigQuery is a Google Cloud Platform product providing serverless queries of petabyte-scale data sets using SQL.

How to use Service Accounts with gsutil, for uploading to CS + BigQuery

How do I upload data to Google BigQuery with gsutil, by using a Service Account I created in the Google …

google-api google-bigquery google-cloud-storage
How to convert stringified array into array in BigQuery?

It so happens I have a stringified array in a field in BigQuery '["a","b","c"]' and I …

google-bigquery
How to convert an array extracted from a json string field to a bigquery Repeated field?

We have loaded json blobs in a String field in a Bigquery table. I need to create a view (using …

google-bigquery
Application name is not set. Call Builder#setApplicationName. error

Application: Connecting to BigQuery using BigQuery APIs for Java Environment: Eclipse, Windows 7 My application was running fine until last night. …

google-bigquery
Can you use field alias with space in Google Big Query

We need to create descriptive aliases for fields. Ideally we would like to create views with alias with a space. …

google-bigquery
What is the difference between NUMERIC and FLOAT in BigQuery?

I read the docs: https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types https://cloud.google.com/bigquery/pricing#data …

sql google-bigquery
BigQuery: Aggregate multiple fields into array

I have some data where for each ID I want to aggregate two or more fields into an array, and …

google-bigquery
percentile functions with GROUPBY in BigQuery

In my CENSUS table, I'd like to group by State, and for each State get the median county population and …

google-bigquery
How to calculate Session and Session duration in Firebase Analytics raw data?

How to calculate Session Duration in Firebase analytics raw data which is linked to BigQuery? I have used the following …

sql firebase google-bigquery tableau-api firebase-analytics
Calculate percentage of group using GROUP BY

I am doing a GROUP BY and COUNT(*) on a dataset, and I would like to calculate the percentage of …

google-bigquery