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
1
vote
0answers
23 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
38 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
896 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
364 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 ...