Questions tagged [google-bigquery]

BigQuery is Google Cloud's fully managed, petabyte-scale, and cost-effective analytics data warehouse that allows to run analytics over vast amounts of data in near real time

Filter by
Sorted by
Tagged with
0 votes
0 answers
6 views

Getting Bigquery resources exceeded error in LookerML

we are getting the "Resources exceeded during query execution: The query could not be executed in the allotted memory. Peak usage: 100% of the limit. Top memory consumer(s): aggregate functions ...
Dhiraj Bhalerao's user avatar
0 votes
0 answers
15 views

Generate evenly space point geography along a linestring

I have the total number of poles in a location (a sample area) and the road geometry (linestring) of each road in the area. I can calculate the average distance between poles, I want to distribute ...
3XT's user avatar
  • 1
0 votes
1 answer
892 views

SQL BigQuery function to return the previous non null value

I have the following table where some of the values are null and I would like to fill them with the previous non-null values. LAG function helps but if there are more than one null value in a row, it ...
Nata's user avatar
  • 3
1 vote
0 answers
74 views

Query google trend using google BigQuery

I need help with google BigQuery. Am using big query to query data from Google Trends. now I want to get data using a specific keyword example spiderman, and get the result in regions like CSV ...
Alvin masievi's user avatar
0 votes
1 answer
73 views

Transitioning from a python script for data transformation to BigQuery

So I have a dataset spread over multiple and ever-growing excel files all of which looks like: email order_ID order_date [email protected] 1234 23-Mar-2021 [email protected] 1235 23-Mar-2021 user2@...
Hamza's user avatar
  • 133
0 votes
0 answers
116 views

How to schedule importing data files from SFTP server located on compute engine instance into BigQuery?

What I want to achieve: Transfer hourly coming data files onto a SFTP file server located on a compute engine VM from several different feeds into Bigquery with real-time updates effectively & ...
Hamza's user avatar
  • 133
1 vote
1 answer
243 views

Is it possible to update data and retrain just one of several data series in bigquery model

I am building something very similar to this BigQuery ML example project. My system is different in two ways: Firstly it will need several thousand time-series so I would prefer to use the multiple-...
scipilot's user avatar
  • 121
1 vote
0 answers
26 views

Recommendation Systems User Profile Streaming Data on GCP

I have a recommendation system that recommends articles to different users. I am planning to provide the recommendations in an off-line fashion. Where I already have a table in BigQuery which has the ...
m2rik's user avatar
  • 321