bigquery-etl/sql/glam-fenix-dev/glam_etl
Eduardo Filho b994884098
GLAM purge percentile calculations and prep downstream (#5966)
* Remove percentiles

* Remove tests that test percentiles

* Refresh scripts insert null to new percentiles

* Remove percentile columns from queries and schemas

* Delete more percentile tables

* Formatting

* histogram_cast_struct's keys are strings

* Re-add test after fixing failure cause
2024-07-25 10:44:43 -04:00
..
firefox_desktop__clients_daily_histogram_aggregates_metrics_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
firefox_desktop__clients_daily_scalar_aggregates_baseline_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
firefox_desktop__clients_daily_scalar_aggregates_deletion_request_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
firefox_desktop__clients_daily_scalar_aggregates_events_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
firefox_desktop__clients_daily_scalar_aggregates_fog_validation_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
firefox_desktop__clients_daily_scalar_aggregates_metrics_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
firefox_desktop__view_clients_daily_histogram_aggregates_v1 firefox_desktop_to_glam (#2485) 2021-11-22 13:45:19 -05:00
firefox_desktop__view_clients_daily_scalar_aggregates_v1 firefox_desktop_to_glam (#2485) 2021-11-22 13:45:19 -05:00
firefox_desktop_glam_nightly__clients_histogram_aggregates_v1 Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
firefox_desktop_glam_nightly__clients_scalar_aggregates_v1 Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
firefox_desktop_glam_nightly__extract_probe_counts_v1 GLAM purge percentile calculations and prep downstream (#5966) 2024-07-25 10:44:43 -04:00
firefox_desktop_glam_nightly__extract_user_counts_v1 Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
firefox_desktop_glam_nightly__histogram_bucket_counts_v1 Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
firefox_desktop_glam_nightly__histogram_probe_counts_v1 Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
firefox_desktop_glam_nightly__latest_versions_v1 Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
firefox_desktop_glam_nightly__scalar_bucket_counts_v1 Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
firefox_desktop_glam_nightly__scalar_probe_counts_v1 Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
firefox_desktop_glam_nightly__view_clients_daily_histogram_aggregates_v1 Change `bqetl format` to uppercase built-in function names (#3536) 2023-01-26 16:07:10 -08:00
firefox_desktop_glam_nightly__view_clients_daily_scalar_aggregates_v1 Change `bqetl format` to uppercase built-in function names (#3536) 2023-01-26 16:07:10 -08:00
firefox_desktop_glam_nightly__view_probe_counts_v1 GLAM purge percentile calculations and prep downstream (#5966) 2024-07-25 10:44:43 -04:00
firefox_desktop_glam_nightly__view_sample_counts_v1 firefox_desktop_to_glam (#2485) 2021-11-22 13:45:19 -05:00
firefox_desktop_glam_nightly__view_user_counts_v1 firefox_desktop_to_glam (#2485) 2021-11-22 13:45:19 -05:00
org_mozilla_fenix__clients_daily_histogram_aggregates_metrics_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix__clients_daily_scalar_aggregates_activation_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix__clients_daily_scalar_aggregates_addresses_sync_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix__clients_daily_scalar_aggregates_baseline_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix__clients_daily_scalar_aggregates_bookmarks_sync_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix__clients_daily_scalar_aggregates_creditcards_sync_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix__clients_daily_scalar_aggregates_deletion_request_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix__clients_daily_scalar_aggregates_events_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix__clients_daily_scalar_aggregates_first_session_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix__clients_daily_scalar_aggregates_history_sync_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix__clients_daily_scalar_aggregates_installation_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix__clients_daily_scalar_aggregates_logins_sync_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix__clients_daily_scalar_aggregates_metrics_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix__clients_daily_scalar_aggregates_migration_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix__clients_daily_scalar_aggregates_startup_timeline_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix__clients_daily_scalar_aggregates_sync_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix__clients_daily_scalar_aggregates_tabs_sync_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix__view_clients_daily_histogram_aggregates_v1 Fix #2274 - Nest schemas under field object in glam queries (#2275) 2021-08-20 19:49:55 +00:00
org_mozilla_fenix__view_clients_daily_scalar_aggregates_v1 Fix #2274 - Nest schemas under field object in glam queries (#2275) 2021-08-20 19:49:55 +00:00
org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1 Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1 Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
org_mozilla_fenix_glam_nightly__extract_probe_counts_v1 GLAM purge percentile calculations and prep downstream (#5966) 2024-07-25 10:44:43 -04:00
org_mozilla_fenix_glam_nightly__extract_user_counts_v1 Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1 Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1 Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
org_mozilla_fenix_glam_nightly__latest_versions_v1 Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1 Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
org_mozilla_fenix_glam_nightly__scalar_probe_counts_v1 Fully qualified identifiers in SQL queries (#5764) 2024-06-27 09:53:33 -07:00
org_mozilla_fenix_glam_nightly__view_clients_daily_histogram_aggregates_v1 Indent join conditions (#4223) 2024-01-11 15:50:26 -08:00
org_mozilla_fenix_glam_nightly__view_clients_daily_scalar_aggregates_v1 Indent join conditions (#4223) 2024-01-11 15:50:26 -08:00
org_mozilla_fenix_glam_nightly__view_probe_counts_v1 GLAM purge percentile calculations and prep downstream (#5966) 2024-07-25 10:44:43 -04:00
org_mozilla_fenix_glam_nightly__view_sample_counts_v1 adjusting the fenix counts (#2837) 2022-03-29 16:20:45 -04:00
org_mozilla_fenix_glam_nightly__view_user_counts_v1 Fix #2274 - Nest schemas under field object in glam queries (#2275) 2021-08-20 19:49:55 +00:00
org_mozilla_fenix_nightly__clients_daily_histogram_aggregates_metrics_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix_nightly__clients_daily_scalar_aggregates_metrics_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fenix_nightly__view_clients_daily_histogram_aggregates_v1 Fix #2274 - Nest schemas under field object in glam queries (#2275) 2021-08-20 19:49:55 +00:00
org_mozilla_fenix_nightly__view_clients_daily_scalar_aggregates_v1 Fix #2274 - Nest schemas under field object in glam queries (#2275) 2021-08-20 19:49:55 +00:00
org_mozilla_fennec_aurora__clients_daily_histogram_aggregates_metrics_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fennec_aurora__clients_daily_scalar_aggregates_metrics_v1 # issues(3416): added missing metadata.yaml files inside glam-fenix-dev (#3655) 2023-03-16 10:51:40 +00:00
org_mozilla_fennec_aurora__view_clients_daily_histogram_aggregates_v1 Fix #2274 - Nest schemas under field object in glam queries (#2275) 2021-08-20 19:49:55 +00:00
org_mozilla_fennec_aurora__view_clients_daily_scalar_aggregates_v1 Fix #2274 - Nest schemas under field object in glam queries (#2275) 2021-08-20 19:49:55 +00:00