Top "Google-bigquery" questions

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

BigQuery - Where can I find the error stream?

I have uploaded a CSV file with 300K rows from GCS to BigQuery, and received the following error: Where can …

google-cloud-platform google-bigquery
Google Bigtable vs BigQuery for storing large number of events

Background We'd like to store our immutable events in a (preferably) managed service. Average size of one event is less …

google-app-engine google-bigquery bigtable google-cloud-bigtable
What are the bigquery keyboard shortcuts?

Google's bigquery editor has keyboard shortcuts. For example ctrl+space composes a new query. I suspect there are more shortcuts, …

google-bigquery
how to rename a table without re creating it

I didn't find a RENAME option to alter table name. I have a case that I must rename a table, …

google-bigquery
How do I cast dd/mm/yyyy string into date in BigQuery?

I have 3 columns 1. dd/mm/yyyy (stored as a string) 2. app_id and #downloads of apps I have to find …

datetime casting google-bigquery string-to-datetime
What does REPEATED field in Google Bigquery mean?

Please check my understanding of REPEATED field in the following examples: { "title": "History of Alphabet", "author": [ { "name": "Larry" }, ] } This JSON …

google-bigquery
SQL array flattening: Why doesn't CROSS JOIN UNNEST join every nested value with every row?

This question isn't about solving a particular problem, it's about understanding what's actually happening behind the scenes in a common …

sql google-bigquery
How to create dummy variable columns for thousands of categories in Google BigQuery?

I have a simple table with 2 columns: UserID and Category, and each UserID can repeat with a few categories, like …

mysql sql google-bigquery dummy-variable
efficient way to compare two tables in bigquery

I am interested in comparing, whether two tables contain the same data. I could do it like this: #standardSQL SELECT …

sql google-bigquery ansi-sql bigquery-standard-sql
How do I use the TABLE_QUERY() function in BigQuery?

A couple of questions about the TABLE_QUERY function: The examples show using table_id in the query string, are …

google-bigquery