Is the any way to import historical data from Firebase to Bigquery?

319 views
Skip to first unread message

Krittapat Wongyaowarak

unread,
Jul 26, 2018, 10:07:54 AM7/26/18
to Firebase Google Group
Hi everyone, I just linked Firebase to Bigquery yesterday. Is there any ways to import all the historical data from my Firebase to Bigquery too, because I can get only the realtime data or the data after I linked.

Ian Barber

unread,
Jul 26, 2018, 5:23:29 PM7/26/18
to Firebase Google Group
No, only the data after linking - Analytics only keeps a few days of raw data, older data is just stored in aggregate form.

On Thu, Jul 26, 2018 at 7:07 AM Krittapat Wongyaowarak <dron...@gmail.com> wrote:
Hi everyone, I just linked Firebase to Bigquery yesterday. Is there any ways to import all the historical data from my Firebase to Bigquery too, because I can get only the realtime data or the data after I linked.

--
You received this message because you are subscribed to the Google Groups "Firebase Google Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebase-tal...@googlegroups.com.
To post to this group, send email to fireba...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/firebase-talk/d3cfeb03-a9e2-4e78-a75f-e37a9c5a2de0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Krittapat Wongyaowarak

unread,
Jul 27, 2018, 12:34:12 AM7/27/18
to Firebase Google Group
Hi Ian,

Thanks for your response, could you please explain more about aggregate form? like where does it store? or which exactly form that they are stored?

Thanks,
Nut

Ian Barber

unread,
Jul 27, 2018, 11:17:12 AM7/27/18
to Firebase Google Group
Its the form used for the reports - so when you go back historically in the dashboard, you're seeing that aggregate data. There isn't a specific way of exporting, apart from grabbing the CSV for a specific report from the menu in the dashboard. 

Reply all
Reply to author
Forward
0 new messages