Topic 1 Question 56
You have enabled the free integration between Firebase Analytics and Google BigQuery. Firebase now automatically creates a new table daily in BigQuery in the format app_events_YYYYMMDD. You want to query all of the tables for the past 30 days in legacy SQL. What should you do?
Use the TABLE_DATE_RANGE function
Use the WHERE_PARTITIONTIME pseudo column
Use WHERE date BETWEEN YYYY-MM-DD AND YYYY-MM-DD
Use SELECT IF.(date >= YYYY-MM-DD AND date <= YYYY-MM-DD
解説
ユーザの投票
コメント(4)
A. is correct according to this link: https://cloud.google.com/bigquery/docs/reference/legacy-sql
👍 8damaldon2022/09/19A Is correct.
TABLE_DATE_RANGE() : Queries multiple daily tables that span a date range.
👍 2samdhimal2023/01/19A. is Correct... from...https://cloud.google.com/blog/products/management-tools/using-bigquery-and-firebase-analytics-to-understand-your-mobile-app SELECT user_dim.app_info.app_platform as appPlatform, user_dim.device_info.device_category as deviceType, COUNT(user_dim.device_info.device_category) AS device_type_count FROM TABLE_DATE_RANGE([firebase-analytics-sample-data:android_dataset.app_events_], DATE_ADD('2016-06-07', -7, 'DAY'), CURRENT_TIMESTAMP()), TABLE_DATE_RANGE([firebase-analytics-sample-data:ios_dataset.app_events_], DATE_ADD('2016-06-07', -7, 'DAY'), CURRENT_TIMESTAMP()) GROUP BY 1,2 ORDER BY device_type_count DESC
👍 1skp572022/11/10
シャッフルモード
