CODEWITHSUNDEEP
firebasegoogle-analyticsfirebase-realtime-databasegoogle-bigquerygoogle-cloud-platform
Prabhjot
Prabhjot

Reputation: 599

Import firebase analytics data into BigQuery for some specific events only

We have 100+ events (activities performed by users) for our android application, out of which we only want to track 10-15 events data. Remaining events are not important from analytics point of view. Can I extract specific events only from Firebase to BigQuery in the app_events table?

I understand that I can query out required events after all the events are dumped into BigQuery. This may not be the optimal solution as I don't want to process GBs of data every 10-15 minutes(intraday table). Can specific events be extracted from Firebase analytics data? Or is there a better way to do the same?

Upvotes: 2

Views: 1406

Answers (1)

Pentium10
Pentium10

Reputation: 208042

Well there are multiple options how this can be addressed. You cannot control the granularity of data that gets exported automatically. So you need to accept all events will be exported.

  1. Keep a copy of interested events only.

What you can do is either leave the original data as is, and copy and maintain a duplicate of the data only that you are interested in, and build your queries on the copy table. This way costs will be lower as you will query only a table that holds your important data.

  1. Delete data you don't need

You can even with DML delete all events you are not interested. That's a simple DELETE dml call. But please know that you won't get data back, so maybe you want first to export, which is free and keep archived the file. Cold storage is cheap.

Upvotes: 3

Related Questions