dataops-ci-bot
commented
3 months ago Integration report for "Merge branch 'main' into skip-format-fewer-files"
sql.diff
Click to expand!
```diff diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/telemetry/fenix_events_v1/view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry/fenix_events_v1/view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/telemetry/fenix_events_v1/view.sql 2024-06-27 21:26:56.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry/fenix_events_v1/view.sql 2024-06-27 21:26:57.000000000 +0000 @@ -1,11 +1,15 @@ CREATE OR REPLACE VIEW - `moz-fx-data-shared-prod.telemetry.fenix_events_v1` AS + `moz-fx-data-shared-prod.telemetry.fenix_events_v1` +AS SELECT submission_timestamp, client_info.client_id AS device_id, CONCAT(document_id, CAST(event.timestamp AS STRING)) AS insert_id, CONCAT(event.category, '.', event.name) AS event_type, - TIMESTAMP_ADD(mozfun.glean.parse_datetime(ping_info.start_time), INTERVAL event.timestamp SECOND) AS timestamp, + TIMESTAMP_ADD( + mozfun.glean.parse_datetime(ping_info.start_time), + INTERVAL event.timestamp SECOND + ) AS timestamp, client_info.app_display_version AS app_version, client_info.os AS platform, client_info.os AS os_name, @@ -15,19 +19,20 @@ metadata.geo.country AS country, metadata.geo.subdivision1 AS region, metadata.geo.city AS city, - ( -- direct insert of `udf.kv_array_to_json_string`, for use in a view - SELECT CONCAT( + ( -- direct insert of `moz-fx-data-shared-prod.udf.kv_array_to_json_string`, for use in a view + SELECT + CONCAT( '{', ARRAY_TO_STRING( ARRAY_AGG(CONCAT('"', CAST(key AS STRING), '":"', CAST(value AS STRING), '"')), - ","), - '}') + "," + ), + '}' + ) FROM UNNEST(event.extra) ) AS event_properties, - TO_JSON_STRING( - STRUCT(client_info.architecture AS arch) - ) AS user_properties + TO_JSON_STRING(STRUCT(client_info.architecture AS arch)) AS user_properties FROM `moz-fx-data-shared-prod.org_mozilla_fenix_stable.events_v1` CROSS JOIN diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/telemetry/fennec_ios_events_v1/view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry/fennec_ios_events_v1/view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/telemetry/fennec_ios_events_v1/view.sql 2024-06-27 21:26:56.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry/fennec_ios_events_v1/view.sql 2024-06-27 21:26:57.000000000 +0000 @@ -395,9 +395,20 @@ CAST(SAFE_CAST(value AS BOOLEAN) AS STRING) ) WHEN key = 'profile.blockPopups' - THEN CONCAT('"', 'pref_block_popups', '":', CAST(SAFE_CAST(value AS BOOLEAN) AS STRING)) + THEN CONCAT( + '"', + 'pref_block_popups', + '":', + CAST(SAFE_CAST(value AS BOOLEAN) AS STRING) + ) WHEN key = 'profile.prefkey.trackingprotection.enabled' - THEN CONCAT('"', 'pref_tracking_protection_enabled', '":"', CAST(value AS STRING), '"') + THEN CONCAT( + '"', + 'pref_tracking_protection_enabled', + '":"', + CAST(value AS STRING), + '"' + ) WHEN key = 'profile.prefkey.trackingprotection.normalbrowsing' THEN CONCAT( '"', @@ -415,9 +426,20 @@ '"' ) WHEN key = 'profile.prefkey.trackingprotection.strength' - THEN CONCAT('"', 'pref_tracking_protection_strength', '":"', CAST(value AS STRING), '"') + THEN CONCAT( + '"', + 'pref_tracking_protection_strength', + '":"', + CAST(value AS STRING), + '"' + ) WHEN key = 'profile.saveLogins' - THEN CONCAT('"', 'pref_save_logins', '":', CAST(SAFE_CAST(value AS BOOLEAN) AS STRING)) + THEN CONCAT( + '"', + 'pref_save_logins', + '":', + CAST(SAFE_CAST(value AS BOOLEAN) AS STRING) + ) WHEN key = 'profile.settings.closePrivateTabs' THEN CONCAT( '"', diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/telemetry/lockwise_mobile_events_v1/view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry/lockwise_mobile_events_v1/view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/telemetry/lockwise_mobile_events_v1/view.sql 2024-06-27 21:26:56.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry/lockwise_mobile_events_v1/view.sql 2024-06-27 21:26:57.000000000 +0000 @@ -1,40 +1,55 @@ CREATE OR REPLACE VIEW -`moz-fx-data-shared-prod.telemetry.lockwise_mobile_events_v1` AS + `moz-fx-data-shared-prod.telemetry.lockwise_mobile_events_v1` +AS -- -WITH - android AS ( +WITH android AS ( SELECT os, client_id, submission_date_s3, - timestamp_seconds(cast(substr(cast(metadata.timestamp AS string), 1, 10) AS int64)) AS submission_timestamp, + TIMESTAMP_SECONDS( + CAST(SUBSTR(CAST(metadata.timestamp AS string), 1, 10) AS int64) + ) AS submission_timestamp, device, metadata.app_build_id, e.* - FROM `moz-fx-data-shared-prod.telemetry.telemetry_mobile_event_parquet_v2`, UNNEST(events) AS e - WHERE metadata.app_name = 'Lockbox' + FROM + `moz-fx-data-shared-prod.telemetry.telemetry_mobile_event_parquet_v2`, + UNNEST(events) AS e + WHERE + metadata.app_name = 'Lockbox' AND os = 'Android' -- Filter out test data before the Android launch date. AND submission_date_s3 >= '2019-03-25' - ), +), -- - ios AS ( +ios AS ( SELECT os, client_id, submission_date_s3, - timestamp_seconds(cast(substr(cast(metadata.timestamp AS string), 1, 10) AS int64)) AS submission_timestamp, + TIMESTAMP_SECONDS( + CAST(SUBSTR(CAST(metadata.timestamp AS string), 1, 10) AS int64) + ) AS submission_timestamp, device, metadata.app_build_id, e.* FROM - `moz-fx-data-shared-prod.telemetry.telemetry_focus_event_parquet_v1`, UNNEST(events) AS e - WHERE metadata.app_name = 'Lockbox' + `moz-fx-data-shared-prod.telemetry.telemetry_focus_event_parquet_v1`, + UNNEST(events) AS e + WHERE + metadata.app_name = 'Lockbox' AND os = 'iOS' -- Filter out test data before the iOS launch date. AND submission_date_s3 >= '2018-07-09' - ) +) -- -SELECT * FROM android +SELECT + * +FROM + android UNION ALL -SELECT * FROM ios +SELECT + * +FROM + ios diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/telemetry/rocket_android_events_v1/view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry/rocket_android_events_v1/view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/telemetry/rocket_android_events_v1/view.sql 2024-06-27 21:26:56.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry/rocket_android_events_v1/view.sql 2024-06-27 21:26:57.000000000 +0000 @@ -1,8 +1,8 @@ CREATE OR REPLACE VIEW - `moz-fx-data-shared-prod.telemetry.rocket_android_events_v1` AS + `moz-fx-data-shared-prod.telemetry.rocket_android_events_v1` +AS WITH base_events AS ( - -SELECT + SELECT *, event.f0_ AS timestamp, event.f0_ AS event_timestamp, @@ -16,232 +16,1097 @@ metadata.geo.country, metadata.geo.city, metadata.uri.app_name -FROM + FROM `moz-fx-data-shared-prod.telemetry.focus_event` - CROSS JOIN UNNEST(events) AS event - -), all_events AS ( -SELECT + CROSS JOIN + UNNEST(events) AS event +), +all_events AS ( + SELECT submission_timestamp, client_id AS device_id, - (created + COALESCE(SAFE_CAST(`moz-fx-data-shared-prod.udf.get_key`(event_map_values, 'session_id') AS INT64), 0)) AS session_id, + ( + created + COALESCE( + SAFE_CAST(`moz-fx-data-shared-prod.udf.get_key`(event_map_values, 'session_id') AS INT64), + 0 + ) + ) AS session_id, CASE - WHEN (event_category IN ('action') ) AND (event_method IN ('launch') ) AND (event_object IN ('app') ) AND (event_value IN ('launcher') ) THEN 'Rocket - App is launched by Launcher' - WHEN (event_category IN ('action') ) AND (event_method IN ('launch') ) AND (event_object IN ('app') ) AND (event_value IN ('shortcut') ) THEN 'Rocket - App is launched by Shortcut' - WHEN (event_category IN ('action') ) AND (event_method IN ('launch') ) AND (event_object IN ('app') ) AND (event_value IN ('private_mode') ) THEN 'Rocket - App is launched from Private Shortcut' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('private_shortcut') ) AND event_value IS NULL THEN 'Rocket - Show private shortcut prompt' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('private_shortcut') ) AND (event_value IN ('positive', 'negative', 'dismiss') ) THEN 'Rocket - Click private shortcut prompt' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('setting') ) AND (event_value IN ('pref_private_shortcut') ) THEN 'Rocket - Users clicked on a Setting' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('private_mode') ) AND (event_value IN ('exit') ) THEN 'Rocket - Exit private mode' - WHEN (event_category IN ('action') ) AND (event_method IN ('pin_shortcut') ) AND (event_object IN ('private_shortcut') ) AND event_value IS NULL THEN 'Rocket - Private shortcut created' - WHEN (event_category IN ('action') ) AND (event_method IN ('kill') ) AND (event_object IN ('app') ) AND event_value IS NULL THEN 'Rocket - Kill app' - WHEN (event_category IN ('action') ) AND (event_method IN ('launch') ) AND (event_object IN ('app') ) AND (event_value IN ('external_app') ) THEN 'Rocket - App is launched by external app' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('setting') ) AND (event_value IN ('learn_more') ) THEN 'Rocket - Users clicked on the Learn More link in Settings' - WHEN (event_category IN ('action') ) AND (event_method IN ('change') ) AND (event_object IN ('setting') ) AND (event_value IN ('pref_locale') ) THEN 'Rocket - Users change Locale in Settings' - WHEN (event_category IN ('action') ) AND (event_method IN ('foreground') ) AND (event_object IN ('app') ) AND event_value IS NULL THEN 'Rocket - Session starts' - WHEN (event_category IN ('action') ) AND (event_method IN ('background') ) AND (event_object IN ('app') ) AND event_value IS NULL THEN 'Rocket - Session ends' - WHEN (event_category IN ('action') ) AND (event_method IN ('long_press') ) AND (event_object IN ('browser') ) AND event_value IS NULL THEN 'Rocket - Long Press ContextMenu' - WHEN (event_category IN ('action') ) AND (event_method IN ('cancel') ) AND (event_object IN ('browser_contextmenu') ) AND event_value IS NULL THEN 'Rocket - Cancel ContextMenu' - WHEN (event_category IN ('action') ) AND (event_method IN ('share') ) AND (event_object IN ('browser_contextmenu') ) AND (event_value IN ('link') ) THEN 'Rocket - Share link via ContextMenu' - WHEN (event_category IN ('action') ) AND (event_method IN ('share') ) AND (event_object IN ('browser_contextmenu') ) AND (event_value IN ('image') ) THEN 'Rocket - Share image via ContextMenu' - WHEN (event_category IN ('action') ) AND (event_method IN ('save') ) AND (event_object IN ('browser_contextmenu') ) AND (event_value IN ('image') ) THEN 'Rocket - Save image via ContextMenu' - WHEN (event_category IN ('action') ) AND (event_method IN ('copy') ) AND (event_object IN ('browser_contextmenu') ) AND (event_value IN ('link') ) THEN 'Rocket - Copy link via ContextMenu' - WHEN (event_category IN ('action') ) AND (event_method IN ('copy') ) AND (event_object IN ('browser_contextmenu') ) AND (event_value IN ('image') ) THEN 'Rocket - Copy image via ContextMenu' - WHEN (event_category IN ('action') ) AND (event_method IN ('add') ) AND (event_object IN ('browser_contextmenu') ) AND (event_value IN ('link') ) THEN 'Rocket - Add link via ContextMenu' - WHEN (event_category IN ('action') ) AND (event_method IN ('permission') ) AND (event_object IN ('browser') ) AND (event_value IN ('geolocation') ) THEN 'Rocket - Permission-Geolocation' - WHEN (event_category IN ('action') ) AND (event_method IN ('permission') ) AND (event_object IN ('browser') ) AND (event_value IN ('file') ) THEN 'Rocket - Permission-File' - WHEN (event_category IN ('action') ) AND (event_method IN ('permission') ) AND (event_object IN ('browser') ) AND (event_value IN ('audio', 'video', 'eme', 'midi') ) THEN 'Rocket - Permission-Media' - WHEN (event_category IN ('action') ) AND (event_method IN ('fullscreen') ) AND (event_object IN ('browser') ) AND (event_value IN ('enter') ) THEN 'Rocket - Enter full screen' - WHEN (event_category IN ('action') ) AND (event_method IN ('fullscreen') ) AND (event_object IN ('browser') ) AND (event_value IN ('exit') ) THEN 'Rocket - Exit full screen' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('menu') ) AND (event_value IN ('home') ) THEN 'Rocket - Show Menu from Home' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('tab_tray') ) AND (event_value IN ('home') ) THEN 'Rocket - Show TabTray from Home' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('tab_tray') ) AND (event_value IN ('toolbar') ) THEN 'Rocket - Show TabTray from Toolbar' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('menu') ) AND (event_value IN ('toolbar') ) THEN 'Rocket - Show Menu from Toolbar' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('menu') ) AND (event_value IN ('download') ) THEN 'Rocket - Click Menu - Downloads' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('menu') ) AND (event_value IN ('history') ) THEN 'Rocket - Click Menu - History' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('menu') ) AND (event_value IN ('capture') ) THEN 'Rocket - Click Menu - MyShots' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('panel') ) AND (event_value IN ('bookmark') ) THEN 'Rocket - Click Panel - Bookmarks' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('panel') ) AND (event_value IN ('download') ) THEN 'Rocket - Click Panel - Downloads' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('panel') ) AND (event_value IN ('history') ) THEN 'Rocket - Click Panel - History' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('panel') ) AND (event_value IN ('capture') ) THEN 'Rocket - Click Panel - MyShots' - WHEN (event_category IN ('action') ) AND (event_method IN ('change') ) AND (event_object IN ('menu') ) AND (event_value IN ('turbo') ) THEN 'Rocket - Click Menu - TurboMode' - WHEN (event_category IN ('action') ) AND (event_method IN ('change') ) AND (event_object IN ('menu') ) AND (event_value IN ('night_mode') ) THEN 'Rocket - Click Menu - Night Mode' - WHEN (event_category IN ('action') ) AND (event_method IN ('change') ) AND (event_object IN ('menu') ) AND (event_value IN ('block_image') ) THEN 'Rocket - Click Menu - Block Images' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('menu') ) AND (event_value IN ('clear_cache') ) THEN 'Rocket - Click Menu - Clear cache' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('menu') ) AND (event_value IN ('settings') ) THEN 'Rocket - Click Menu - Settings' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('menu') ) AND (event_value IN ('exit') ) THEN 'Rocket - Click Menu - Exit' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('menu') ) AND (event_value IN ('bookmark') ) THEN 'Rocket - Click Menu - Bookmarks' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('menu') ) AND (event_value IN ('theme') ) THEN 'Rocket - Click Menu - Theme' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('menu') ) AND (event_value IN ('add_topsite') ) THEN 'Rocket - Click Menu - Add Topsite' - WHEN (event_category IN ('action') ) AND (event_method IN ('change') ) AND (event_object IN ('menu') ) AND (event_value IN ('vertical') ) THEN 'Rocket - Click Menu - Vertical Toggle' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('toolbar') ) AND (event_value IN ('forward') ) THEN 'Rocket - Click Toolbar - Forward' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('toolbar') ) AND (event_value IN ('reload') ) THEN 'Rocket - Click Toolbar - Reload' - WHEN (event_category IN ('action') ) AND (event_method IN ('share') ) AND (event_object IN ('toolbar') ) AND (event_value IN ('link') ) THEN 'Rocket - Click Toolbar - Share Link' - WHEN (event_category IN ('action') ) AND (event_method IN ('share') ) AND (event_object IN ('toolbar') ) AND (event_value IN ('bookmark') ) THEN 'Rocket - Click Toolbar - Add bookmark' - WHEN (event_category IN ('action') ) AND (event_method IN ('pin_shortcut') ) AND (event_object IN ('toolbar') ) AND (event_value IN ('link') ) THEN 'Rocket - Click Toolbar - Pin shortcut' - WHEN (event_category IN ('action') ) AND (event_method IN ('pin_shortcut') ) AND (event_object IN ('menu') ) AND (event_value IN ('link') ) THEN 'Rocket - Click Menu - Pin shortcut' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('toolbar') ) AND (event_value IN ('capture') ) THEN 'Rocket - Click Toolbar - Take Screenshot' - WHEN (event_category IN ('action') ) AND (event_method IN ('open') ) AND (event_object IN ('home') ) AND (event_value IN ('link') ) THEN 'Rocket - Click Top Site' - WHEN (event_category IN ('action') ) AND (event_method IN ('remove') ) AND (event_object IN ('home') ) AND (event_value IN ('link') ) THEN 'Rocket - Remove Top Site' - WHEN (event_category IN ('action') ) AND (event_method IN ('add') ) AND (event_object IN ('home') ) AND (event_value IN ('link') ) THEN 'Rocket - Add Topsite' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('snackbar') ) AND (event_value IN ('add_topsite') ) THEN 'Rocket - Click Add Topsite Snackbar' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('panel') ) AND (event_value IN ('add_topsite') ) THEN 'Rocket - Select to Add Topsite' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('contextual_hint') ) AND (event_value IN ('theme') ) THEN 'Rocket - Show Theme Contextual Hint' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('contextual_hint') ) AND (event_value IN ('theme') ) THEN 'Rocket - Click Theme Contextual Hint' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('message') ) AND (event_value IN ('go_set_default') ) THEN 'Rocket - Show Go-Set-Default Message' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('message') ) AND (event_value IN ('go_set_default') ) THEN 'Rocket - Click Go-Set-Default Message' - WHEN (event_category IN ('action') ) AND (event_method IN ('add') ) AND (event_object IN ('tab') ) AND (event_value IN ('home') ) THEN 'Rocket - Search in Home and add a tab' - WHEN (event_category IN ('action') ) AND (event_method IN ('open') ) AND (event_object IN ('search_bar') ) AND (event_value IN ('link') ) THEN 'Rocket - Enter an url in SearchBar' - WHEN (event_category IN ('action') ) AND (event_method IN ('select_query') ) AND (event_object IN ('search_bar') ) AND event_value IS NULL THEN 'Rocket - Use SearchSuggestion SearchBar' - WHEN (event_category IN ('action') ) AND (event_method IN ('type_query') ) AND (event_object IN ('search_bar') ) AND event_value IS NULL THEN 'Rocket - Search with text in SearchBar' - WHEN (event_category IN ('action') ) AND (event_method IN ('change') ) AND (event_object IN ('private_mode') ) AND (event_value IN ('enter', 'exit') ) THEN 'Rocket - Toggle Private Mode' - WHEN (event_category IN ('action') ) AND (event_method IN ('long_press') ) AND (event_object IN ('search_suggestion') ) AND event_value IS NULL THEN 'Rocket - Long click on Search Suggestion' - WHEN (event_category IN ('action') ) AND (event_method IN ('clear') ) AND (event_object IN ('search_bar') ) AND event_value IS NULL THEN 'Rocket - Clear SearchBar' - WHEN (event_category IN ('action') ) AND (event_method IN ('cancel') ) AND (event_object IN ('search_bar') ) AND event_value IS NULL THEN 'Rocket - Dismiss SearchBar' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('search_bar') ) AND (event_value IN ('search_box') ) THEN 'Rocket - Show SearchBar from Home' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('search_bar') ) AND (event_value IN ('mini_urlbar') ) THEN 'Rocket - Show SearchBar by clicking MINI_URLBAR' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('search_bar') ) AND (event_value IN ('search_btn') ) THEN 'Rocket - Show SearchBar by clicking SEARCH_BUTTON' - WHEN (event_category IN ('action') ) AND (event_method IN ('add') ) AND (event_object IN ('tab') ) AND (event_value IN ('toolbar') ) THEN 'Rocket - Add Tab from Toolbar' - WHEN (event_category IN ('action') ) AND (event_method IN ('add') ) AND (event_object IN ('tab') ) AND (event_value IN ('tab_tray') ) THEN 'Rocket - Add Tab from TabTray' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('private_mode') ) AND (event_value IN ('tab_tray') ) THEN 'Rocket - Enter Private Mode from TabTray' - WHEN (event_category IN ('action') ) AND (event_method IN ('change') ) AND (event_object IN ('tab') ) AND (event_value IN ('tab_tray') ) THEN 'Rocket - Switch Tab From TabTray' - WHEN (event_category IN ('action') ) AND (event_method IN ('remove') ) AND (event_object IN ('tab') ) AND (event_value IN ('tab_tray') ) THEN 'Rocket - Remove Tab From TabTray' - WHEN (event_category IN ('action') ) AND (event_method IN ('swipe') ) AND (event_object IN ('tab') ) AND (event_value IN ('tab_tray') ) THEN 'Rocket - Swipe Tab From TabTray' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('close_all') ) AND (event_value IN ('tab_tray') ) THEN 'Rocket - Close all From TabTray' - WHEN (event_category IN ('action') ) AND (event_method IN ('remove') ) AND (event_object IN ('panel') ) AND (event_value IN ('file') ) THEN 'Rocket - Remove Download File' - WHEN (event_category IN ('action') ) AND (event_method IN ('delete') ) AND (event_object IN ('panel') ) AND (event_value IN ('file') ) THEN 'Rocket - Delete Download File' - WHEN (event_category IN ('action') ) AND (event_method IN ('open') ) AND (event_object IN ('panel') ) AND (event_value IN ('file') ) THEN 'Rocket - Open Download File via snackbar' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('menu') ) AND (event_value IN ('download') ) THEN 'Rocket - Show File ContextMenu' - WHEN (event_category IN ('action') ) AND (event_method IN ('open') ) AND (event_object IN ('panel') ) AND (event_value IN ('link') ) THEN 'Rocket - History Open Link' - WHEN (event_category IN ('action') ) AND (event_method IN ('remove') ) AND (event_object IN ('panel') ) AND (event_value IN ('link') ) THEN 'Rocket - History Remove Link' - WHEN (event_category IN ('action') ) AND (event_method IN ('remove') ) AND (event_object IN ('panel') ) AND (event_value IN ('bookmark') ) THEN 'Rocket - Bookmark Remove Item' - WHEN (event_category IN ('action') ) AND (event_method IN ('edit') ) AND (event_object IN ('panel') ) AND (event_value IN ('bookmark') ) THEN 'Rocket - Bookmark Edit Item' - WHEN (event_category IN ('action') ) AND (event_method IN ('open') ) AND (event_object IN ('panel') ) AND (event_value IN ('bookmark') ) THEN 'Rocket - Bookmark Open Item' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('menu') ) AND (event_value IN ('history') ) THEN 'Rocket - Show History ContextMenu' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('menu') ) AND (event_value IN ('bookmark') ) THEN 'Rocket - Show Bookmark ContextMenu' - WHEN (event_category IN ('action') ) AND (event_method IN ('clear') ) AND (event_object IN ('panel') ) AND (event_value IN ('history') ) THEN 'Rocket - Clear History' - WHEN (event_category IN ('action') ) AND (event_method IN ('open') ) AND (event_object IN ('panel') ) AND (event_value IN ('capture') ) THEN 'Rocket - Open Capture Item' - WHEN (event_category IN ('action') ) AND (event_method IN ('open') ) AND (event_object IN ('capture') ) AND (event_value IN ('link') ) THEN 'Rocket - Open Capture Link' - WHEN (event_category IN ('action') ) AND (event_method IN ('edit') ) AND (event_object IN ('capture') ) AND (event_value IN ('image') ) THEN 'Rocket - Edit Capture Image' - WHEN (event_category IN ('action') ) AND (event_method IN ('share') ) AND (event_object IN ('capture') ) AND (event_value IN ('image') ) THEN 'Rocket - Share Capture Image' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('capture') ) AND (event_value IN ('info') ) THEN 'Rocket - Show Capture Info' - WHEN (event_category IN ('action') ) AND (event_method IN ('delete') ) AND (event_object IN ('capture') ) AND (event_value IN ('image') ) THEN 'Rocket - Delete Capture Image' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('feedback') ) AND (event_value IN ('dismiss', 'positive', 'negative') OR event_value IS NULL) THEN 'Rocket - click Rate App' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('feedback') ) AND event_value IS NULL THEN 'Rocket - Show Rate App' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('default_browser') ) AND event_value IS NULL THEN 'Rocket - Default Browser Notification shown' - WHEN (event_category IN ('action') ) AND (event_method IN ('get') ) AND (event_object IN ('firstrun_push') ) AND event_value IS NULL THEN 'Rocket - Receive Firstrun Push config' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('firstrun_push') ) AND event_value IS NULL THEN 'Rocket - Firstrun Push notification shown' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('default_browser') ) AND event_value IS NULL THEN 'Rocket - Default Browser Notification Clicked' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('promote_share') ) AND (event_value IN ('dismiss', 'share') ) THEN 'Rocket - Promote Share Dialog Clicked' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('promote_share') ) AND event_value IS NULL THEN 'Rocket - Promote Share Dialog shown' - WHEN (event_category IN ('action') ) AND (event_method IN ('change') ) AND (event_object IN ('themetoy') ) AND event_value IS NULL THEN 'Rocket - Change Theme To' - WHEN (event_category IN ('action') ) AND (event_method IN ('reset') ) AND (event_object IN ('themetoy') ) AND event_value IS NULL THEN 'Rocket - Reset Theme To' - WHEN (event_category IN ('action') ) AND (event_method IN ('clear') ) AND (event_object IN ('private_mode') ) AND event_value IS NULL THEN 'Rocket - Erase Private Mode Notification' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('home') ) AND event_value IS NULL THEN 'Rocket - Home Impression' - WHEN (event_category IN ('Downloads') ) AND (event_method IN ('long_press') ) AND (event_object IN ('toolbar') ) AND (event_value IN ('download') ) THEN 'Rocket - Long Press Toolbar Download Indicator' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('find_in_page') ) AND (event_value IN ('next') ) THEN 'Rocket - Click FindInPage Next' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('find_in_page') ) AND (event_value IN ('previous') ) THEN 'Rocket - Click FindInPage Previous' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('menu') ) AND (event_value IN ('find_in_page') ) THEN 'Rocket - Click Menu FindInPage' - WHEN (event_category IN ('search') ) AND (event_method IN ('click') ) AND (event_object IN ('quicksearch') ) AND event_value IS NULL THEN 'Rocket - Click Quick Search' - WHEN (event_category IN ('enter landscape mode') ) AND (event_method IN ('change') ) AND (event_object IN ('landscape_mode') ) AND (event_value IN ('enter') ) THEN 'Rocket - Enter Landscape Mode' - WHEN (event_category IN ('enter landscape mode') ) AND (event_method IN ('change') ) AND (event_object IN ('landscape_mode') ) AND (event_value IN ('exit') ) THEN 'Rocket - Exit Landscape Mode' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('update_msg') ) AND event_value IS NULL THEN 'Rocket - Show in-app update intro dialog' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('update') ) AND event_value IS NULL THEN 'Rocket - Show google play\'s in-app update dialog' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('update_msg') ) AND (event_value IN ('positive', 'negative') ) THEN 'Rocket - Click in-app update intro dialog' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('update') ) AND (event_value IN ('positive', 'negative') ) THEN 'Rocket - Click google play\'s in-app update dialog' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('update') ) AND (event_value IN ('downloaded') ) THEN 'Rocket - Show in-app update install prompt' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('update') ) AND (event_value IN ('apply') ) THEN 'Rocket - Click in-app update install prompt' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('onboarding') ) AND (event_value IN ('firstrun') ) THEN 'Rocket - Show Firstrun Onboarding' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('onboarding') ) AND (event_value IN ('firstrun') ) THEN 'Rocket - Click Firstrun Onboarding' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('logoman') ) AND event_value IS NULL THEN 'Rocket - Show Logoman' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('logoman') ) AND event_value IS NULL THEN 'Rocket - Click Logoman' - WHEN (event_category IN ('action') ) AND (event_method IN ('swipe') ) AND (event_object IN ('logoman') ) AND event_value IS NULL THEN 'Rocket - Swipe Logoman' - WHEN (event_category IN ('action') ) AND (event_method IN ('get') ) AND (event_object IN ('notification') ) AND event_value IS NULL THEN 'Rocket - Get Notification' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('notification') ) AND event_value IS NULL THEN 'Rocket - Show Notification' - WHEN (event_category IN ('action') ) AND (event_method IN ('swipe') ) AND (event_object IN ('notification') ) AND (event_value IN ('dismiss') ) THEN 'Rocket - Dismiss Notification' - WHEN (event_category IN ('action') ) AND (event_method IN ('swipe') ) AND (event_object IN ('firstrun_push') ) AND (event_value IN ('dismiss') ) THEN 'Rocket - Dismiss D1 Notification' - WHEN (event_category IN ('action') ) AND (event_method IN ('open') ) AND (event_object IN ('notification') ) AND event_value IS NULL THEN 'Rocket - Open Notification' - WHEN (event_category IN ('action') ) AND (event_method IN ('open') ) AND (event_object IN ('firstrun_push') ) AND event_value IS NULL THEN 'Rocket - Open D1 Notification' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('message') ) AND (event_value IN ('in_app_message') ) THEN 'Rocket - Show In-App Message' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('message') ) AND (event_value IN ('in_app_message') ) THEN 'Rocket - Click In-App Message' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('content_hub') ) AND event_value IS NULL THEN 'Rocket - Click Content Hub' - WHEN (event_category IN ('action') ) AND (event_method IN ('reload') ) AND (event_object IN ('content_home') ) AND event_value IS NULL THEN 'Rocket - Reload Content Home' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('search_bar') ) AND (event_value IN ('content_home') ) THEN 'Rocket - Show Content Home Search Bar' - WHEN (event_category IN ('action') ) AND (event_method IN ('select_query') ) AND (event_object IN ('search_bar') ) AND (event_value IN ('content_home') ) THEN 'Rocket - Select Query Content Home' - WHEN (event_category IN ('action') ) AND (event_method IN ('open') ) AND (event_object IN ('category') ) AND event_value IS NULL THEN 'Rocket - Open Category' - WHEN (event_category IN ('action') ) AND (event_method IN ('open') ) AND (event_object IN ('detail_page') ) AND (event_value IN ('more') ) THEN 'Rocket - Open Detail Page More' - WHEN (event_category IN ('action') ) AND (event_method IN ('start') ) AND (event_object IN ('content_tab') ) AND event_value IS NULL THEN 'Rocket - Start Content Tab' - WHEN (event_category IN ('action') ) AND (event_method IN ('end') ) AND (event_object IN ('content_tab') ) AND event_value IS NULL THEN 'Rocket - End Content Tab' - WHEN (event_category IN ('action') ) AND (event_method IN ('impression') ) AND (event_object IN ('category') ) AND event_value IS NULL THEN 'Rocket - Category Impression' - WHEN (event_category IN ('action') ) AND (event_method IN ('start') ) AND (event_object IN ('process') ) AND (event_value IN ('vertical') ) THEN 'Rocket - Start Vertical Process' - WHEN (event_category IN ('action') ) AND (event_method IN ('end') ) AND (event_object IN ('process') ) AND (event_value IN ('vertical') ) THEN 'Rocket - End Vertical Process' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('onboarding') ) AND (event_value IN ('vertical') ) THEN 'Rocket - Show Vertical Onboarding' - WHEN (event_category IN ('action') ) AND (event_method IN ('start') ) AND (event_object IN ('process') ) AND (event_value IN ('tab_swipe') ) THEN 'Rocket - Start Tab Swipe Process' - WHEN (event_category IN ('action') ) AND (event_method IN ('end') ) AND (event_object IN ('process') ) AND (event_value IN ('tab_swipe') ) THEN 'Rocket - End Tab Swipe Process' - WHEN (event_category IN ('action') ) AND (event_method IN ('start') ) AND (event_object IN ('tab_swipe') ) AND event_value IS NULL THEN 'Rocket - Start Tab Swipe' - WHEN (event_category IN ('action') ) AND (event_method IN ('end') ) AND (event_object IN ('tab_swipe') ) AND event_value IS NULL THEN 'Rocket - End Tab Swipe' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('toolbar') ) AND (event_value IN ('share') ) THEN 'Rocket - Click Toolbar - Share' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('toolbar') ) AND (event_value IN ('OPEN_IN_BROWSER') ) THEN 'Rocket - Click Toolbar - Open in browser' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('toolbar') ) AND (event_value IN ('reload') ) THEN 'Rocket - Click Toolbar - Reload' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('toolbar') ) AND (event_value IN ('back') ) THEN 'Rocket - Click Toolbar - Back' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('toolbar') ) AND (event_value IN ('tab_swipe') ) THEN 'Rocket - Click Toolbar - Tab Swipe' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('drawer') ) AND (event_value IN ('tab_swipe') ) THEN 'Rocket - Show Tab Swipe Drawer' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('drawer') ) AND (event_value IN ('tab_swipe') ) THEN 'Rocket - Click Tab Swipe Drawer' - WHEN (event_category IN ('action') ) AND (event_method IN ('add') ) AND (event_object IN ('tab') ) AND (event_value IN ('tab_swipe') ) THEN 'Rocket - Add Tab Swipe Tab' - WHEN (event_category IN ('action') ) AND (event_method IN ('change') ) AND (event_object IN ('setting') ) AND (event_value IN ('tab_swipe') ) THEN 'Rocket - Change Tab Swipe Settings' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('search_bar') ) AND (event_value IN ('tab_swipe') ) THEN 'Rocket - Show SearchBar from Tab Swipe' - WHEN (event_category IN ('action') ) AND (event_method IN ('show_keyboard') ) AND (event_object IN ('search_bar') ) AND (event_value IN ('tab_swipe') ) THEN 'Rocket - Show Keyboard from Tab Swipe SearchBar' - WHEN (event_category IN ('action') ) AND (event_method IN ('start_typing') ) AND (event_object IN ('search_bar') ) AND (event_value IN ('tab_swipe') ) THEN 'Rocket - Start Typing from Tab Swipe SearchBar' - WHEN (event_category IN ('action') ) AND (event_method IN ('type_query') ) AND (event_object IN ('search_bar') ) AND (event_value IN ('tab_swipe') ) THEN 'Rocket - Search with text in SearchBar' - WHEN (event_category IN ('action') ) AND (event_method IN ('select_query') ) AND (event_object IN ('search_bar') ) AND (event_value IN ('tab_swipe') ) THEN 'Rocket - Use SearchSuggestion in Tab Swipe SearchBar' - WHEN (event_category IN ('action') ) AND (event_method IN ('change') ) AND (event_object IN ('setting') ) AND (event_value IN ('detail_page') ) THEN 'Rocket - Change Travel Settings' - WHEN (event_category IN ('action') ) AND (event_method IN ('change') ) AND (event_object IN ('onboarding') ) AND (event_value IN ('personalization') ) THEN 'Rocket - Change Personalization in Onboarding' - WHEN (event_category IN ('action') ) AND (event_method IN ('change') ) AND (event_object IN ('onboarding') ) AND (event_value IN ('language') ) THEN 'Rocket - Change Language in Onboarding' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('setting') ) AND (event_value IN ('lifestyle') ) THEN 'Rocket - Click News Settings' - WHEN (event_category IN ('action') ) AND (event_method IN ('change') ) AND (event_object IN ('setting') ) AND (event_value IN ('category') ) THEN 'Rocket - Change Category in Settings' - WHEN (event_category IN ('action') ) AND (event_method IN ('change') ) AND (event_object IN ('setting') ) AND (event_value IN ('lifestyle') ) THEN 'Rocket - Change News Settings' - WHEN (event_category IN ('action') ) AND (event_method IN ('pin') ) AND (event_object IN ('home') ) AND (event_value IN ('link') ) THEN 'Rocket - Pin Topsite' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('challenge_page') ) AND (event_value IN ('join') ) THEN 'Rocket - Click Challenge Page Join' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('contextual_hint') ) AND (event_value IN ('task') ) THEN 'Rocket - Show Task Contextual Hint' - WHEN (event_category IN ('action') ) AND (event_method IN ('end') ) AND (event_object IN ('task') ) AND event_value IS NULL THEN 'Rocket - End Task' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('message') ) AND (event_value IN ('challenge_complete') ) THEN 'Rocket - Show Challenge Complete Message' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('message') ) AND (event_value IN ('challenge_complete') ) THEN 'Rocket - Click Challenge Complete Message' - WHEN (event_category IN ('action') ) AND (event_method IN ('sign_in') ) AND (event_object IN ('account') ) AND event_value IS NULL THEN 'Rocket - Account Sign In' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('redeem_page') ) AND event_value IS NULL THEN 'Rocket - Show Redeem Page' - WHEN (event_category IN ('action') ) AND (event_method IN ('copy') ) AND (event_object IN ('redeem_page') ) AND (event_value IN ('code') ) THEN 'Rocket - Copy Code on Redeem Page' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('redeem_page') ) AND (event_value IN ('use') ) THEN 'Rocket - Click Redeem on Redeem Page' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('profile') ) AND (event_value IN ('reward') ) THEN 'Rocket - Click Reward Profile' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('content_home') ) AND (event_value IN ('item') ) THEN 'Rocket - Click Content Home Item' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('challenge_page') ) AND (event_value IN ('login') ) THEN 'Rocket - Click Chellenge Page Login' - WHEN (event_category IN ('action') ) AND (event_method IN ('long_press') ) AND (event_object IN ('content_home') ) AND (event_value IN ('item') ) THEN 'Rocket - Long Press Content Home Item' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('content_home') ) AND (event_value IN ('contextmenu') ) THEN 'Rocket - Click Content Home Contextmenu' - WHEN (event_category IN ('action') ) AND (event_method IN ('launch') ) AND (event_object IN ('app') ) AND (event_value IN ('game_shortcut') ) THEN 'Rocket - App is launched by Game Shortcut' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('message') ) AND (event_value IN ('update') ) THEN 'Rocket - Show Update Message' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('message') ) AND (event_value IN ('update') ) THEN 'Rocket - Click Update Message' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('contextual_hint') ) AND (event_value IN ('game_shortcut') ) THEN 'Rocket - Show Game Shortcut Contextual Hint' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('message') ) AND (event_value IN ('travel_search_result') ) THEN 'Rocket - Show Travel Search Result Message' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('message') ) AND (event_value IN ('travel_search_result') ) THEN 'Rocket - Click Travel Search Result Message' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('message') ) AND (event_value IN ('setdefault_travel_search') ) THEN 'Rocket - Show Set-default Travel Search Message' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('message') ) AND (event_value IN ('setdefault_travel_search') ) THEN 'Rocket - Click Set-default Travel Search Message' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('toast') ) AND (event_value IN ('exit_warning') ) THEN 'Rocket - Show Exit Warning Toast' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('message') ) AND (event_value IN ('set_default_by_settings') ) THEN 'Rocket - Show Set-Default by Settings Message' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('message') ) AND (event_value IN ('set_default_by_link') ) THEN 'Rocket - Show Set-Default by Link Message' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('message') ) AND (event_value IN ('set_default_by_settings') ) THEN 'Rocket - Click Set-Default by Settings Message' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('message') ) AND (event_value IN ('set_default_by_link') ) THEN 'Rocket - Click Set-Default by Link Message' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('toast') ) AND (event_value IN ('set_default_success') ) THEN 'Rocket - Show Set-Default Success Toast' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('snackbar') ) AND (event_value IN ('set_default_try_again') ) THEN 'Rocket - Show Set-Default Try-again Snackbar' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('snackbar') ) AND (event_value IN ('set_default_try_again') ) THEN 'Rocket - Click Set-Default Try-again Snackbar' - WHEN (event_category IN ('action') ) AND (event_method IN ('start') ) AND (event_object IN ('download') ) AND (event_value IN ('file') ) THEN 'Rocket - Start Download File' - WHEN (event_category IN ('action') ) AND (event_method IN ('end') ) AND (event_object IN ('download') ) AND (event_value IN ('file') ) THEN 'Rocket - End Download File' - WHEN (event_category IN ('action') ) AND (event_method IN ('change') ) AND (event_object IN ('firstrun') ) AND (event_value IN ('turbo') ) THEN 'Rocket - Turn on Turbo Mode in First Run' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('firstrun') ) AND (event_value IN ('finish') ) THEN 'Rocket - Finish First Run' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('onboarding') ) AND (event_value IN ('whatsnew') ) THEN 'Rocket - Show Whatsnew Onboarding' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('onboarding') ) AND (event_value IN ('whatsnew') ) THEN 'Rocket - Click Whatsnew Onboarding' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('contextual_hint') ) AND (event_value IN ('firstrun') ) THEN 'Rocket - Show Firstrun Contextual Hint' - WHEN (event_category IN ('action') ) AND (event_method IN ('show') ) AND (event_object IN ('contextual_hint') ) AND (event_value IN ('whatsnew') ) THEN 'Rocket - Show Whatsnew Contextual Hint' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('contextual_hint') ) AND (event_value IN ('firstrun') ) THEN 'Rocket - Click Firstrun Contextual Hint' - WHEN (event_category IN ('action') ) AND (event_method IN ('click') ) AND (event_object IN ('contextual_hint') ) AND (event_value IN ('whatsnew') ) THEN 'Rocket - Click Whatsnew Contextual Hint' - + WHEN (event_category IN ('action')) + AND (event_method IN ('launch')) + AND (event_object IN ('app')) + AND (event_value IN ('launcher')) + THEN 'Rocket - App is launched by Launcher' + WHEN (event_category IN ('action')) + AND (event_method IN ('launch')) + AND (event_object IN ('app')) + AND (event_value IN ('shortcut')) + THEN 'Rocket - App is launched by Shortcut' + WHEN (event_category IN ('action')) + AND (event_method IN ('launch')) + AND (event_object IN ('app')) + AND (event_value IN ('private_mode')) + THEN 'Rocket - App is launched from Private Shortcut' + WHEN (event_category IN ('action')) + AND (event_method IN ('show')) + AND (event_object IN ('private_shortcut')) + AND event_value IS NULL + THEN 'Rocket - Show private shortcut prompt' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('private_shortcut')) + AND (event_value IN ('positive', 'negative', 'dismiss')) + THEN 'Rocket - Click private shortcut prompt' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('setting')) + AND (event_value IN ('pref_private_shortcut')) + THEN 'Rocket - Users clicked on a Setting' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('private_mode')) + AND (event_value IN ('exit')) + THEN 'Rocket - Exit private mode' + WHEN (event_category IN ('action')) + AND (event_method IN ('pin_shortcut')) + AND (event_object IN ('private_shortcut')) + AND event_value IS NULL + THEN 'Rocket - Private shortcut created' + WHEN (event_category IN ('action')) + AND (event_method IN ('kill')) + AND (event_object IN ('app')) + AND event_value IS NULL + THEN 'Rocket - Kill app' + WHEN (event_category IN ('action')) + AND (event_method IN ('launch')) + AND (event_object IN ('app')) + AND (event_value IN ('external_app')) + THEN 'Rocket - App is launched by external app' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('setting')) + AND (event_value IN ('learn_more')) + THEN 'Rocket - Users clicked on the Learn More link in Settings' + WHEN (event_category IN ('action')) + AND (event_method IN ('change')) + AND (event_object IN ('setting')) + AND (event_value IN ('pref_locale')) + THEN 'Rocket - Users change Locale in Settings' + WHEN (event_category IN ('action')) + AND (event_method IN ('foreground')) + AND (event_object IN ('app')) + AND event_value IS NULL + THEN 'Rocket - Session starts' + WHEN (event_category IN ('action')) + AND (event_method IN ('background')) + AND (event_object IN ('app')) + AND event_value IS NULL + THEN 'Rocket - Session ends' + WHEN (event_category IN ('action')) + AND (event_method IN ('long_press')) + AND (event_object IN ('browser')) + AND event_value IS NULL + THEN 'Rocket - Long Press ContextMenu' + WHEN (event_category IN ('action')) + AND (event_method IN ('cancel')) + AND (event_object IN ('browser_contextmenu')) + AND event_value IS NULL + THEN 'Rocket - Cancel ContextMenu' + WHEN (event_category IN ('action')) + AND (event_method IN ('share')) + AND (event_object IN ('browser_contextmenu')) + AND (event_value IN ('link')) + THEN 'Rocket - Share link via ContextMenu' + WHEN (event_category IN ('action')) + AND (event_method IN ('share')) + AND (event_object IN ('browser_contextmenu')) + AND (event_value IN ('image')) + THEN 'Rocket - Share image via ContextMenu' + WHEN (event_category IN ('action')) + AND (event_method IN ('save')) + AND (event_object IN ('browser_contextmenu')) + AND (event_value IN ('image')) + THEN 'Rocket - Save image via ContextMenu' + WHEN (event_category IN ('action')) + AND (event_method IN ('copy')) + AND (event_object IN ('browser_contextmenu')) + AND (event_value IN ('link')) + THEN 'Rocket - Copy link via ContextMenu' + WHEN (event_category IN ('action')) + AND (event_method IN ('copy')) + AND (event_object IN ('browser_contextmenu')) + AND (event_value IN ('image')) + THEN 'Rocket - Copy image via ContextMenu' + WHEN (event_category IN ('action')) + AND (event_method IN ('add')) + AND (event_object IN ('browser_contextmenu')) + AND (event_value IN ('link')) + THEN 'Rocket - Add link via ContextMenu' + WHEN (event_category IN ('action')) + AND (event_method IN ('permission')) + AND (event_object IN ('browser')) + AND (event_value IN ('geolocation')) + THEN 'Rocket - Permission-Geolocation' + WHEN (event_category IN ('action')) + AND (event_method IN ('permission')) + AND (event_object IN ('browser')) + AND (event_value IN ('file')) + THEN 'Rocket - Permission-File' + WHEN (event_category IN ('action')) + AND (event_method IN ('permission')) + AND (event_object IN ('browser')) + AND (event_value IN ('audio', 'video', 'eme', 'midi')) + THEN 'Rocket - Permission-Media' + WHEN (event_category IN ('action')) + AND (event_method IN ('fullscreen')) + AND (event_object IN ('browser')) + AND (event_value IN ('enter')) + THEN 'Rocket - Enter full screen' + WHEN (event_category IN ('action')) + AND (event_method IN ('fullscreen')) + AND (event_object IN ('browser')) + AND (event_value IN ('exit')) + THEN 'Rocket - Exit full screen' + WHEN (event_category IN ('action')) + AND (event_method IN ('show')) + AND (event_object IN ('menu')) + AND (event_value IN ('home')) + THEN 'Rocket - Show Menu from Home' + WHEN (event_category IN ('action')) + AND (event_method IN ('show')) + AND (event_object IN ('tab_tray')) + AND (event_value IN ('home')) + THEN 'Rocket - Show TabTray from Home' + WHEN (event_category IN ('action')) + AND (event_method IN ('show')) + AND (event_object IN ('tab_tray')) + AND (event_value IN ('toolbar')) + THEN 'Rocket - Show TabTray from Toolbar' + WHEN (event_category IN ('action')) + AND (event_method IN ('show')) + AND (event_object IN ('menu')) + AND (event_value IN ('toolbar')) + THEN 'Rocket - Show Menu from Toolbar' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('menu')) + AND (event_value IN ('download')) + THEN 'Rocket - Click Menu - Downloads' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('menu')) + AND (event_value IN ('history')) + THEN 'Rocket - Click Menu - History' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('menu')) + AND (event_value IN ('capture')) + THEN 'Rocket - Click Menu - MyShots' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('panel')) + AND (event_value IN ('bookmark')) + THEN 'Rocket - Click Panel - Bookmarks' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('panel')) + AND (event_value IN ('download')) + THEN 'Rocket - Click Panel - Downloads' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('panel')) + AND (event_value IN ('history')) + THEN 'Rocket - Click Panel - History' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('panel')) + AND (event_value IN ('capture')) + THEN 'Rocket - Click Panel - MyShots' + WHEN (event_category IN ('action')) + AND (event_method IN ('change')) + AND (event_object IN ('menu')) + AND (event_value IN ('turbo')) + THEN 'Rocket - Click Menu - TurboMode' + WHEN (event_category IN ('action')) + AND (event_method IN ('change')) + AND (event_object IN ('menu')) + AND (event_value IN ('night_mode')) + THEN 'Rocket - Click Menu - Night Mode' + WHEN (event_category IN ('action')) + AND (event_method IN ('change')) + AND (event_object IN ('menu')) + AND (event_value IN ('block_image')) + THEN 'Rocket - Click Menu - Block Images' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('menu')) + AND (event_value IN ('clear_cache')) + THEN 'Rocket - Click Menu - Clear cache' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('menu')) + AND (event_value IN ('settings')) + THEN 'Rocket - Click Menu - Settings' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('menu')) + AND (event_value IN ('exit')) + THEN 'Rocket - Click Menu - Exit' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('menu')) + AND (event_value IN ('bookmark')) + THEN 'Rocket - Click Menu - Bookmarks' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('menu')) + AND (event_value IN ('theme')) + THEN 'Rocket - Click Menu - Theme' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('menu')) + AND (event_value IN ('add_topsite')) + THEN 'Rocket - Click Menu - Add Topsite' + WHEN (event_category IN ('action')) + AND (event_method IN ('change')) + AND (event_object IN ('menu')) + AND (event_value IN ('vertical')) + THEN 'Rocket - Click Menu - Vertical Toggle' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('toolbar')) + AND (event_value IN ('forward')) + THEN 'Rocket - Click Toolbar - Forward' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('toolbar')) + AND (event_value IN ('reload')) + THEN 'Rocket - Click Toolbar - Reload' + WHEN (event_category IN ('action')) + AND (event_method IN ('share')) + AND (event_object IN ('toolbar')) + AND (event_value IN ('link')) + THEN 'Rocket - Click Toolbar - Share Link' + WHEN (event_category IN ('action')) + AND (event_method IN ('share')) + AND (event_object IN ('toolbar')) + AND (event_value IN ('bookmark')) + THEN 'Rocket - Click Toolbar - Add bookmark' + WHEN (event_category IN ('action')) + AND (event_method IN ('pin_shortcut')) + AND (event_object IN ('toolbar')) + AND (event_value IN ('link')) + THEN 'Rocket - Click Toolbar - Pin shortcut' + WHEN (event_category IN ('action')) + AND (event_method IN ('pin_shortcut')) + AND (event_object IN ('menu')) + AND (event_value IN ('link')) + THEN 'Rocket - Click Menu - Pin shortcut' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('toolbar')) + AND (event_value IN ('capture')) + THEN 'Rocket - Click Toolbar - Take Screenshot' + WHEN (event_category IN ('action')) + AND (event_method IN ('open')) + AND (event_object IN ('home')) + AND (event_value IN ('link')) + THEN 'Rocket - Click Top Site' + WHEN (event_category IN ('action')) + AND (event_method IN ('remove')) + AND (event_object IN ('home')) + AND (event_value IN ('link')) + THEN 'Rocket - Remove Top Site' + WHEN (event_category IN ('action')) + AND (event_method IN ('add')) + AND (event_object IN ('home')) + AND (event_value IN ('link')) + THEN 'Rocket - Add Topsite' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('snackbar')) + AND (event_value IN ('add_topsite')) + THEN 'Rocket - Click Add Topsite Snackbar' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('panel')) + AND (event_value IN ('add_topsite')) + THEN 'Rocket - Select to Add Topsite' + WHEN (event_category IN ('action')) + AND (event_method IN ('show')) + AND (event_object IN ('contextual_hint')) + AND (event_value IN ('theme')) + THEN 'Rocket - Show Theme Contextual Hint' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('contextual_hint')) + AND (event_value IN ('theme')) + THEN 'Rocket - Click Theme Contextual Hint' + WHEN (event_category IN ('action')) + AND (event_method IN ('show')) + AND (event_object IN ('message')) + AND (event_value IN ('go_set_default')) + THEN 'Rocket - Show Go-Set-Default Message' + WHEN (event_category IN ('action')) + AND (event_method IN ('click')) + AND (event_object IN ('message')) + AND (event_value IN ('go_set_default')) + THEN 'Rocket - Click Go-Set-Default Message' + WHEN (event_category IN ('action')) + AND (event_method IN ('add')) + AND (event_object IN ('tab')) + AND (event_value IN ('home')) + THEN 'Rocket - Search in Home and add a tab' + WHEN (event_category IN ('action')) + AND (event_method IN ('open')) + AND (event_object IN ('search_bar')) + AND (event_value IN ('link')) + THEN 'Rocket - Enter an url in SearchBar' + WHEN (event_category IN ('action')) + AND (event_method IN ('select_query')) + AND (event_object IN ('search_bar')) + AND event_value IS NULL + THEN 'Rocket - Use SearchSuggestion SearchBar' + WHEN (event_category IN ('action')) + AND (event_method IN ('type_query')) + AND (event_object IN ('search_bar')) + AND event_value IS NULL + THEN 'Rocket - Search with text in Sear ```⚠️ Only part of the diff is displayed.
There should be no reason not to format these files. Removing them from the skip list and running
bqetl formaton them in this PR.The remaining UDFs and stored procedures on the skip list should stay there as formatting breaks them
Checklist for reviewer:
<username>:<branch>of the fork as parameter. The parameter will also show up in the logs of themanual-trigger-required-for-forkCI task together with more detailed instructions.For modifications to schemas in restricted namespaces (see
CODEOWNERS):┆Issue is synchronized with this Jira Task