2

More than 5 years have passed since last update.

@munaita_(鈴木省吾)

FirebaseのログをBigQueryに貯めて分析するときにクエリの書き方で困ったのでメモ

Last updated at 2017-07-21Posted at 2017-07-21

event_dimで検索したい場合の例

_TABLE_SUFFIX使うと範囲指定できてお得
UNNEST使うと検索可能になる
- 詳しくは -> BigQueryでのクエリの書き方

SELECT COUNT(*)
FROM `some_app_IOS.app_events_*`, UNNEST(event_dim) AS event_dim
WHERE _TABLE_SUFFIX BETWEEN '20170601' AND '20170615'
AND event_dim.name = ‘user_engagement'

その他参考リンク

2

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

2