sql/moz-fx-data-shared-prod/firefox_accounts/fxa_all_events/view.sql (7 lines): - line 29: -- TODO: add a cut off date once AWS to GCP migration is complete. - line 35: -- TODO: once no longer aliasing to fxa_log in the final part of the query, - line 76: -- TODO: add a cut off date once AWS to GCP migration is complete. - line 99: -- TODO: add a cut off date once AWS to GCP migration is complete. - line 103: -- TODO: once no longer aliasing to fxa_log in the final part of the query, - line 123: -- TODO: add a cut off date once AWS to GCP migration is complete. - line 215: -- TODO: remove this aliasing, however, this will require changes downstream why broken down into multiple changes / PRs sql_generators/usage_reporting/usage_reporting.py (4 lines): - line 23: # TODO: can we have the templates picked up in some way automatically? - line 59: # TODO: maybe we should have a data structure defined for this config and - line 79: # TODO: turn the generatic dict into a custom app data structure. - line 83: # TODO: should we use "multichannel" instead of None as an indicator of this in the config file? bigquery_etl/cli/query.py (4 lines): - line 448: # TODO: Add costs and last_updated info - line 454: # TODO: Parse more complex parameters such as macro_ds_add - line 819: except Exception as e: # TODO: More specific exception(s) - line 1628: # TODO: https://github.com/mozilla/bigquery-etl/issues/5804 sql/moz-fx-data-shared-prod/subscription_platform_derived/logical_subscriptions_history_v1/query.sql (2 lines): - line 87: -- TODO: calculate normalized attribution values like `mozfun.norm.vpn_attribution()` does - line 102: -- TODO: calculate normalized attribution values like `mozfun.norm.vpn_attribution()` does bqetl_project.yaml (2 lines): - line 32: # TODO: once data observability platform assessment concludes this should be removed. - line 266: # TODO: this should be removed if views are to be automatically deployed sql/moz-fx-data-shared-prod/monitoring_derived/shredder_targets_v1/query.py (2 lines): - line 67: -- TODO: can't get lineage for most opmon tables, need to figure this out separately - line 360: # TODO: handle other id columns sql/moz-fx-data-shared-prod/subscription_platform_derived/service_subscriptions_history_v1/query.sql (2 lines): - line 136: -- TODO: calculate normalized attribution values like `mozfun.norm.vpn_attribution()` does - line 151: -- TODO: calculate normalized attribution values like `mozfun.norm.vpn_attribution()` does bigquery_etl/util/probe_filters.py (1 line): - line 7: TODO: Change the function name and doc when final implementation is done. sql/moz-fx-data-shared-prod/marketing_suppression_list_derived/main_suppression_list_v1/query.sql (1 line): - line 29: -- TODO set this up once there are unsubscribes sql/moz-fx-data-shared-prod/fenix_derived/firefox_android_clients_v1/query.sql (1 line): - line 2: -- TODO: at the next refactor, should we consider replacing baseline_clients and first_seen CTEs sql/moz-fx-data-shared-prod/telemetry_derived/newtab_interactions_v1/query.sql (1 line): - line 150: -- TODO: Note: this greatly increases the cardinality of the table, this means we'll likely have to make a version two bigquery_etl/metadata/validate_metadata.py (1 line): - line 454: # TODO: add failed checks to message sql/moz-fx-data-shared-prod/firefox_ios_derived/app_store_funnel_v1/checks.sql (1 line): - line 66: -- TODO: for this query it'd be useful to compare sum variance between each day to improve our confidence the data was complete at the execution time. sql/moz-fx-data-shared-prod/subscription_platform_derived/service_subscription_events_v1/query.sql (1 line): - line 44: -- TODO: rather than "Unknown", determine if the user cancelled intentionally or their payment failed sql/moz-fx-data-shared-prod/mozilla_vpn_derived/funnel_ga_to_subscriptions_v1/query.sql (1 line): - line 127: -- TODO why is subscriptions.date not checked? bigquery_etl/deploy.py (1 line): - line 87: except Exception as e: # TODO: Raise/catch more specific exception sql/moz-fx-data-shared-prod/telemetry/clients_last_seen_v2/view.sql (1 line): - line 155: -- TODO: Announce and remove this temporary field. sql/moz-fx-data-shared-prod/monitoring_derived/structured_missing_columns_v1/query.py (1 line): - line 51: -- TODO: manually curate known missing schema bits sql/moz-fx-data-shared-prod/apple_ads_external/ios_app_campaign_stats_v1/query.sql (1 line): - line 60: -- TODO: we should update this to use retention_clients view instead sql/moz-fx-data-shared-prod/firefox_accounts_derived/fxa_users_daily_v1/metadata.yaml (1 line): - line 15: # TODO: Once fxa_users_daily_v2 backfill is completed and data confirmed to be heatlhy sql/moz-fx-data-shared-prod/firefox_accounts_derived/fxa_users_last_seen_v1/metadata.yaml (1 line): - line 17: # TODO: Once fxa_users_last_seen_v2 backfill is completed and data confirmed to be heatlhy bigquery_etl/schema/__init__.py (1 line): - line 224: # TODO: Uncomment this print when Netlify fixes the problem. sql/moz-fx-data-shared-prod/subscription_platform_derived/stripe_logical_subscriptions_history_v1/query.sql (1 line): - line 259: -- TODO: ended_reason sql/moz-fx-data-shared-prod/subscription_platform_derived/logical_subscription_events_v1/query.sql (1 line): - line 40: -- TODO: rather than "Unknown", determine if the user cancelled intentionally or their payment failed bigquery_etl/backfill/utils.py (1 line): - line 93: # TODO: It would be better to take in a backfill object. sql/moz-fx-data-shared-prod/firefox_accounts_derived/fxa_users_first_seen_v1/metadata.yaml (1 line): - line 12: # TODO: Once fxa_users_first_seen_v2 backfill is completed and data confirmed to be heatlhy sql/moz-fx-data-shared-prod/firefox_ios_derived/app_store_funnel_v1/query.sql (1 line): - line 1: -- TODO: should we run this job with 7 day delay to make sure all data landed (a wider window to be on the safe side). sql_generators/stable_views/__init__.py (1 line): - line 239: # TODO: Later, after consumers switch to aliased fields we'll remove the `2`-suffixed fields sql/moz-fx-data-shared-prod/firefox_accounts_derived/fxa_users_services_last_seen_v2/query.sql (1 line): - line 1: -- TODO: for now this is a copy of v1, we still need to adjust and make sure sql/moz-fx-data-shared-prod/telemetry/clients_last_seen_v1/view.sql (1 line): - line 137: -- TODO: Announce and remove this temporary field. sql/moz-fx-data-shared-prod/mozilla_vpn_derived/funnel_ga_to_subscriptions_v2/query.sql (1 line): - line 153: -- TODO why is subscriptions.date not checked? sql/moz-fx-data-shared-prod/telemetry/desktop_acquisition_funnel/view.sql (1 line): - line 12: -- TODO: There's a prettier way to decode these but for now... bigquery_etl/cli/monitoring.py (1 line): - line 883: # TODO: remove this command once checks have been migrated sql/moz-fx-data-shared-prod/firefox_accounts/nonprod_fxa_content_auth_stdout_events/view.sql (1 line): - line 4: -- TODO: we should look into deleting this view sql/moz-fx-data-shared-prod/telemetry_derived/clients_first_seen_v2/checks.sql (1 line): - line 30: -- TODO: from https://mozilla-hub.atlassian.net/browse/DS-3102: bigquery_etl/metadata/publish_metadata.py (1 line): - line 57: # TODO: in the future we can consider updating the table expiration date based on deletion_date