Top "Google-bigquery" questions

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

How do I identify the Google Cloud Storage URI from my Google Developers Console?

When I attempt load data into BigQuery from Google Cloud Storage it asks for the Google Cloud Storage URI (gs://). …

google-cloud-platform google-bigquery google-cloud-storage
difference in minutes between 2 bigquery timestamp fields

How can I get the difference in minutes between 2 timestamp fields in google bigquery? The only function I know is …

google-bigquery
BigQuery: convert epoch to TIMESTAMP

I'm trying to range-join two tables, like so SELECT * FROM main_table h INNER JOIN test.delay_pairs d ON …

google-bigquery
WITH in BigQuery

Does BigQuery support the WITH clause? I don't like formatting too many subqueries. For example: WITH alias_1 AS (SELECT foo1 …

sql google-bigquery common-table-expression
Converting JSON into newline delimited JSON in Python

My goal is to convert JSON file into a format that can uploaded from Cloud Storage into BigQuery (as described …

python json google-cloud-platform google-bigquery
BigQuery - Export query results to local file/Google storage

I want to export query results from BigQuery to local file/Google storage. I tried 'bq extract' command but it …

google-bigquery google-cloud-storage
How to calculate median of a numeric sequence in Google BigQuery efficiently?

I need to calculate median value of a numeric sequence in Google BigQuery efficiently. Is the same possible?

google-bigquery median
google-bigquery format date as mm/dd/yyyy in query results

I am using Bigquery SQL to generate a report. The standard Bigquery date format is yyyy-mm-dd, but I want it …

sql date format google-bigquery
BigQuery - select top N posts from a large table for each subreddit

I am doing data mining on Reddit data on Google BigQuery and I wanna top 1000 posts ranked by the score …

sql google-bigquery reddit
Transpose rows into columns in BigQuery (Pivot implementation)

I want to generate a new table and place all key value pairs with keys as column names and values …

sql google-bigquery google-cloud-platform