Questions tagged [google-bigquery]

BigQuery is Google's fully managed, scalable, serverless data warehouse. With BigQuery, you get a columnar and ANSI SQL database that can analyze petabytes of data in seconds.

Filter by
Sorted by
Tagged with
3
votes
2answers
77 views

Keeping only maximum date rows in a group

The following SQL code keeps only the MAX(date) rows with the same id and question values. I would like to know if there is a simpler/ shorter syntax returning the same result. ...
1
vote
0answers
29 views

Custom Google Data Studio connector

I am using Google BigQuery API V2 for a custom Google Data Studio connector. The BigQuery.Jobs.query() calls take roughly 50 seconds which is too long, so I am ...
2
votes
0answers
41 views

SQL query that extracts a topic keyword from article titles

I have a query like this to select the only row with title contains specific programming topics. ...
3
votes
1answer
954 views

Insert an SQL Server Table rows into a Bigquery table in one bloc

I want to insert all rows of an SQL server Table into a BigQuery Table having the same schema. The streaming insert row by row is very slow: to insert 1000 rows the execution of the code below took ...
2
votes
0answers
367 views

Insert all SQL Server table rows in a Google BigQuery Table

I want to know the best way (best performance and reaction time) to insert all rows of an SQL table into a Google BigQuery table. Actually, I am looping over a query result and insert the rows one by ...