GoogleCloudPlatform / bigquery-utils

Duplication

Places in code with 6 or more lines that are exactly the same.

Longest Duplicates

The list of 50 longest duplicates.

See data for all 328 duplicates...

Size	#	Folders	Files	Lines	Code
354	x 2	views/audit views/audit	bigquery_audit_logs_v2.sql bigquery_script_logs_v2.sql	18:430 (42%) 18:430 (61%)	view
198	x 2	views/audit views/audit	bigquery_audit_logs_v2.sql bigquery_script_logs_v2.sql	666:925 (23%) 450:709 (34%)	view
40	x 2	scripts/optimization scripts/optimization/assured_workloads_compliant	actively_read_tables_with_partitionin... actively_read_tables_with_partitionin...	82:121 (42%) 64:103 (47%)	view
32	x 2	dashboards/system_tables/sql dashboards/system_tables/sql	reservation_utilization_month.sql reservation_utilization_week.sql	32:70 (54%) 32:70 (50%)	view
28	x 2	tools/vscode_automatic_query_fixer/src tools/vscode_sql_extraction/src	auto_fixer_runner.ts sql_extraction_runner.ts	56:93 (43%) 56:93 (45%)	view
19	x 2	dashboards/system_tables/sql dashboards/system_tables/sql	job_concurrency_comparison_slow.sql job_concurrency_comparison_slow.sql	122:140 (10%) 179:197 (10%)	view
19	x 2	scripts/optimization scripts/optimization	queries_grouped_by_hash_org.sql queries_grouped_by_hash_project.sql	57:76 (39%) 58:77 (38%)	view
18	x 2	scripts/optimization scripts/optimization	hourly_slot_consumption_by_labels.sql hourly_slot_consumption_by_query_hash...	51:69 (15%) 48:65 (15%)	view
18	x 2	tools/zetasql_helper/zetasql_helper/scanner tools/zetasql_helper/zetasql_helper/token	proto function_range.proto parse_token.proto	1:21 (75%) 1:21 (52%)	view
18	x 2	views/audit views/audit	bigquery_audit_logs_v2.sql bigquery_script_logs_v2.sql	642:659 (2%) 431:449 (3%)	view
17	x 2	release/terraform release/terraform	main.tf main.tf	35:51 (9%) 70:86 (9%)	view
16	x 2	tools/zetasql_helper/zetasql_helper/local_service tools/zetasql_helper/zetasql_helper/scanner	proto local_service.proto function_range.proto	1:17 (17%) 1:17 (66%)	view
16	x 2	tools/zetasql_helper/zetasql_helper/local_service tools/zetasql_helper/zetasql_helper/token	proto local_service.proto parse_token.proto	1:17 (17%) 1:17 (47%)	view
16	x 2	scripts/optimization scripts/optimization	hourly_slot_consumption_by_labels.sql hourly_slot_consumption_by_query_hash...	74:89 (13%) 71:86 (13%)	view
16	x 2	scripts/optimization scripts/optimization/assured_workloads_compliant	actively_read_tables_with_partitionin... actively_read_tables_with_partitionin...	41:57 (16%) 33:49 (19%)	view
15	x 2	dashboards/system_tables/sql dashboards/system_tables/sql	job_concurrency_comparison_slow.sql job_concurrency_comparison_slow.sql	149:166 (8%) 205:222 (8%)	view
14	x 2	scripts/optimization scripts/optimization/assured_workloads_compliant	actively_read_tables_with_partitionin... actively_read_tables_with_partitionin...	25:39 (14%) 18:32 (16%)	view
13	x 2	scripts/optimization scripts/optimization	hourly_slot_consumption_by_labels.sql hourly_slot_consumption_by_query_hash...	100:114 (11%) 97:111 (10%)	view
13	x 2	scripts/optimization/assured_workloads_compliant scripts/optimization	actively_read_tables_with_partitionin... tables_without_partitioning_or_cluste...	74:86 (15%) 73:85 (17%)	view
13	x 2	scripts/optimization scripts/optimization	actively_read_tables_with_partitionin... tables_without_partitioning_or_cluste...	92:104 (13%) 73:85 (17%)	view
13	x 2	dashboards/system_tables/sql dashboards/system_tables/sql	reservation_utilization_month.sql reservation_utilization_week.sql	78:93 (22%) 83:98 (20%)	view
12	x 2	scripts/optimization scripts/optimization/assured_workloads_compliant	actively_read_tables_with_partitionin... actively_read_tables_with_partitionin...	68:79 (12%) 51:62 (14%)	view
11	x 2	scripts/optimization scripts/optimization	queries_grouped_by_hash_org.sql queries_grouped_by_labels.sql	48:58 (22%) 13:23 (28%)	view
11	x 2	views/audit views/audit	bigquery_audit_logs_v1.sql query_audit.sql	27:37 (6%) 19:29 (9%)	view
11	x 2	scripts/optimization scripts/optimization	queries_grouped_by_hash_org.sql queries_grouped_by_hash_project.sql	45:55 (22%) 45:55 (22%)	view
10	x 2	tools/vscode_automatic_query_fixer/src tools/vscode_sql_extraction/src	auto_fixer_runner.ts sql_extraction_runner.ts	24:35 (15%) 29:40 (16%)	view
10	x 2	tools/template_based_que...tion/src/main/java/data tools/template_based_que...tion/src/main/java/data	Table.java Table.java	68:81 (12%) 89:102 (12%)	view
10	x 2	scripts/optimization/assured_workloads_compliant scripts/optimization	actively_read_tables_with_partitionin... tables_without_partitioning_or_cluste...	36:46 (11%) 47:57 (13%)	view
10	x 2	views/audit views/audit	bigquery_audit_logs_v1.sql query_audit.sql	66:75 (6%) 49:58 (8%)	view
10	x 2	dashboards/system_tables/sql dashboards/system_tables/sql	current_assignments.sql reservation_utilization_week.sql	34:46 (29%) 57:69 (15%)	view
10	x 2	scripts/optimization scripts/optimization	actively_read_tables_with_partitionin... tables_without_partitioning_or_cluste...	44:54 (10%) 47:57 (13%)	view
10	x 2	dashboards/system_tables/sql dashboards/system_tables/sql	current_assignments.sql reservation_utilization_month.sql	34:46 (29%) 57:69 (16%)	view
9	x 2	scripts/optimization/assured_workloads_compliant scripts/optimization	actively_read_tables_with_partitionin... viewable_queries_grouped_by_hash.sql	38:47 (10%) 71:80 (6%)	view
9	x 2	scripts/optimization scripts/optimization	hourly_slot_consumption_by_labels.sql hourly_slot_consumption_by_query_hash...	117:127 (7%) 118:128 (7%)	view
9	x 2	scripts/optimization scripts/optimization	actively_read_tables_with_partitionin... viewable_queries_grouped_by_hash.sql	46:55 (9%) 71:80 (6%)	view
9	x 2	tools/automatic_query_fi...gquery/utils/queryfixer tools/automatic_query_fi...gquery/utils/queryfixer	AutomaticQueryFixer.java AutomaticQueryFixer.java	67:80 (13%) 92:105 (13%)	view
9	x 2	views/audit views/audit	bigquery_audit_logs_v1.sql query_audit.sql	87:96 (5%) 60:70 (7%)	view
8	x 2	scripts/optimization scripts/optimization	queries_grouped_by_hash_org.sql queries_grouped_by_hash_project.sql	34:43 (16%) 34:43 (16%)	view
8	x 2	tools/cloud_functions/gc...cs_ocn_bq_ingest/common tools/cloud_functions/gc...cs_ocn_bq_ingest/common	utils.py utils.py	761:768 (1%) 798:805 (1%)	view
8	x 2	scripts/optimization scripts/optimization	hourly_slot_consumption_by_labels.sql hourly_slot_consumption_by_query_hash...	91:98 (6%) 87:94 (6%)	view
8	x 2	scripts/optimization scripts/optimization	hourly_slot_consumption_by_labels.sql hourly_slot_consumption_by_query_hash...	35:42 (6%) 35:42 (6%)	view
8	x 2	scripts/optimization scripts/optimization	tables_without_partitioning_or_cluste... viewable_queries_grouped_by_hash.sql	49:57 (10%) 71:79 (6%)	view
8	x 2	scripts/optimization scripts/optimization	actively_read_tables_with_partitionin... table_read_patterns.sql	48:55 (8%) 99:106 (4%)	view
8	x 2	tools/sql_extraction/src/main/kotlin tools/sql_extraction/src/main/kotlin	SqlExtractor.kt SqlExtractor.kt	50:57 (10%) 60:67 (10%)	view
8	x 2	tools/vscode_automatic_query_fixer tools/vscode_sql_extraction	copy_binaries.js copy_binaries.js	19:30 (28%) 21:32 (26%)	view
8	x 2	scripts/optimization scripts/optimization	queries_grouped_by_hash_project.sql queries_grouped_by_labels.sql	48:55 (16%) 13:20 (20%)	view
8	x 2	scripts/optimization scripts/optimization	table_read_patterns.sql viewable_queries_grouped_by_hash.sql	99:106 (4%) 73:80 (6%)	view
8	x 2	tools/query_breakdown/sr...ava/com/google/bigquery tools/query_breakdown/sr...ava/com/google/bigquery	InputReader.java InputReader.java	69:77 (9%) 130:138 (9%)	view
8	x 2	scripts/optimization/assured_workloads_compliant scripts/optimization	actively_read_tables_with_partitionin... table_read_patterns.sql	40:47 (9%) 99:106 (4%)	view
7	x 2	dashboards/geospatial dashboards/geospatial	bigquery_geospatial_visualization.ipynb bigquery_geospatial_visualization.ipynb	210:216 (<1%) 892:898 (<1%)	view