duplicated block id: 1 size: 354 cleaned lines of code in 2 files: - views/audit/bigquery_audit_logs_v2.sql (18:430) - views/audit/bigquery_script_logs_v2.sql (18:430) duplicated block id: 2 size: 198 cleaned lines of code in 2 files: - views/audit/bigquery_audit_logs_v2.sql (666:925) - views/audit/bigquery_script_logs_v2.sql (450:709) duplicated block id: 3 size: 40 cleaned lines of code in 2 files: - scripts/optimization/actively_read_tables_with_partitioning_clustering_info.sql (82:121) - scripts/optimization/assured_workloads_compliant/actively_read_tables_with_partitioning_clustering_info.sql (64:103) duplicated block id: 4 size: 32 cleaned lines of code in 2 files: - dashboards/system_tables/sql/reservation_utilization_month.sql (32:70) - dashboards/system_tables/sql/reservation_utilization_week.sql (32:70) duplicated block id: 5 size: 28 cleaned lines of code in 2 files: - tools/vscode_automatic_query_fixer/src/auto_fixer_runner.ts (56:93) - tools/vscode_sql_extraction/src/sql_extraction_runner.ts (56:93) duplicated block id: 6 size: 19 cleaned lines of code in 2 files: - dashboards/system_tables/sql/job_concurrency_comparison_slow.sql (122:140) - dashboards/system_tables/sql/job_concurrency_comparison_slow.sql (179:197) duplicated block id: 7 size: 19 cleaned lines of code in 2 files: - scripts/optimization/queries_grouped_by_hash_org.sql (57:76) - scripts/optimization/queries_grouped_by_hash_project.sql (58:77) duplicated block id: 8 size: 18 cleaned lines of code in 2 files: - scripts/optimization/hourly_slot_consumption_by_labels.sql (51:69) - scripts/optimization/hourly_slot_consumption_by_query_hash.sql (48:65) duplicated block id: 9 size: 18 cleaned lines of code in 2 files: - tools/zetasql_helper/zetasql_helper/scanner/function_range.proto (1:21) - tools/zetasql_helper/zetasql_helper/token/parse_token.proto (1:21) duplicated block id: 10 size: 18 cleaned lines of code in 2 files: - views/audit/bigquery_audit_logs_v2.sql (642:659) - views/audit/bigquery_script_logs_v2.sql (431:449) duplicated block id: 11 size: 17 cleaned lines of code in 2 files: - release/terraform/main.tf (35:51) - release/terraform/main.tf (70:86) duplicated block id: 12 size: 16 cleaned lines of code in 2 files: - tools/zetasql_helper/zetasql_helper/local_service/local_service.proto (1:17) - tools/zetasql_helper/zetasql_helper/scanner/function_range.proto (1:17) duplicated block id: 13 size: 16 cleaned lines of code in 2 files: - tools/zetasql_helper/zetasql_helper/local_service/local_service.proto (1:17) - tools/zetasql_helper/zetasql_helper/token/parse_token.proto (1:17) duplicated block id: 14 size: 16 cleaned lines of code in 2 files: - scripts/optimization/hourly_slot_consumption_by_labels.sql (74:89) - scripts/optimization/hourly_slot_consumption_by_query_hash.sql (71:86) duplicated block id: 15 size: 16 cleaned lines of code in 2 files: - scripts/optimization/actively_read_tables_with_partitioning_clustering_info.sql (41:57) - scripts/optimization/assured_workloads_compliant/actively_read_tables_with_partitioning_clustering_info.sql (33:49) duplicated block id: 16 size: 15 cleaned lines of code in 2 files: - dashboards/system_tables/sql/job_concurrency_comparison_slow.sql (149:166) - dashboards/system_tables/sql/job_concurrency_comparison_slow.sql (205:222) duplicated block id: 17 size: 14 cleaned lines of code in 2 files: - scripts/optimization/actively_read_tables_with_partitioning_clustering_info.sql (25:39) - scripts/optimization/assured_workloads_compliant/actively_read_tables_with_partitioning_clustering_info.sql (18:32) duplicated block id: 18 size: 13 cleaned lines of code in 2 files: - scripts/optimization/hourly_slot_consumption_by_labels.sql (100:114) - scripts/optimization/hourly_slot_consumption_by_query_hash.sql (97:111) duplicated block id: 19 size: 13 cleaned lines of code in 2 files: - scripts/optimization/assured_workloads_compliant/actively_read_tables_with_partitioning_clustering_info.sql (74:86) - scripts/optimization/tables_without_partitioning_or_clustering.sql (73:85) duplicated block id: 20 size: 13 cleaned lines of code in 2 files: - scripts/optimization/actively_read_tables_with_partitioning_clustering_info.sql (92:104) - scripts/optimization/tables_without_partitioning_or_clustering.sql (73:85) duplicated block id: 21 size: 13 cleaned lines of code in 2 files: - dashboards/system_tables/sql/reservation_utilization_month.sql (78:93) - dashboards/system_tables/sql/reservation_utilization_week.sql (83:98) duplicated block id: 22 size: 12 cleaned lines of code in 2 files: - scripts/optimization/actively_read_tables_with_partitioning_clustering_info.sql (68:79) - scripts/optimization/assured_workloads_compliant/actively_read_tables_with_partitioning_clustering_info.sql (51:62) duplicated block id: 23 size: 11 cleaned lines of code in 2 files: - scripts/optimization/queries_grouped_by_hash_org.sql (48:58) - scripts/optimization/queries_grouped_by_labels.sql (13:23) duplicated block id: 24 size: 11 cleaned lines of code in 2 files: - views/audit/bigquery_audit_logs_v1.sql (27:37) - views/audit/query_audit.sql (19:29) duplicated block id: 25 size: 11 cleaned lines of code in 2 files: - scripts/optimization/queries_grouped_by_hash_org.sql (45:55) - scripts/optimization/queries_grouped_by_hash_project.sql (45:55) duplicated block id: 26 size: 10 cleaned lines of code in 2 files: - tools/vscode_automatic_query_fixer/src/auto_fixer_runner.ts (24:35) - tools/vscode_sql_extraction/src/sql_extraction_runner.ts (29:40) duplicated block id: 27 size: 10 cleaned lines of code in 2 files: - tools/template_based_query_generation/src/main/java/data/Table.java (68:81) - tools/template_based_query_generation/src/main/java/data/Table.java (89:102) duplicated block id: 28 size: 10 cleaned lines of code in 2 files: - scripts/optimization/assured_workloads_compliant/actively_read_tables_with_partitioning_clustering_info.sql (36:46) - scripts/optimization/tables_without_partitioning_or_clustering.sql (47:57) duplicated block id: 29 size: 10 cleaned lines of code in 2 files: - views/audit/bigquery_audit_logs_v1.sql (66:75) - views/audit/query_audit.sql (49:58) duplicated block id: 30 size: 10 cleaned lines of code in 2 files: - dashboards/system_tables/sql/current_assignments.sql (34:46) - dashboards/system_tables/sql/reservation_utilization_week.sql (57:69) duplicated block id: 31 size: 10 cleaned lines of code in 2 files: - scripts/optimization/actively_read_tables_with_partitioning_clustering_info.sql (44:54) - scripts/optimization/tables_without_partitioning_or_clustering.sql (47:57) duplicated block id: 32 size: 10 cleaned lines of code in 2 files: - dashboards/system_tables/sql/current_assignments.sql (34:46) - dashboards/system_tables/sql/reservation_utilization_month.sql (57:69) duplicated block id: 33 size: 9 cleaned lines of code in 2 files: - scripts/optimization/assured_workloads_compliant/actively_read_tables_with_partitioning_clustering_info.sql (38:47) - scripts/optimization/viewable_queries_grouped_by_hash.sql (71:80) duplicated block id: 34 size: 9 cleaned lines of code in 2 files: - scripts/optimization/hourly_slot_consumption_by_labels.sql (117:127) - scripts/optimization/hourly_slot_consumption_by_query_hash.sql (118:128) duplicated block id: 35 size: 9 cleaned lines of code in 2 files: - scripts/optimization/actively_read_tables_with_partitioning_clustering_info.sql (46:55) - scripts/optimization/viewable_queries_grouped_by_hash.sql (71:80) duplicated block id: 36 size: 9 cleaned lines of code in 2 files: - tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/AutomaticQueryFixer.java (67:80) - tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/AutomaticQueryFixer.java (92:105) duplicated block id: 37 size: 9 cleaned lines of code in 2 files: - views/audit/bigquery_audit_logs_v1.sql (87:96) - views/audit/query_audit.sql (60:70) duplicated block id: 38 size: 8 cleaned lines of code in 2 files: - scripts/optimization/queries_grouped_by_hash_org.sql (34:43) - scripts/optimization/queries_grouped_by_hash_project.sql (34:43) duplicated block id: 39 size: 8 cleaned lines of code in 2 files: - tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py (761:768) - tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py (798:805) duplicated block id: 40 size: 8 cleaned lines of code in 2 files: - scripts/optimization/hourly_slot_consumption_by_labels.sql (91:98) - scripts/optimization/hourly_slot_consumption_by_query_hash.sql (87:94) duplicated block id: 41 size: 8 cleaned lines of code in 2 files: - scripts/optimization/hourly_slot_consumption_by_labels.sql (35:42) - scripts/optimization/hourly_slot_consumption_by_query_hash.sql (35:42) duplicated block id: 42 size: 8 cleaned lines of code in 2 files: - scripts/optimization/tables_without_partitioning_or_clustering.sql (49:57) - scripts/optimization/viewable_queries_grouped_by_hash.sql (71:79) duplicated block id: 43 size: 8 cleaned lines of code in 2 files: - scripts/optimization/actively_read_tables_with_partitioning_clustering_info.sql (48:55) - scripts/optimization/table_read_patterns.sql (99:106) duplicated block id: 44 size: 8 cleaned lines of code in 2 files: - tools/sql_extraction/src/main/kotlin/SqlExtractor.kt (50:57) - tools/sql_extraction/src/main/kotlin/SqlExtractor.kt (60:67) duplicated block id: 45 size: 8 cleaned lines of code in 2 files: - tools/vscode_automatic_query_fixer/copy_binaries.js (19:30) - tools/vscode_sql_extraction/copy_binaries.js (21:32) duplicated block id: 46 size: 8 cleaned lines of code in 2 files: - scripts/optimization/queries_grouped_by_hash_project.sql (48:55) - scripts/optimization/queries_grouped_by_labels.sql (13:20) duplicated block id: 47 size: 8 cleaned lines of code in 2 files: - scripts/optimization/table_read_patterns.sql (99:106) - scripts/optimization/viewable_queries_grouped_by_hash.sql (73:80) duplicated block id: 48 size: 8 cleaned lines of code in 2 files: - tools/query_breakdown/src/main/java/com/google/bigquery/InputReader.java (69:77) - tools/query_breakdown/src/main/java/com/google/bigquery/InputReader.java (130:138) duplicated block id: 49 size: 8 cleaned lines of code in 2 files: - scripts/optimization/assured_workloads_compliant/actively_read_tables_with_partitioning_clustering_info.sql (40:47) - scripts/optimization/table_read_patterns.sql (99:106) duplicated block id: 50 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 51 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) duplicated block id: 52 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) duplicated block id: 53 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) duplicated block id: 54 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 55 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) duplicated block id: 56 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 57 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 58 size: 7 cleaned lines of code in 2 files: - scripts/optimization/actively_read_tables_with_partitioning_clustering_info.sql (48:54) - scripts/optimization/views_with_nonoptimal_join_condition.sql (48:54) duplicated block id: 59 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) duplicated block id: 60 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) duplicated block id: 61 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 62 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) duplicated block id: 63 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) duplicated block id: 64 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) duplicated block id: 65 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) duplicated block id: 66 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) duplicated block id: 67 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) duplicated block id: 68 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) duplicated block id: 69 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) duplicated block id: 70 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) duplicated block id: 71 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) duplicated block id: 72 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 73 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 74 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) duplicated block id: 75 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) duplicated block id: 76 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) duplicated block id: 77 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) duplicated block id: 78 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) duplicated block id: 79 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) duplicated block id: 80 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) duplicated block id: 81 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) duplicated block id: 82 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) duplicated block id: 83 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 84 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 85 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) duplicated block id: 86 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) duplicated block id: 87 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 88 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) duplicated block id: 89 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 90 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (644:650) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (873:879) duplicated block id: 91 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 92 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 93 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (644:650) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (862:868) duplicated block id: 94 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) duplicated block id: 95 size: 7 cleaned lines of code in 2 files: - scripts/optimization/assured_workloads_compliant/actively_read_tables_with_partitioning_clustering_info.sql (40:46) - scripts/optimization/views_with_nonoptimal_join_condition.sql (48:54) duplicated block id: 96 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) duplicated block id: 97 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) duplicated block id: 98 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 99 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 100 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) duplicated block id: 101 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 102 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) duplicated block id: 103 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) duplicated block id: 104 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) duplicated block id: 105 size: 7 cleaned lines of code in 2 files: - scripts/optimization/queries_grouped_by_hash_project.sql (34:41) - scripts/optimization/queries_grouped_by_labels.sql (1:8) duplicated block id: 106 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) duplicated block id: 107 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) duplicated block id: 108 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 109 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) duplicated block id: 110 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 111 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 112 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) duplicated block id: 113 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 114 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) duplicated block id: 115 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) duplicated block id: 116 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) duplicated block id: 117 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) duplicated block id: 118 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) duplicated block id: 119 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 120 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) duplicated block id: 121 size: 7 cleaned lines of code in 2 files: - tools/query_verification/src/main/java/com/google/bigquery/BigQueryManager.java (207:216) - tools/query_verification/src/main/java/com/google/bigquery/TeradataManager.java (196:205) duplicated block id: 122 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) duplicated block id: 123 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 124 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 125 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (517:523) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (723:729) duplicated block id: 126 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) duplicated block id: 127 size: 7 cleaned lines of code in 2 files: - tools/query_verification/src/main/java/com/google/bigquery/BigQueryManager.java (61:71) - tools/query_verification/src/main/java/com/google/bigquery/BigQueryManager.java (115:125) duplicated block id: 128 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) duplicated block id: 129 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 130 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 131 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) duplicated block id: 132 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) duplicated block id: 133 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) duplicated block id: 134 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) duplicated block id: 135 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (161:167) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (959:965) duplicated block id: 136 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) duplicated block id: 137 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 138 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 139 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) duplicated block id: 140 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) duplicated block id: 141 size: 7 cleaned lines of code in 2 files: - tools/vscode_automatic_query_fixer/src/extension.ts (6:12) - tools/vscode_sql_extraction/src/extension.ts (9:15) duplicated block id: 142 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 143 size: 7 cleaned lines of code in 2 files: - scripts/optimization/table_read_patterns.sql (99:105) - scripts/optimization/tables_without_partitioning_or_clustering.sql (51:57) duplicated block id: 144 size: 7 cleaned lines of code in 2 files: - scripts/optimization/tables_without_partitioning_or_clustering.sql (51:57) - scripts/optimization/views_with_nonoptimal_join_condition.sql (48:54) duplicated block id: 145 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) duplicated block id: 146 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) duplicated block id: 147 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) duplicated block id: 148 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) duplicated block id: 149 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) duplicated block id: 150 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 151 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) duplicated block id: 152 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 153 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) duplicated block id: 154 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 155 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 156 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 157 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) duplicated block id: 158 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (633:639) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (723:729) duplicated block id: 159 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) duplicated block id: 160 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (862:868) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (873:879) duplicated block id: 161 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) duplicated block id: 162 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 163 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 164 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) duplicated block id: 165 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) duplicated block id: 166 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) duplicated block id: 167 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 168 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) duplicated block id: 169 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 170 size: 7 cleaned lines of code in 2 files: - scripts/optimization/queries_grouped_by_hash_org.sql (34:41) - scripts/optimization/queries_grouped_by_labels.sql (1:8) duplicated block id: 171 size: 7 cleaned lines of code in 2 files: - scripts/optimization/viewable_queries_grouped_by_hash.sql (73:79) - scripts/optimization/views_with_nonoptimal_join_condition.sql (48:54) duplicated block id: 172 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 173 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 174 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 175 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) duplicated block id: 176 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) duplicated block id: 177 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 178 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 179 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) duplicated block id: 180 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 181 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) duplicated block id: 182 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) duplicated block id: 183 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) duplicated block id: 184 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) duplicated block id: 185 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) duplicated block id: 186 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (723:729) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (862:868) duplicated block id: 187 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) duplicated block id: 188 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) duplicated block id: 189 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 190 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) duplicated block id: 191 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) duplicated block id: 192 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (723:729) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (873:879) duplicated block id: 193 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 194 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) duplicated block id: 195 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) duplicated block id: 196 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) duplicated block id: 197 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) duplicated block id: 198 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) duplicated block id: 199 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) duplicated block id: 200 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 201 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) duplicated block id: 202 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) duplicated block id: 203 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) duplicated block id: 204 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) duplicated block id: 205 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (644:650) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (723:729) duplicated block id: 206 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 207 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 208 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) duplicated block id: 209 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) duplicated block id: 210 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) duplicated block id: 211 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) duplicated block id: 212 size: 7 cleaned lines of code in 2 files: - dashboards/system_tables/sql/current_assignments.sql (47:53) - dashboards/system_tables/sql/current_assignments.sql (60:66) duplicated block id: 213 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) duplicated block id: 214 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) duplicated block id: 215 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) duplicated block id: 216 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) duplicated block id: 217 size: 7 cleaned lines of code in 2 files: - tools/sql_extraction/src/main/kotlin/JavaAnalyzer.kt (194:200) - tools/sql_extraction/src/main/kotlin/PythonAnalyzer.kt (160:166) duplicated block id: 218 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) duplicated block id: 219 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) duplicated block id: 220 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) duplicated block id: 221 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) duplicated block id: 222 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 223 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) duplicated block id: 224 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) duplicated block id: 225 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 226 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 227 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) duplicated block id: 228 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 229 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) duplicated block id: 230 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) duplicated block id: 231 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) duplicated block id: 232 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) duplicated block id: 233 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 234 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) duplicated block id: 235 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) duplicated block id: 236 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) duplicated block id: 237 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) duplicated block id: 238 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (308:314) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (330:336) duplicated block id: 239 size: 7 cleaned lines of code in 2 files: - dashboards/system_tables/sql/job_concurrency_comparison_slow.sql (56:65) - dashboards/system_tables/sql/job_concurrency_comparison_slow.sql (83:92) duplicated block id: 240 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) duplicated block id: 241 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) duplicated block id: 242 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 243 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 244 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 245 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) duplicated block id: 246 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) duplicated block id: 247 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) duplicated block id: 248 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 249 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) duplicated block id: 250 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) duplicated block id: 251 size: 7 cleaned lines of code in 2 files: - scripts/optimization/table_read_patterns.sql (99:105) - scripts/optimization/views_with_nonoptimal_join_condition.sql (48:54) duplicated block id: 252 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) duplicated block id: 253 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 254 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 255 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 256 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) duplicated block id: 257 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) duplicated block id: 258 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 259 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) duplicated block id: 260 size: 7 cleaned lines of code in 2 files: - dashboards/system_tables/sql/job_concurrency_comparison_slow.sql (114:120) - dashboards/system_tables/sql/job_concurrency_comparison_slow.sql (171:177) duplicated block id: 261 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) duplicated block id: 262 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) duplicated block id: 263 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 264 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 265 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 266 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 267 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) duplicated block id: 268 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) duplicated block id: 269 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 270 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) duplicated block id: 271 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) duplicated block id: 272 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) duplicated block id: 273 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) duplicated block id: 274 size: 7 cleaned lines of code in 2 files: - scripts/optimization/queries_grouped_by_hash_org.sql (78:84) - scripts/optimization/queries_grouped_by_hash_project.sql (79:85) duplicated block id: 275 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) duplicated block id: 276 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 277 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (633:639) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (873:879) duplicated block id: 278 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) duplicated block id: 279 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) duplicated block id: 280 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (892:898) duplicated block id: 281 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) duplicated block id: 282 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (319:325) duplicated block id: 283 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) duplicated block id: 284 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (550:556) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 285 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) duplicated block id: 286 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (633:639) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (862:868) duplicated block id: 287 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 288 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) duplicated block id: 289 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (210:216) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (297:303) duplicated block id: 290 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) duplicated block id: 291 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 292 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) duplicated block id: 293 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) duplicated block id: 294 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 295 size: 7 cleaned lines of code in 2 files: - scripts/optimization/queries_grouped_by_hash_org.sql (77:83) - scripts/optimization/queries_grouped_by_labels.sql (33:39) duplicated block id: 296 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) duplicated block id: 297 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (517:523) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (873:879) duplicated block id: 298 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (517:523) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (633:639) duplicated block id: 299 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (528:534) duplicated block id: 300 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (410:416) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 301 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (268:274) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 302 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (692:698) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 303 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (517:523) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (862:868) duplicated block id: 304 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (495:501) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) duplicated block id: 305 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (22:28) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) duplicated block id: 306 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (361:367) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) duplicated block id: 307 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (656:662) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (776:782) duplicated block id: 308 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (585:591) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) duplicated block id: 309 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (741:747) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (823:829) duplicated block id: 310 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (341:347) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) duplicated block id: 311 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (451:457) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (925:931) duplicated block id: 312 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (517:523) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (644:650) duplicated block id: 313 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (633:639) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (644:650) duplicated block id: 314 size: 7 cleaned lines of code in 2 files: - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (234:240) - dashboards/geospatial/bigquery_geospatial_visualization.ipynb (386:392) duplicated block id: 315 size: 6 cleaned lines of code in 2 files: - scripts/optimization/actively_read_tables_with_partitioning_clustering_info.sql (71:76) - scripts/optimization/tables_without_partitioning_or_clustering.sql (69:74) duplicated block id: 316 size: 6 cleaned lines of code in 2 files: - tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py (226:232) - tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py (252:258) duplicated block id: 317 size: 6 cleaned lines of code in 2 files: - tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/ordering.py (118:123) - tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/ordering.py (324:329) duplicated block id: 318 size: 6 cleaned lines of code in 2 files: - tools/vscode_automatic_query_fixer/src/auto_fixer_runner.ts (44:49) - tools/vscode_sql_extraction/src/sql_extraction_runner.ts (49:54) duplicated block id: 319 size: 6 cleaned lines of code in 2 files: - scripts/billing/sql/daily_compute_discount.sql (7:12) - scripts/billing/sql/daily_compute_usage_hours.sql (11:16) duplicated block id: 320 size: 6 cleaned lines of code in 2 files: - dashboards/system_tables/sql/reservation_utilization_month.sql (98:103) - dashboards/system_tables/sql/reservation_utilization_week.sql (103:108) duplicated block id: 321 size: 6 cleaned lines of code in 2 files: - scripts/optimization/queries_grouped_by_hash_project.sql (79:84) - scripts/optimization/queries_grouped_by_labels.sql (34:39) duplicated block id: 322 size: 6 cleaned lines of code in 2 files: - tools/vscode_sql_extraction/src/sql_extraction_runner.ts (21:26) - tools/vscode_sql_extraction/src/sql_extraction_runner.ts (36:41) duplicated block id: 323 size: 6 cleaned lines of code in 2 files: - scripts/optimization/table_read_patterns.sql (118:123) - scripts/optimization/table_read_patterns.sql (158:163) duplicated block id: 324 size: 6 cleaned lines of code in 2 files: - tools/vscode_automatic_query_fixer/src/auto_fixer_runner.ts (16:21) - tools/vscode_automatic_query_fixer/src/auto_fixer_runner.ts (31:36) duplicated block id: 325 size: 6 cleaned lines of code in 2 files: - scripts/optimization/hourly_slot_consumption_by_labels.sql (21:26) - scripts/optimization/hourly_slot_consumption_by_query_hash.sql (21:26) duplicated block id: 326 size: 6 cleaned lines of code in 2 files: - tools/cloud_functions/gcs_event_based_ingest/cloudbuild.yaml (69:74) - tools/cloud_functions/gcs_event_based_ingest/cloudbuild.yaml (77:82) duplicated block id: 327 size: 6 cleaned lines of code in 2 files: - scripts/billing/sql/daily_compute_usage_cud_sud_coverage.sql (79:85) - scripts/billing/sql/daily_compute_usage_cud_sud_coverage.sql (90:96) duplicated block id: 328 size: 6 cleaned lines of code in 2 files: - scripts/optimization/assured_workloads_compliant/actively_read_tables_with_partitioning_clustering_info.sql (54:59) - scripts/optimization/tables_without_partitioning_or_clustering.sql (69:74)