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
6
questions
0
votes
1
answer
125
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 ...
- 3
1
vote
0
answers
55
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 ...
0
votes
1
answer
59
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
user1@email.com
1234
23-Mar-2021
user2@email.com
1235
23-Mar-2021
user2@...
- 133
0
votes
0
answers
96
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 & ...
- 133
1
vote
1
answer
184
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-...
- 121
1
vote
0
answers
22
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 ...
- 321