Firebase Analytics：将数据作为日期导出到BigQuery [英] Firebase Analytics: export data to BigQuery as a date

问题描述

例如：

  Firebase.Analytics.FirebaseAnalytics.LogEvent（EventGamePlayed，sent_at，DateTime.Now.ToString（yyyy-MM-dd hh：mm：ss））; 
  

我想知道是否有可能，一旦它被导出到BigQuery，我可以使用这个参数作为一个日期/时间戳，所以我可以，例如，得到上个月发生的所有X或Y事件。

谢谢！

解决方案

实际上，你可能不需要这个。请参阅用于BigQuery导出的Firebase架构，您可以使用 date 或 timestamp_micros 在 event_dim 内。例如，要在4月1日发现事件，你可以这样做：

  #standardSQL 
 SELECT事件
 FROM YourTable 
 CROSS JOIN UNNEST（event_dim）AS event 
 WHERE PARSE_DATE（'％Y％m％d'，event.date）='2017-04-01'; 
  

要查找4月1日UTC时间12点到4点发生的事件，您可以：

$ $ $ $ $ $ $ $
$ SELECT
$ your $
$ CR $ JOB UNNEST（event_dim）AS
WHERE TIMESTAMP_MICROS（event.timestamp_micros）BETWEEN
'2017-04-01 12:00:00'AND'2017-04-01 16:00:00';

I'm trying to log events and specify the moment these moments happened.

For example:

Firebase.Analytics.FirebaseAnalytics.LogEvent ("EventGamePlayed", "sent_at", DateTime.Now.ToString ("yyyy-MM-dd hh:mm:ss"));

I would like to know if it's possible that, once it's exported to BigQuery, I could use this parameter as a date / timestamp so I can, for example, get all the X or Y events that happened last month.

Thanks!

解决方案

You probably don't need this, actually. Referring to the Firebase schema for BigQuery exports, you can use either date or timestamp_micros within event_dim. For example, to find events on April 1, you could do:

#standardSQL
SELECT event
FROM YourTable
CROSS JOIN UNNEST(event_dim) AS event
WHERE PARSE_DATE('%Y%m%d', event.date) = '2017-04-01';

To find events that occurred between 12pm and 4pm UTC on April 1, you could do:

#standardSQL
SELECT event
FROM YourTable
CROSS JOIN UNNEST(event_dim) AS event
WHERE TIMESTAMP_MICROS(event.timestamp_micros) BETWEEN
  '2017-04-01 12:00:00' AND '2017-04-01 16:00:00';

这篇关于Firebase Analytics：将数据作为日期导出到BigQuery的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！