mozilla / bigquery-etl - Conditional Complexity

Intro

Conditional complexity (also called cyclomatic complexity) is a term used to measure the complexity of software. The term refers to the number of possible paths through a program function. A higher value ofter means higher maintenance and testing costs (infosecinstitute.com).
Conditional complexity is calculated by counting all conditions in the program that can affect the execution path (e.g. if statement, loops, switches, and/or operators, try and catch blocks...).
Conditional complexity is measured at the unit level (methods, functions...).
Units are classified in four categories based on the measured McCabe index: 1-5 (simple units), 6-10 (medium complex units), 11-25 (complex units), 26+ (very complex units).

Learn more...

Conditional Complexity Overall

There are 979 units with 15,897 lines of code in units (6.3% of code).

1 very complex units (117 lines of code)
5 complex units (497 lines of code)
59 medium complex units (3,987 lines of code)
102 simple units (3,336 lines of code)
812 very simple units (7,960 lines of code)

Legend:

51+

26-50

11-25

6-10

1-5

Alternative Visuals

3D view of all units

Conditional Complexity per Extension

51+

26-50

11-25

6-10

1-5

Conditional Complexity per Logical Component

primary logical decomposition

51+

26-50

11-25

6-10

1-5

Most Complex Units

Top 50 most complex units

Unit	# lines	McCabe index	# params
def simple_format() in bigquery_etl/format_sql/formatter.py	117	70	2
def main() in bigquery_etl/shredder/delete.py	194	44	0
def get_histogram_probes_and_buckets() in sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_histogram_aggregates_v1.sql.py	78	32	2
def with_upstream_dependencies() in bigquery_etl/query_scheduling/task.py	66	27	2
def from_file() in bigquery_etl/metadata/parse_metadata.py	102	27	2
def inline_block_format() in bigquery_etl/format_sql/formatter.py	57	26	2
def runtest() in bigquery_etl/pytest_plugin/sql.py	125	25	1
def run() in bigquery_etl/cli/monitoring.py	89	25	6
def main() in script/marketing/generate_app_store_queries.py	87	24	6
def _generate_view_schema() in sql_generators/derived_view_schemas/__init__.py	103	24	3
def format() in bigquery_etl/format_sql/format.py	46	24	3
def _initialize() in bigquery_etl/cli/query.py	112	23	1
def qualify_table_references_in_file() in bigquery_etl/util/common.py	83	23	1
def main() in sql/moz-fx-data-shared-prod/google_play_store_derived/slow_startup_events_by_startup_type_version_and_device_v1/query.py	159	23	0
def of_query() in bigquery_etl/query_scheduling/task.py	62	22	4
def _view_dependencies() in bigquery_etl/cli/stage.py	57	22	2
def publish() in bigquery_etl/view/__init__.py	77	22	4
def _process_ping() in sql_generators/glean_usage/glean_app_ping_views.py	134	21	1
def tokenize() in bigquery_etl/format_sql/tokenizer.py	49	21	2
def replace() in sql/moz-fx-data-shared-prod/telemetry/unnest_parquet_view.sql.py	56	21	3
def _get_symbols() in sql/moz-fx-data-shared-prod/telemetry_derived/crash_symbols_v1/query.py	69	21	4
def get_scalar_probes() in sql/moz-fx-data-shared-prod/telemetry_derived/clients_daily_scalar_aggregates_v1.sql.py	80	21	1
def list_tables() in sql_generators/glean_usage/common.py	29	20	4
def from_file() in bigquery_etl/routine/parse_routine.py	72	20	2
def main() in script/legacy/export_to_parquet.py	91	19	0
def dry_run_result() in bigquery_etl/dryrun.py	103	19	1
def get_bigquery_type() in bigquery_etl/backfill/shredder_mitigation.py	37	19	1
def generate() in sql_generators/mobile_kpi_support_metrics/__init__.py	133	18	3
def validate_shredder_mitigation() in bigquery_etl/metadata/validate_metadata.py	81	18	2
def update() in bigquery_etl/cli/metadata.py	65	18	3
def main() in bigquery_etl/shredder/cost.py	73	17	0
def _list_live_tables() in bigquery_etl/copy_deduplicate.py	18	17	5
def get_dags() in bigquery_etl/query_scheduling/generate_airflow_dags.py	68	17	3
def _deploy_artifacts() in bigquery_etl/cli/stage.py	78	17	5
def get_referenced_tables() in bigquery_etl/dryrun.py	62	16	1
def list_views() in bigquery_etl/view/broken_views.py	17	16	5
def main() in sql/moz-fx-data-shared-prod/google_play_store_derived/slow_startup_events_by_startup_type_v1/query.py	128	16	0
def main() in sql/moz-fx-data-shared-prod/google_play_store_derived/slow_startup_events_by_startup_type_and_version_v1/query.py	116	16	0
def main() in bigquery_etl/glam/generate.py	215	15	0
def _clean_dict() in bigquery_etl/dsar/dsar_response.py	19	15	1
def has_changes() in bigquery_etl/view/__init__.py	50	15	3
def validate() in bigquery_etl/metadata/validate_metadata.py	33	14	1
def attach_metadata() in bigquery_etl/metadata/publish_metadata.py	36	14	2
def clean() in bigquery_etl/cli/stage.py	24	14	3
def create() in bigquery_etl/cli/query.py	99	14	7
def generate() in sql_generators/search_v2/__init__.py	110	13	3
def generate_queries() in sql_generators/experiment_monitoring/__init__.py	48	13	3
def _get_client_id_field() in bigquery_etl/shredder/config.py	19	13	3
def _gcp_convert_ndjson_to_json() in bigquery_etl/public_data/publish_json.py	56	13	2
def download_data_review_stats() in sql/moz-fx-data-shared-prod/telemetry_dev_cycle_external/data_review_stats_v1/query.py	89	13	2