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
12 views

Spike and dip cleaning in Big Query ML ARIMA_PLUS

If there is sales of a product spiking once every year (let us say every year in May). Will the ARIMA_PLUS model of Bigquery clean every year May sales as spike ...
user avatar
0 votes
0 answers
32 views

Decision tree from boosted tree regressor Google bigquery ML

If I set the num_parallel tree to 1 and max_iteration to 1 in boosted_tree_regressor of Google Big Query ML will it work as Decision tree regressor ? Also can such decision tree give negative ...
user avatar
0 votes
0 answers
5 views

Negative forecasts in ARIMA

Can ARIMA (specifically BigQueryML ARIMA_PLUS) give negative forecasts even if the training data has only 0 or positive values?
user avatar
0 votes
0 answers
19 views

Confidence/prediction interval vs lower and upper bounds in ARIMA_PLUS big query

How is CI intervals in ML.forecast and lower-upper bounds in ML.Detect_Anomalies different for Arima_plus model in BigqueryML ?
user avatar
0 votes
0 answers
24 views

What data/analytics tools I need to use at my current e-commerce workplace?

I recently started a new position as a data scientist at an E-commerce company. The company is founded about 4-5 years ago and is new to many data-related areas. Specifically, I'm their first data ...
user avatar
  • 121
1 vote
0 answers
31 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 ...
user avatar
0 votes
1 answer
41 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@...
user avatar
  • 133
0 votes
0 answers
63 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 & ...
user avatar
  • 133
1 vote
1 answer
90 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-...
user avatar
  • 121
1 vote
0 answers
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 ...
user avatar
  • 301