Firebase Data to BigQuery where the collections are dynamic

[katzbm]

I have an application that generates various types of "assignments" which are saved to collections in Firebase.  These assignments change from time to time (a question gets added, deleted or changed) and I'm exporting the data to BigQuery so that I can use Looker to visualize the results.  Think of it as survey questions with mostly yes/no questions with some exceptions.  Is there a partner plug in that would have a low to no code solution for constantly looking at these assignments, organizing the collection data for me so that I can visualize (dashboard) results?  

Thank you to anyone with thoughts.  

[Joevanie]

You can link your Firebase project to BigQuery by following this documentation. You can then use Looker or other tools to connect to your BigQuery dataset and create dashboards and reports based on your Firebase data.

[katzbm]

Thanks for the reply but I don't think this addresses my specific question.  

My dataset is dynamic, for example a list of questions in a survey.  Those questions change for a collection, new ones added, others edited or deleted and BigQuery wants a fixed schema in its tables.  What I'm looking for is something (native or 3rd party) that will detect those differences, generate a new table or overwrite the previous schema each time changes are making.  Does that make sense?

[Ricky_Roo]

hi Joevanie,

Do u know why i cannot enable google analytics toggle when we linked firebase project to BigQuery, the error showing message "Google analytics is not currently enabled for this project"?