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
1
vote
0answers
13 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
0answers
32 views

How to calculate date range constrained average Lifetime Value within Data Studio?

So within a data studio dashboard, I have a number of metrics e.g. Total Orders, Total Sales, Average order value etc. with YoY indicators as shown below: And all the metrics are working fine with ...
0
votes
1answer
36 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@...
0
votes
0answers
32 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 & ...
1
vote
1answer
65 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-...
1
vote
0answers
20 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 ...