Google BigQuery is a Google Cloud Platform product providing serverless queries of petabyte-scale data sets using SQL.
In June the BQ team announced support for date-partitioned tables. But the guide is missing how to migrate old non-partitioned …
google-bigqueryIm trying to play with the reddit data on bigquery and I want to see comments and replies in one …
sql subquery google-bigquery reddit bigdataI want to get the maximum value of 2 Integer (or 2 float). I know I can do it with a IF …
google-bigqueryI need to import Pubsub_v1 and bigquery from google.cloud module. I have installed it and pip freeze shows …
python google-bigquery google-cloud-pubsubIn the gcloud documentation for google bigquery, it states that authentication can be determined from from_service_account_json. I've …
python json authentication google-bigquery google-cloud-pythonI have around 108 tables in a dataset. I am trying to extract all those tables using the following bash script: # …
google-cloud-platform google-bigquery gcloud-cliI need to add row numbers to a large (ca. billion rows) dataset in BigQuery. When I try: SELECT * ROW_…
google-bigquery row-number large-dataI have a simple query to obtain the currency rate in use at the time a transaction was created: SELECT …
google-bigqueryI have a .sh file that is stored in GCS. I am trying to schedule the .sh file through google …
shell cron google-cloud-platform google-bigquery google-cloud-shellIs it possible to count number of occurrences of a specific log message over a specific period of time from …
google-cloud-platform google-bigquery stackdriver google-cloud-console