GoogleCloudPlatform / bigquery-utils

Intro

Unit size measurements show the distribution of size of units of code (methods, functions...).
Units are classified in four categories based on their size (lines of code): 1-20 (small units), 20-50 (medium size units), 51-100 (long units), 101+ (very long units).
You should aim at keeping units small (< 20 lines). Long units may become "bloaters", code that have increased to such gargantuan proportions that they are hard to work with.

Learn more...

Unit Size Overall

There are 649 units with 7,238 lines of code in units (42.8% of code).

1 very long units (117 lines of code)
13 long units (847 lines of code)
64 medium size units (2,003 lines of code)
150 small units (2,187 lines of code)
421 very small units (2,084 lines of code)

Legend:

101+

51-100

21-50

11-20

1-10

Unit Size per Extension

101+

51-100

21-50

11-20

1-10

Unit Size per Logical Component

primary logical decomposition

101+

51-100

21-50

11-20

1-10

Alternative Visuals

3D view of all units

Longest Units

Top 50 longest units

Unit	# lines	McCabe index	# params
public static void main() in tools/query_breakdown/src/main/java/com/google/bigquery/Main.java	117	18	1
def legacy_sql_scan() in tools/legacy_sql_tranlsation_helper/patternScan.py	91	31	1
def backlog_subscriber() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/ordering.py	84	25	4
public int getNumColumns() in tools/template_based_query_generation/src/main/java/data/Table.java	81	20	0
public QueryRegex() in tools/template_based_query_generation/src/main/java/token/QueryRegex.java	79	21	2
public void generateQueries() in tools/template_based_query_generation/src/main/java/QueryGenerator.java	75	18	0
export function activate() in tools/vscode_automatic_query_fixer/src/extension.ts	62	4	1
def get_batches_for_gsurl() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py	58	15	3
public static void main() in tools/query_verification/src/main/java/com/google/bigquery/Main.java	57	14	1
def external_query() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py	54	11	6
export function activate() in tools/vscode_query_breakdown/src/extension.ts	53	4	1
def main() in tools/cloud_functions/gcs_event_based_ingest/backfill.py	51	10	1
def triage_event() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/main.py	51	10	5
public List parseResults() in tools/query_verification/src/main/java/com/google/bigquery/BigQueryManager.java	51	13	2
def parse_args() in tools/cloud_functions/gcs_event_based_ingest/backfill.py	50	1	1
private void loop() in tools/query_breakdown/src/main/java/com/google/bigquery/QueryBreakdown.java	48	12	5
export function activate() in tools/vscode_sql_extraction/src/extension.ts	46	2	1
function decorate() in tools/vscode_query_breakdown/src/extension.ts	45	4	1
public InputReader() in tools/query_breakdown/src/main/java/com/google/bigquery/InputReader.java	45	6	1
def handle_bq_lock() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py	43	5	5
fun process() in tools/sql_extraction/src/main/kotlin/SqlExtractor.kt	42	4	4
public SkeletonPiece tokenize() in tools/template_based_query_generation/src/main/java/token/TokenProvider.java	41	14	2
public static List readFromString() in tools/query_breakdown/src/main/java/com/google/bigquery/InputReader.java	41	7	1
grpc::Status ToGrpcStatus() in tools/zetasql_helper/zetasql_helper/local_service/local_service_grpc.cc	40	17	1
private List parseResults() in tools/query_verification/src/main/java/com/google/bigquery/TeradataManager.java	40	14	2
public IFixer getFixer() in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/FixerFactory.java	39	11	2
public static Options createOptions() in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/cmd/QueryFixerOptions.java	39	1	0
def wait_on_last_job() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/ordering.py	38	5	8
public LocationTracker replace() in tools/query_breakdown/src/main/java/com/google/bigquery/LocationTracker.java	38	14	6
public static void main() in tools/unsupervised_dataset/sql_classifier/classifier/src/main/java/Classifier.java	37	9	1
setFixes() in tools/vscode_automatic_query_fixer/src/code_action_provider.ts	36	5	2
public List generateDdlStatementsFromJsonSchema() in tools/query_verification/src/main/java/com/google/bigquery/TeradataManager.java	36	8	0
private List convert() in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/NoMatchingSignatureFixer.java	34	8	2
def start_backfill_subscriber_if_not_running() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/ordering.py	34	11	3
def main() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/main.py	34	11	2
public FixResult fix() in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/TableNotFoundFixer.java	33	4	0
def check_for_bq_job_and_children_errors() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py	33	9	4
public List run() in tools/query_breakdown/src/main/java/com/google/bigquery/QueryBreakdown.java	32	4	4
public List runQueries() in tools/query_verification/src/main/java/com/google/bigquery/TeradataManager.java	32	5	0
public static NoMatchingSignatureError parse() in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/NoMatchingSignatureError.java	31	6	1
public BigQuerySqlError getError() in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/SqlErrorFactory.java	31	10	1
def construct_config() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py	31	7	3
def get_table_prefix() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py	31	6	2
def create_job_id() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py	31	15	3
private static void exportToCsv() in tools/query_verification/src/main/java/com/google/bigquery/QueryVerifier.java	31	8	3
private void populateTablesFromData() in tools/query_verification/src/main/java/com/google/bigquery/TeradataManager.java	31	5	0
public List getTableInfoFromJsonSchema() in tools/query_verification/src/main/java/com/google/bigquery/BigQueryManager.java	31	8	0
public static void main() in tools/protobuf_export/Main.java	31	4	1
public static void main() in tools/custom_java_jdbc_client/src/main/java/com/example/BQSimbaExample.java	30	4	1
public static Options buildOptions() in tools/query_verification/src/main/java/com/google/bigquery/Main.java	30	1	0