分析Firebase数据 [英] Analyze Firebase data

问题描述

我有一个使用Firebase来存储其数据的移动应用程序. 我正在存储所有用户数据，不同的业务对象和关系.

I have a mobile app that uses Firebase to store it's data. I am storing all user data, different business objects and relationships.

我正在寻找一种分析数据的方法.我想对数据执行查询和汇总，并生成报告. Firebase网站提到使用Google的BigQuery，但似乎没有简单的方法将数据从Firebase导入到其中.

I am looking for a way to analyze my data. I want to execute queries and aggregations on the data, and to generate reports. The Firebase site mentioned using BigQuery from Google, but there seems to be no easy way to import data from Firebase to it.

实现此目标的最佳方法是什么?我知道我可以创建每日备份，但是在拥有原始JSON数据之后，如何查询呢?

What is the best way to achieve this? I know I can create daily backups, but after I have the raw JSON data how can I query it?

UPDATE 8/5:

UPDATE 8/5:

为清楚起见，这是来自Firebase的示例JSON数据:

For making things clear, here is sample JSON data from Firebase:

{
  "lambeosaurus": {
    "height" : 2.1,
    "length" : 12.5,
    "weight": 5000
  },
  "stegosaurus": {
    "height" : 4,
    "length" : 9,
    "weight" : 2500
  }
}

此JSON不是换行符.

This JSON is not new-line delimited.

推荐答案

1. 创建Firebase备份
2. 使用 BigQuery联合来源直接从BigQuery查询该备份(JSON为支持)

1. Create firebase backup
2. Use BigQuery federated sources to query that backup directly from BigQuery (JSON is supported)

这篇关于分析Firebase数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！