如何在BigQuery中选择多个自定义Firebase事件参数？ [英] How to select multiple custom Firebase event parameters in BigQuery?

问题描述

我将Firebase事件导出到BigQuery，现在我试图从某个事件中选择两个参数。这里是选择一个参数的查询：

pre $ select event_dim.params.value.int_value as level_id $ b $ from [com_company_appname_ANDROID .app_events_20161210]
其中event_dim.name =level_replays_until_first_victory和event_dim.params.key =level_id


这两个参数都是int值，第一个参数的名字是 level_id ，第二个参数是 count 。我希望在第一列显示 level_id ，在第二列显示 count 。

解决方案

以下将与标准SQL>

  SELECT 
（SELECT params。 value.int_value FROM x.params 
 WHERE params.key ='level_id'）AS level_id，
（SELECT params.value.int_value FROM x.params 
 WHERE params.key ='count' ）AS count 
 FROM`com_company_appname_ANDROID.app_events_20161210`，UNNEST（event_dim）AS x 
 WHERE x.name ='level_replays_until_first_victory'
  

另见从传统SQL迁移，以防万一您遗留的Legacy S QL

I exported Firebase events to BigQuery and now I'm trying to select two parameters from a certain event. Here is the query for selecting one parameter:

select event_dim.params.value.int_value as level_id
from [com_company_appname_ANDROID.app_events_20161210]
where event_dim.name = "level_replays_until_first_victory" and  event_dim.params.key = "level_id"

Both parameters are int values, name of the first parameter is level_id, and the second parameter is count. What I would like is to show is level_id in first column and count in second column.

解决方案

Below will work with BigQuery Standard SQL

SELECT 
  (SELECT params.value.int_value FROM x.params 
                                 WHERE params.key = 'level_id') AS level_id,
  (SELECT params.value.int_value FROM x.params 
                                 WHERE params.key = 'count') AS count
FROM `com_company_appname_ANDROID.app_events_20161210`, UNNEST(event_dim) AS x
WHERE x.name  = 'level_replays_until_first_victory'

See also Migrating from legacy SQL in case if you are stuck with Legacy SQL

这篇关于如何在BigQuery中选择多个自定义Firebase事件参数？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！