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
0answers
8 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 ...
-2
votes
1answer
14 views

Apache Beam - Python Inquiry [closed]

I have created a python pipeline to be run in Dataflow that takes a column from a csv file and counts the number of listings and returns them to a dictionary key value pair. I am very new to Apache ...
0
votes
1answer
24 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
10 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
27 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-...
0
votes
0answers
26 views

Create User Table from Google Firebase Analytics and Cloud Firestore Collections

I am exporting my snowplow collections collected on Firebase using the extention Export Collections to BigQuery firestore-bigquery-export v0.1.10. Whenever a document is created, updated, imported, or ...
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 ...
0
votes
0answers
37 views

How to visualize data skewness using Google Data Studio?

My dataset is stored in BigQuery and I like to use Google Data Studio to visualize data distribution/skewness of all the columns (in dataset) using graphical representation.