GoogleCloudPlatform / bigquery-utils
File Change Frequency

File change frequency (churn) shows the distribution of file updates (days with at least one commit).

Overview
File Change Frequency Overall
  • There are 277 files with 16,901 lines of code.
    • 0 files changed more than 100 times (0 lines of code)
    • 0 files changed 51-100 times (0 lines of code)
    • 0 files changed 21-50 times (0 lines of code)
    • 15 files changed 6-20 times (1,867 lines of code)
    • 262 files changed 1-5 times (15,034 lines of code)
0% | 0% | 0% | 11% | 88%
Legend:
101+
51-100
21-50
6-20
1-5

explore: grouped by folders | grouped by update frequency | data
Contributors Count Frequency Overall
  • There are 277 files with 16,901 lines of code.
    • 0 files changed by more than 25 contributors (0 lines of code)
    • 0 files changed by 11-25 contributors (0 lines of code)
    • 0 files changed by 6-10 contributors (0 lines of code)
    • 57 files changed by 2-5 contributors (5,085 lines of code)
    • 220 files changed by 1 contributor (11,816 lines of code)
0% | 0% | 0% | 30% | 69%
Legend:
26+
11-25
6-10
2-5
1

explore: grouped by folders | grouped by contributors count | data
File Change Frequency per File Extension
java, sql, md, json, py, js, kt, txt, ts, gitignore, sh, yaml, cc, tf, h, properties, xml, svg, ipynb, proto, vscodeignore, patch, bat, html, ini, kts, gradle, gitattributes, dockerignore, hcl, tfvars, cpp, cfg, go
File Change Frequency per Extension
The number of recorded file updates
101+
51-100
21-50
6-20
1-5
java0% | 0% | 0% | 21% | 78%
kt0% | 0% | 0% | 19% | 80%
tf0% | 0% | 0% | 31% | 68%
py0% | 0% | 0% | 6% | 93%
yaml0% | 0% | 0% | 28% | 71%
sql0% | 0% | 0% | 0% | 100%
ipynb0% | 0% | 0% | 0% | 100%
ts0% | 0% | 0% | 0% | 100%
cc0% | 0% | 0% | 0% | 100%
h0% | 0% | 0% | 0% | 100%
proto0% | 0% | 0% | 0% | 100%
js0% | 0% | 0% | 0% | 100%
kts0% | 0% | 0% | 0% | 100%
go0% | 0% | 0% | 0% | 100%
tfvars0% | 0% | 0% | 0% | 100%
File Change Frequency per Logical Decomposition
primary
primary (file change frequency)
The number of recorded file updates
101+
51-100
21-50
6-20
1-5
tools0% | 0% | 0% | 14% | 85%
release0% | 0% | 0% | 73% | 26%
udfs0% | 0% | 0% | 48% | 51%
ROOT0% | 0% | 0% | 100% | 0%
scripts0% | 0% | 0% | 0% | 100%
views0% | 0% | 0% | 0% | 100%
dashboards0% | 0% | 0% | 0% | 100%
performance_testing0% | 0% | 0% | 0% | 100%
stored_procedures0% | 0% | 0% | 0% | 100%
Most Frequently Changed Files (Top 50)

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
56 - 2020-04-07 2024-09-30 11 4 danieldeleo@users.noreply.g... danieldeleo@users.noreply.g...
28 - 2020-04-14 2024-09-30 9 3 danieldeleo@users.noreply.g... danieldeleo@users.noreply.g...
Main.java
in tools/query_breakdown/src/main/java/com/google/bigquery
 163 3 2020-07-24 2021-12-14 9 2 subinlee@google.com zihaoye@google.com
Cli.kt
in tools/sql_extraction/src/main/kotlin
 104 1 2020-06-16 2020-08-14 8 1 gahwon@google.com gahwon@google.com
QueryVerifier.java
in tools/query_verification/src/main/java/com/google/bigquery
 160 10 2020-07-06 2020-08-14 8 2 krish@suchdev.com krishsuchdev@google.com
QueryBreakdown.java
in tools/query_breakdown/src/main/java/com/google/bigquery
 189 9 2020-07-24 2020-09-11 8 1 subinlee@google.com subinlee@google.com
Utils.java
in tools/template_based_query_generation/src/main/java/parser
 282 23 2020-07-21 2020-09-01 8 2 waallen@google.com 44599941+spoiledhua@users.n...
main.py
in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest
 127 5 2020-11-11 2021-10-12 7 2 jferriero@google.com danieldeleo@users.noreply.g...
QueryGenerator.java
in tools/template_based_query_generation/src/main/java
 132 2 2020-07-13 2020-09-01 7 2 44599941+spoiledhua@users.n... 44599941+spoiledhua@users.n...
main.tf
in release/terraform
 171 - 2024-05-07 2025-03-12 7 3 86309184+afleisc@users.nore... danieldeleo@users.noreply.g...
ReplacementLogic.java
in tools/query_breakdown/src/main/java/com/google/bigquery
 35 2 2020-07-24 2020-09-11 6 1 subinlee@google.com subinlee@google.com
SqlExtractor.kt
in tools/sql_extraction/src/main/kotlin
 95 1 2020-06-18 2020-08-14 6 1 gahwon@google.com gahwon@google.com
TableNotFoundFixer.java
in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer
 105 6 2020-08-06 2020-09-04 6 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
InputReader.java
in tools/query_breakdown/src/main/java/com/google/bigquery
 106 5 2020-07-24 2020-09-11 6 1 subinlee@google.com subinlee@google.com
Table.java
in tools/template_based_query_generation/src/main/java/data
 114 7 2020-07-21 2020-09-01 6 2 waallen@google.com 44599941+spoiledhua@users.n...
16 - 2021-09-24 2024-09-30 5 2 danieldeleo@users.noreply.g... danieldeleo@users.noreply.g...
FixerFactory.java
in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer
 49 1 2020-08-06 2020-09-04 5 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
Node.java
in tools/query_breakdown/src/main/java/com/google/bigquery
 80 7 2020-07-24 2020-09-11 5 1 subinlee@google.com subinlee@google.com
build.gradle.kts
in tools/sql_extraction
 86 - 2020-06-10 2020-08-14 5 2 creativitry@gmail.com gahwon@google.com
extension.ts
in tools/vscode_query_breakdown/src
 109 2 2020-08-05 2020-09-11 5 1 subinlee@google.com subinlee@google.com
main.tf
in tools/cloud_functions/gcs_event_based_ingest/terraform_module/gcs_ocn_bq_ingest_function
 110 - 2020-11-11 2021-10-12 5 2 jferriero@google.com danieldeleo@users.noreply.g...
LocationTracker.java
in tools/query_breakdown/src/main/java/com/google/bigquery
 113 10 2020-08-04 2020-09-11 5 1 subinlee@google.com subinlee@google.com
DataFlowEngine.kt
in tools/sql_extraction/src/main/kotlin
 156 14 2020-06-18 2020-08-07 5 1 gahwon@google.com gahwon@google.com
outputs.tf
in tools/cloud_functions/gcs_event_based_ingest/terraform_module/gcs_ocn_bq_ingest_function
 11 - 2020-11-11 2021-03-31 4 1 jferriero@google.com jferriero@google.com
DataFlowSolver.kt
in tools/sql_extraction/src/main/kotlin
 22 1 2020-06-18 2020-07-30 4 1 gahwon@google.com gahwon@google.com
local_service_grpc.h
in tools/zetasql_helper/zetasql_helper/local_service
 27 - 2020-08-18 2020-09-03 4 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
extractor.py
in tools/unsupervised_dataset/sql_crawler
 34 3 2020-06-25 2020-08-14 4 1 31913344+noah-kuo@users.nor... 31913344+noah-kuo@users.nor...
DataType.java
in tools/template_based_query_generation/src/main/java/data
 42 7 2020-07-21 2020-08-27 4 2 waallen@google.com 44599941+spoiledhua@users.n...
KeywordsMapping.java
in tools/template_based_query_generation/src/main/java/parser
 49 5 2020-07-21 2020-09-01 4 2 waallen@google.com 44599941+spoiledhua@users.n...
variables.tf
in tools/cloud_functions/gcs_event_based_ingest/terraform_module/gcs_ocn_bq_ingest_function
 50 - 2020-11-11 2021-03-31 4 1 jferriero@google.com jferriero@google.com
QueryFixerMain.java
in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer
 53 2 2020-07-11 2020-08-19 4 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
FixResult.java
in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/entity
 61 5 2020-08-06 2020-08-26 4 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
local_service_grpc.cc
in tools/zetasql_helper/zetasql_helper/local_service
 75 7 2020-08-18 2020-09-03 4 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
proto
local_service.proto
in tools/zetasql_helper/zetasql_helper/local_service
 89 - 2020-08-18 2020-09-03 4 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
cloudbuild.yaml
in tools/cloud_functions/gcs_event_based_ingest
 137 - 2020-11-11 2021-03-31 4 1 jferriero@google.com jferriero@google.com
SqlErrorFactory.java
in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors
 148 10 2020-07-27 2020-09-04 4 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
__init__.py
in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest
 1 - 2020-11-11 2021-03-31 3 1 jferriero@google.com jferriero@google.com
__init__.py
in tools/cloud_functions/gcs_event_based_ingest
 1 - 2020-11-11 2021-03-31 3 1 jferriero@google.com jferriero@google.com
Parser.java
in tools/query_breakdown/src/main/java/com/google/bigquery
 4 - 2020-07-24 2020-08-28 3 1 subinlee@google.com subinlee@google.com
monthly_invoice_costs_credits.sql
in scripts/billing/sql
 9 - 2019-09-11 2022-06-10 3 3 oapa@users.noreply.github.com p.p.amrishkumar@gmail.com
generic_extraction_module.py
in tools/unsupervised_dataset/sql_crawler/extraction_modules
 10 1 2020-06-25 2020-07-20 3 1 31913344+noah-kuo@users.nor... 31913344+noah-kuo@users.nor...
QueryJobResults.java
in tools/query_verification/src/main/java/com/google/bigquery
 16 1 2020-07-21 2020-08-14 3 1 krishsuchdev@google.com krishsuchdev@google.com
FeatureIndicator.java
in tools/template_based_query_generation/src/main/java/parser
 17 4 2020-07-22 2020-08-27 3 1 44599941+spoiledhua@users.n... 44599941+spoiledhua@users.n...
job_execution.sql
in dashboards/system_tables/sql
 18 - 2020-08-16 2024-09-10 3 3 yardenn1@gmail.com 70151215+franklinwhaite@use...
Feature.java
in tools/template_based_query_generation/src/main/java/parser
 18 4 2020-07-21 2020-08-27 3 2 waallen@google.com 44599941+spoiledhua@users.n...
js_libs.yaml
in udfs/js_libs
 19 - 2021-01-20 2024-08-01 3 2 danieldeleo@users.noreply.g... danieldeleo@users.noreply.g...
BigQuerySqlError.java
in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors
 19 3 2020-07-17 2020-08-06 3 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
JavaFrontEnd.kt
in tools/sql_extraction/src/main/kotlin
 21 2 2020-06-18 2020-07-14 3 1 gahwon@google.com gahwon@google.com
run_server.cc
in tools/zetasql_helper/zetasql_helper/local_service
 21 2 2020-08-18 2020-09-04 3 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
run_crawler.py
in tools/unsupervised_dataset
 22 2 2020-06-25 2020-08-14 3 1 31913344+noah-kuo@users.nor... 31913344+noah-kuo@users.nor...
Files With Most Contributors (Top 50)
Based on the number of unique email addresses found in commits.

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
56 - 2020-04-07 2024-09-30 11 4 danieldeleo@users.noreply.g... danieldeleo@users.noreply.g...
28 - 2020-04-14 2024-09-30 9 3 danieldeleo@users.noreply.g... danieldeleo@users.noreply.g...
main.tf
in release/terraform
 171 - 2024-05-07 2025-03-12 7 3 86309184+afleisc@users.nore... danieldeleo@users.noreply.g...
monthly_invoice_costs_credits.sql
in scripts/billing/sql
 9 - 2019-09-11 2022-06-10 3 3 oapa@users.noreply.github.com p.p.amrishkumar@gmail.com
job_execution.sql
in dashboards/system_tables/sql
 18 - 2020-08-16 2024-09-10 3 3 yardenn1@gmail.com 70151215+franklinwhaite@use...
Main.java
in tools/query_breakdown/src/main/java/com/google/bigquery
 163 3 2020-07-24 2021-12-14 9 2 subinlee@google.com zihaoye@google.com
Utils.java
in tools/template_based_query_generation/src/main/java/parser
 282 23 2020-07-21 2020-09-01 8 2 waallen@google.com 44599941+spoiledhua@users.n...
QueryVerifier.java
in tools/query_verification/src/main/java/com/google/bigquery
 160 10 2020-07-06 2020-08-14 8 2 krish@suchdev.com krishsuchdev@google.com
QueryGenerator.java
in tools/template_based_query_generation/src/main/java
 132 2 2020-07-13 2020-09-01 7 2 44599941+spoiledhua@users.n... 44599941+spoiledhua@users.n...
main.py
in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest
 127 5 2020-11-11 2021-10-12 7 2 jferriero@google.com danieldeleo@users.noreply.g...
Table.java
in tools/template_based_query_generation/src/main/java/data
 114 7 2020-07-21 2020-09-01 6 2 waallen@google.com 44599941+spoiledhua@users.n...
main.tf
in tools/cloud_functions/gcs_event_based_ingest/terraform_module/gcs_ocn_bq_ingest_function
 110 - 2020-11-11 2021-10-12 5 2 jferriero@google.com danieldeleo@users.noreply.g...
build.gradle.kts
in tools/sql_extraction
 86 - 2020-06-10 2020-08-14 5 2 creativitry@gmail.com gahwon@google.com
16 - 2021-09-24 2024-09-30 5 2 danieldeleo@users.noreply.g... danieldeleo@users.noreply.g...
DataType.java
in tools/template_based_query_generation/src/main/java/data
 42 7 2020-07-21 2020-08-27 4 2 waallen@google.com 44599941+spoiledhua@users.n...
KeywordsMapping.java
in tools/template_based_query_generation/src/main/java/parser
 49 5 2020-07-21 2020-09-01 4 2 waallen@google.com 44599941+spoiledhua@users.n...
Keywords.java
in tools/template_based_query_generation/src/main/java/parser
 39 7 2020-07-21 2020-07-24 3 2 waallen@google.com 44599941+spoiledhua@users.n...
Feature.java
in tools/template_based_query_generation/src/main/java/parser
 18 4 2020-07-21 2020-08-27 3 2 waallen@google.com 44599941+spoiledhua@users.n...
monthly_cud_sud_savings.sql
in scripts/billing/sql
 49 - 2019-10-07 2020-05-26 3 2 phillcoletti@users.noreply.... ddeleo@google.com
123 - 2019-10-07 2020-05-26 3 2 phillcoletti@users.noreply.... ddeleo@google.com
js_libs.yaml
in udfs/js_libs
 19 - 2021-01-20 2024-08-01 3 2 danieldeleo@users.noreply.g... danieldeleo@users.noreply.g...
986 - 2025-02-24 2025-05-02 3 2 bijanvakili@users.noreply.g... aliciamw@google.com
query_audit.sql
in views/audit
 114 - 2019-11-14 2020-05-26 2 2 vicenteg@users.noreply.gith... ddeleo@google.com
variables.tf
in release/terraform
 49 - 2024-05-07 2024-08-23 2 2 86309184+afleisc@users.nore... danieldeleo@users.noreply.g...
Node.java
in tools/template_based_query_generation/src/main/java/graph
 63 10 2020-07-21 2020-08-27 2 2 waallen@google.com 44599941+spoiledhua@users.n...
MarkovChain.java
in tools/template_based_query_generation/src/main/java/graph
 27 3 2020-07-21 2020-08-27 2 2 waallen@google.com 44599941+spoiledhua@users.n...
code_action_provider.ts
in tools/vscode_automatic_query_fixer/src
 77 2 2020-08-14 2020-09-02 2 2 gahwon@google.com 33992012+mingen-pan@users.n...
auto_fixer_result.ts
in tools/vscode_automatic_query_fixer/src
 15 - 2020-08-14 2020-09-02 2 2 gahwon@google.com 33992012+mingen-pan@users.n...
exceptions.py
in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common
 15 1 2021-03-31 2021-10-12 2 2 jferriero@google.com danieldeleo@users.noreply.g...
constants.py
in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common
 75 - 2021-03-31 2021-10-12 2 2 jferriero@google.com danieldeleo@users.noreply.g...
utils.py
in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common
 676 30 2021-03-31 2021-10-12 2 2 jferriero@google.com danieldeleo@users.noreply.g...
ordering.py
in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common
 320 9 2021-03-31 2021-10-12 2 2 jferriero@google.com danieldeleo@users.noreply.g...
main.py
in tools/cloud_functions/bq_table_snapshots/bq_backup_fetch_tables_names
 40 3 2023-07-12 2024-10-01 2 2 70151215+franklinwhaite@use... oss@regadas.email
Main.java
in tools/query_verification/src/main/java/com/google/bigquery
 138 4 2020-07-06 2020-07-24 2 2 krish@suchdev.com krishsuchdev@google.com
QueryVerificationSchema.java
in tools/query_verification/src/main/java/com/google/bigquery
 26 3 2020-07-06 2020-07-10 2 2 krish@suchdev.com krishsuchdev@google.com
previous_day_costs_by_project.sql
in scripts/billing/sql
 7 - 2019-09-11 2020-05-26 2 2 oapa@users.noreply.github.com ddeleo@google.com
previous_day_costs_by_service.sql
in scripts/billing/sql
 8 - 2019-09-11 2020-05-26 2 2 oapa@users.noreply.github.com ddeleo@google.com
total_costs_by_label_value.sql
in scripts/billing/sql
 9 - 2019-09-11 2020-05-26 2 2 oapa@users.noreply.github.com ddeleo@google.com
total_costs_by_sku_label.sql
in scripts/billing/sql
 6 - 2019-09-11 2020-05-26 2 2 oapa@users.noreply.github.com ddeleo@google.com
daily_compute_cores_average.sql
in scripts/billing/sql
 13 - 2019-09-11 2020-05-26 2 2 oapa@users.noreply.github.com ddeleo@google.com
20 - 2019-09-11 2020-05-26 2 2 oapa@users.noreply.github.com ddeleo@google.com
monthly_costs_credits.sql
in scripts/billing/sql
 8 - 2019-09-11 2020-05-26 2 2 oapa@users.noreply.github.com ddeleo@google.com
16 - 2019-10-31 2020-05-26 2 2 phillcoletti@users.noreply.... ddeleo@google.com
daily_compute_usage_hours.sql
in scripts/billing/sql
 19 - 2019-09-11 2020-05-26 2 2 oapa@users.noreply.github.com ddeleo@google.com
11 - 2019-09-11 2020-05-26 2 2 oapa@users.noreply.github.com ddeleo@google.com
previous_month_costs_by_label.sql
in scripts/billing/sql
 16 - 2019-09-11 2020-05-26 2 2 oapa@users.noreply.github.com ddeleo@google.com
monthly_costs_by_project.sql
in scripts/billing/sql
 8 - 2019-09-11 2020-05-26 2 2 oapa@users.noreply.github.com ddeleo@google.com
daily_compute_discount.sql
in scripts/billing/sql
 11 - 2019-09-11 2020-05-26 2 2 oapa@users.noreply.github.com ddeleo@google.com
119 - 2023-11-20 2024-01-09 2 2 danieldeleo@users.noreply.g... 139372102+timothymanuel@use...
116 - 2024-10-01 2025-04-15 2 2 86309184+afleisc@users.nore... danieldeleo@users.noreply.g...
Files With Least Contributors (Top 50)
Based on the number of unique email addresses found in commits.

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
841 - 2021-09-24 2021-09-24 1 1 danieldeleo@users.noreply.g... danieldeleo@users.noreply.g...
578 - 2021-09-24 2021-09-24 1 1 danieldeleo@users.noreply.g... danieldeleo@users.noreply.g...
BigQueryManager.java
in tools/query_verification/src/main/java/com/google/bigquery
 251 12 2020-08-05 2020-08-14 3 1 krishsuchdev@google.com krishsuchdev@google.com
TeradataManager.java
in tools/query_verification/src/main/java/com/google/bigquery
 247 12 2020-08-14 2020-08-14 1 1 krishsuchdev@google.com krishsuchdev@google.com
QueryBreakdown.java
in tools/query_breakdown/src/main/java/com/google/bigquery
 189 9 2020-07-24 2020-09-11 8 1 subinlee@google.com subinlee@google.com
job_concurrency_comparison_slow.sql
in dashboards/system_tables/sql
 174 - 2021-02-24 2021-02-24 1 1 22534191+kardiff18@users.no... 22534191+kardiff18@users.no...
TokenProvider.java
in tools/template_based_query_generation/src/main/java/token
 167 12 2020-08-27 2020-09-01 2 1 44599941+spoiledhua@users.n... 44599941+spoiledhua@users.n...
166 - 2021-09-24 2021-09-24 1 1 danieldeleo@users.noreply.g... danieldeleo@users.noreply.g...
table_read_patterns.sql
in scripts/optimization
 162 - 2023-11-20 2023-11-20 1 1 danieldeleo@users.noreply.g... danieldeleo@users.noreply.g...
DataFlowEngine.kt
in tools/sql_extraction/src/main/kotlin
 156 14 2020-06-18 2020-08-07 5 1 gahwon@google.com gahwon@google.com
tree_view.ts
in tools/vscode_sql_extraction/src
 152 5 2020-08-07 2020-08-07 1 1 gahwon@google.com gahwon@google.com
SqlErrorFactory.java
in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors
 148 10 2020-07-27 2020-09-04 4 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
JavaAnalyzer.kt
in tools/sql_extraction/src/main/kotlin
 143 15 2020-07-14 2020-08-07 2 1 gahwon@google.com gahwon@google.com
PythonAnalyzer.kt
in tools/sql_extraction/src/main/kotlin
 140 6 2020-08-07 2020-08-10 2 1 gahwon@google.com gahwon@google.com
cloudbuild.yaml
in tools/cloud_functions/gcs_event_based_ingest
 137 - 2020-11-11 2021-03-31 4 1 jferriero@google.com jferriero@google.com
132 - 2023-11-20 2023-11-20 1 1 danieldeleo@users.noreply.g... danieldeleo@users.noreply.g...
backfill.py
in tools/cloud_functions/gcs_event_based_ingest
 126 3 2020-11-18 2021-03-31 2 1 jferriero@google.com jferriero@google.com
QueryFixerOptions.java
in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/cmd
 121 6 2020-08-19 2020-09-05 3 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
job_analyzer_slow.sql
in dashboards/system_tables/sql
 121 - 2021-02-24 2021-02-24 1 1 22534191+kardiff18@users.no... 22534191+kardiff18@users.no...
118 - 2024-01-09 2024-01-09 1 1 139372102+timothymanuel@use... 139372102+timothymanuel@use...
LocationTracker.java
in tools/query_breakdown/src/main/java/com/google/bigquery
 113 10 2020-08-04 2020-09-11 5 1 subinlee@google.com subinlee@google.com
NearbyTokenFixer.java
in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer
 111 8 2020-08-26 2020-09-04 2 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
translatorCommaJoin.py
in tools/legacy_sql_tranlsation_helper
 110 9 2023-05-10 2023-05-10 1 1 55033756+celiajmd@users.nor... 55033756+celiajmd@users.nor...
Classifier.java
in tools/unsupervised_dataset/sql_classifier/classifier/src/main/java
 110 4 2020-08-10 2020-08-10 1 1 31913344+noah-kuo@users.nor... 31913344+noah-kuo@users.nor...
FunctionFixer.java
in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer
 109 9 2020-08-28 2020-09-04 2 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
extension.ts
in tools/vscode_query_breakdown/src
 109 2 2020-08-05 2020-09-11 5 1 subinlee@google.com subinlee@google.com
fix_duplicate_columns.cc
in tools/zetasql_helper/zetasql_helper/fixer
 106 3 2020-09-03 2020-09-03 1 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
InputReader.java
in tools/query_breakdown/src/main/java/com/google/bigquery
 106 5 2020-07-24 2020-09-11 6 1 subinlee@google.com subinlee@google.com
TableNotFoundFixer.java
in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer
 105 6 2020-08-06 2020-09-04 6 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
Cli.kt
in tools/sql_extraction/src/main/kotlin
 104 1 2020-06-16 2020-08-14 8 1 gahwon@google.com gahwon@google.com
NoMatchingSignatureError.java
in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors
 103 4 2020-08-28 2020-08-28 1 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
fix_column_not_grouped.cc
in tools/zetasql_helper/zetasql_helper/fixer
 100 2 2020-09-03 2020-09-03 1 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
NoMatchingSignatureFixer.java
in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer
 99 3 2020-08-28 2020-08-28 1 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
QueryRegex.java
in tools/template_based_query_generation/src/main/java/token
 99 2 2020-08-27 2020-09-01 2 1 44599941+spoiledhua@users.n... 44599941+spoiledhua@users.n...
patternScan.py
in tools/legacy_sql_tranlsation_helper
 98 1 2023-05-10 2023-05-10 1 1 55033756+celiajmd@users.nor... 55033756+celiajmd@users.nor...
AutomaticQueryFixer.java
in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer
 98 7 2020-08-13 2020-08-19 2 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
LocalServiceDockerProvider.java
in tools/zetasql_helper/java/com/google/bigquery/utils/zetasqlhelper
 95 7 2020-09-04 2020-09-04 1 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
SqlExtractor.kt
in tools/sql_extraction/src/main/kotlin
 95 1 2020-06-18 2020-08-14 6 1 gahwon@google.com gahwon@google.com
OAuthUserConfig.java
in tools/custom_java_jdbc_client/src/main/java/com/example
 95 9 2024-06-20 2024-06-20 1 1 21352998+dmedora@users.nore... 21352998+dmedora@users.nore...
95 - 2023-11-20 2023-11-20 1 1 danieldeleo@users.noreply.g... danieldeleo@users.noreply.g...
ConfidenceRater.kt
in tools/sql_extraction/src/main/kotlin
 92 1 2020-07-15 2020-07-15 1 1 gahwon@google.com gahwon@google.com
proto
local_service.proto
in tools/zetasql_helper/zetasql_helper/local_service
 89 - 2020-08-18 2020-09-03 4 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
function.tf
in tools/cloud_functions/bq_table_snapshots/terraform
 88 - 2023-07-12 2023-07-12 1 1 70151215+franklinwhaite@use... 70151215+franklinwhaite@use...
StringUtil.java
in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/util
 87 6 2020-08-04 2020-09-04 3 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
CommandLineInteraction.java
in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/cmd
 87 6 2020-08-19 2020-09-04 2 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
actively_read_tables_with_partitioning_clustering_info.sql
in scripts/optimization/assured_workloads_compliant
 84 - 2023-11-20 2023-11-20 1 1 danieldeleo@users.noreply.g... danieldeleo@users.noreply.g...
Node.java
in tools/query_breakdown/src/main/java/com/google/bigquery
 80 7 2020-07-24 2020-09-11 5 1 subinlee@google.com subinlee@google.com
local_service.cc
in tools/zetasql_helper/zetasql_helper/local_service
 78 6 2020-08-28 2020-09-03 3 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
ZetaSqlToken.java
in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/entity
 77 10 2020-09-04 2020-09-04 1 1 33992012+mingen-pan@users.n... 33992012+mingen-pan@users.n...
crawler_log.py
in tools/unsupervised_dataset/sql_crawler
 77 9 2020-06-25 2020-08-14 3 1 31913344+noah-kuo@users.nor... 31913344+noah-kuo@users.nor...
Correlations

File Size vs. Number of Changes: 277 points

dashboards/geospatial/bigquery_geospatial_visualization.ipynb x: 986 lines of code y: 3 # changes scripts/optimization/storage_billing_model_savings_ddl.sql x: 116 lines of code y: 2 # changes release/terraform/main.tf x: 171 lines of code y: 7 # changes udfs/datasketches/cloudbuild.yaml x: 16 lines of code y: 1 # changes udfs/dir_to_dataset_map.yaml x: 8 lines of code y: 2 # changes tools/cloud_functions/bq_table_snapshots/bq_backup_fetch_tables_names/main.py x: 40 lines of code y: 2 # changes cloudbuild.yaml x: 28 lines of code y: 9 # changes udfs/cloudbuild.yaml x: 56 lines of code y: 11 # changes udfs/deploy.yaml x: 16 lines of code y: 5 # changes dashboards/system_tables/sql/job_execution.sql x: 18 lines of code y: 3 # changes release/terraform/variables.tf x: 49 lines of code y: 2 # changes stored_procedures/workflow_settings.yaml x: 1 lines of code y: 1 # changes tools/custom_java_jdbc_client/src/main/java/com/example/BQSimbaExample.java x: 65 lines of code y: 1 # changes tools/custom_java_jdbc_client/src/main/java/com/example/OAuthUserConfig.java x: 95 lines of code y: 1 # changes tools/custom_java_jdbc_client/src/main/java/com/example/OAuthUserType.java x: 12 lines of code y: 1 # changes scripts/optimization/daily_reservation_analysis.sql x: 75 lines of code y: 2 # changes scripts/optimization/anti-pattern-recognittion-tool-scripts/anti_pattern_recoginition_tool_tables.sql x: 24 lines of code y: 1 # changes scripts/optimization/anti-pattern-recognittion-tool-scripts/update_queries_by_hash_w_anti_patterns.sql x: 6 lines of code y: 1 # changes scripts/optimization/queries_grouped_by_hash_org.sql x: 48 lines of code y: 1 # changes scripts/optimization/queries_grouped_by_hash_project.sql x: 49 lines of code y: 1 # changes scripts/optimization/hourly_slot_consumption_by_labels.sql x: 118 lines of code y: 1 # changes scripts/optimization/hourly_slot_consumption_by_query_hash.sql x: 119 lines of code y: 2 # changes scripts/optimization/queries_grouped_by_labels.sql x: 39 lines of code y: 2 # changes scripts/optimization/assured_workloads_compliant/actively_read_tables_with_partitioning_clustering_info.sql x: 84 lines of code y: 1 # changes scripts/optimization/assured_workloads_compliant/table_read_patterns.sql x: 32 lines of code y: 1 # changes scripts/optimization/daily_project_analysis.sql x: 67 lines of code y: 1 # changes scripts/optimization/frequent_daily_table_dml.sql x: 26 lines of code y: 1 # changes scripts/optimization/queries_grouped_by_script.sql x: 59 lines of code y: 1 # changes scripts/optimization/query_performance_insights.sql x: 27 lines of code y: 1 # changes scripts/optimization/table_read_patterns.sql x: 162 lines of code y: 1 # changes scripts/optimization/table_read_patterns_by_query_hash.sql x: 69 lines of code y: 1 # changes scripts/optimization/tables_without_partitioning_or_clustering.sql x: 73 lines of code y: 1 # changes scripts/optimization/viewable_queries_grouped_by_hash.sql x: 132 lines of code y: 1 # changes scripts/optimization/views_with_nonoptimal_join_condition.sql x: 46 lines of code y: 1 # changes tools/protobuf_export/Main.java x: 44 lines of code y: 2 # changes tools/protobuf_export/main.py x: 14 lines of code y: 2 # changes tools/cloud_functions/bq_table_snapshots/bq_backup_create_snapshots/main.py x: 56 lines of code y: 1 # changes tools/cloud_functions/bq_table_snapshots/terraform/function.tf x: 88 lines of code y: 1 # changes tools/cloud_functions/bq_table_snapshots/terraform/main.tf x: 4 lines of code y: 1 # changes tools/cloud_functions/bq_table_snapshots/terraform/variables.tf x: 38 lines of code y: 1 # changes tools/legacy_sql_tranlsation_helper/patternScan.py x: 98 lines of code y: 1 # changes tools/legacy_sql_tranlsation_helper/sample_sql/sample1.sql x: 8 lines of code y: 1 # changes tools/legacy_sql_tranlsation_helper/sample_sql/sample2.sql x: 2 lines of code y: 1 # changes tools/legacy_sql_tranlsation_helper/translatorCommaJoin.py x: 110 lines of code y: 1 # changes dashboards/system_tables/sql/daily_utilization.sql x: 18 lines of code y: 2 # changes dashboards/system_tables/sql/hourly_utilization.sql x: 20 lines of code y: 2 # changes dashboards/system_tables/sql/daily_commitments.sql x: 42 lines of code y: 2 # changes views/migration/teradata/sys_calendar.sql x: 36 lines of code y: 1 # changes scripts/billing/sql/monthly_invoice_costs_credits.sql x: 9 lines of code y: 3 # changes tools/query_breakdown/src/main/java/com/google/bigquery/Main.java x: 163 lines of code y: 9 # changes tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/exceptions.py x: 15 lines of code y: 2 # changes tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/ordering.py x: 320 lines of code y: 2 # changes tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py x: 676 lines of code y: 2 # changes tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/main.py x: 127 lines of code y: 7 # changes tools/cloud_functions/gcs_event_based_ingest/terraform_module/gcs_ocn_bq_ingest_function/main.tf x: 110 lines of code y: 5 # changes views/audit/bigquery_audit_logs_v1.sql x: 166 lines of code y: 1 # changes views/audit/bigquery_audit_logs_v2.sql x: 841 lines of code y: 1 # changes views/audit/bigquery_script_logs_v2.sql x: 578 lines of code y: 1 # changes dashboards/system_tables/sql/reservation_utilization_week.sql x: 64 lines of code y: 2 # changes tools/cloud_functions/gcs_event_based_ingest/__init__.py x: 1 lines of code y: 3 # changes tools/cloud_functions/gcs_event_based_ingest/backfill.py x: 126 lines of code y: 2 # changes tools/cloud_functions/gcs_event_based_ingest/cloudbuild.yaml x: 137 lines of code y: 4 # changes tools/cloud_functions/gcs_event_based_ingest/terraform_module/gcs_ocn_bq_ingest_function/outputs.tf x: 11 lines of code y: 4 # changes tools/cloud_functions/gcs_event_based_ingest/terraform_module/gcs_ocn_bq_ingest_function/variables.tf x: 50 lines of code y: 4 # changes tools/cloud_functions/gcs_event_based_ingest/terraform_module/gcs_ocn_bq_ingest_function/versions.tf x: 23 lines of code y: 2 # changes dashboards/system_tables/sql/job_analyzer_slow.sql x: 121 lines of code y: 1 # changes dashboards/system_tables/sql/job_concurrency_comparison_slow.sql x: 174 lines of code y: 1 # changes tools/query_breakdown/src/main/java/com/google/bigquery/InputReader.java x: 106 lines of code y: 6 # changes tools/query_breakdown/src/main/java/com/google/bigquery/LocationTracker.java x: 113 lines of code y: 5 # changes tools/query_breakdown/src/main/java/com/google/bigquery/Node.java x: 80 lines of code y: 5 # changes tools/query_breakdown/src/main/java/com/google/bigquery/Pair.java x: 26 lines of code y: 2 # changes tools/query_breakdown/src/main/java/com/google/bigquery/QueryBreakdown.java x: 189 lines of code y: 8 # changes tools/query_breakdown/src/main/java/com/google/bigquery/ReplacedComponent.java x: 37 lines of code y: 2 # changes tools/query_breakdown/src/main/java/com/google/bigquery/ReplacementLogic.java x: 35 lines of code y: 6 # changes tools/vscode_query_breakdown/src/query_breakdown_runner.ts x: 44 lines of code y: 3 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/cmd/QueryFixerOptions.java x: 121 lines of code y: 3 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/cmd/AutoModeInteraction.java x: 65 lines of code y: 2 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/cmd/CommandLineInteraction.java x: 87 lines of code y: 2 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/entity/ZetaSqlToken.java x: 77 lines of code y: 1 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/FixerFactory.java x: 49 lines of code y: 5 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/FunctionFixer.java x: 109 lines of code y: 2 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/NearbyTokenFixer.java x: 111 lines of code y: 2 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/TableNotFoundFixer.java x: 105 lines of code y: 6 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/tokenizer/ZetaSqlTokenizer.java x: 17 lines of code y: 1 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/util/ByteOffsetTranslator.java x: 42 lines of code y: 1 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/util/StringUtil.java x: 87 lines of code y: 3 # changes tools/zetasql_helper/java/com/google/bigquery/utils/zetasqlhelper/LocalServiceException.java x: 9 lines of code y: 1 # changes tools/zetasql_helper/java/com/google/bigquery/utils/zetasqlhelper/LocalServiceProvider.java x: 14 lines of code y: 1 # changes tools/zetasql_helper/java/com/google/bigquery/utils/zetasqlhelper/QueryFunctionRange.java x: 20 lines of code y: 1 # changes tools/zetasql_helper/java/com/google/bigquery/utils/zetasqlhelper/Token.java x: 40 lines of code y: 1 # changes tools/zetasql_helper/java/com/google/bigquery/utils/zetasqlhelper/ZetaSqlHelper.java x: 63 lines of code y: 1 # changes tools/zetasql_helper/zetasql_helper/local_service/run_server.cc x: 21 lines of code y: 3 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/SqlErrorFactory.java x: 148 lines of code y: 4 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/ColumnNotGroupedFixer.java x: 29 lines of code y: 1 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/TypeCast.java x: 55 lines of code y: 2 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/UnexpectedKeywordFixer.java x: 31 lines of code y: 2 # changes tools/zetasql_helper/zetasql_helper/fixer/fix_column_not_grouped.cc x: 100 lines of code y: 1 # changes tools/zetasql_helper/zetasql_helper/fixer/fix_duplicate_columns.cc x: 106 lines of code y: 1 # changes tools/zetasql_helper/zetasql_helper/local_service/local_service.cc x: 78 lines of code y: 3 # changes tools/zetasql_helper/zetasql_helper/local_service/local_service.h x: 25 lines of code y: 3 # changes tools/zetasql_helper/zetasql_helper/local_service/local_service.proto x: 89 lines of code y: 4 # changes tools/zetasql_helper/zetasql_helper/local_service/local_service_grpc.cc x: 75 lines of code y: 4 # changes tools/zetasql_helper/zetasql_helper/local_service/local_service_grpc.h x: 27 lines of code y: 4 # changes tools/zetasql_helper/zetasql_helper/scanner/extract_function.cc x: 52 lines of code y: 2 # changes tools/zetasql_helper/zetasql_helper/scanner/locate_table.cc x: 28 lines of code y: 2 # changes tools/vscode_automatic_query_fixer/src/code_action_provider.ts x: 77 lines of code y: 2 # changes tools/zetasql_helper/zetasql_helper/scanner/extract_function.h x: 19 lines of code y: 1 # changes tools/template_based_query_generation/src/main/java/QueryGenerator.java x: 132 lines of code y: 7 # changes tools/template_based_query_generation/src/main/java/data/Table.java x: 114 lines of code y: 6 # changes tools/template_based_query_generation/src/main/java/parser/KeywordsMapping.java x: 49 lines of code y: 4 # changes tools/template_based_query_generation/src/main/java/parser/Utils.java x: 282 lines of code y: 8 # changes tools/template_based_query_generation/src/main/java/token/QueryRegex.java x: 99 lines of code y: 2 # changes tools/template_based_query_generation/src/main/java/token/TokenProvider.java x: 167 lines of code y: 2 # changes tools/query_breakdown/src/main/java/com/google/bigquery/Parser.java x: 4 lines of code y: 3 # changes tools/zetasql_helper/zetasql_helper/token/parse_token.proto x: 34 lines of code y: 1 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/NoMatchingSignatureError.java x: 103 lines of code y: 1 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/util/PatternMatcher.java x: 49 lines of code y: 3 # changes tools/template_based_query_generation/src/main/java/data/DataType.java x: 42 lines of code y: 4 # changes tools/template_based_query_generation/src/main/java/parser/FeatureIndicator.java x: 17 lines of code y: 3 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/entity/FixResult.java x: 61 lines of code y: 4 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/ExpectKeywordButGotOthersFixer.java x: 53 lines of code y: 1 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/tokenizer/QueryTokenProcessor.java x: 47 lines of code y: 2 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/entity/TokenImpl.java x: 35 lines of code y: 2 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/QueryFixerMain.java x: 53 lines of code y: 4 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/entity/FixOption.java x: 7 lines of code y: 2 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/service/BigQueryService.java x: 42 lines of code y: 3 # changes tools/query_verification/src/main/java/com/google/bigquery/BigQueryManager.java x: 251 lines of code y: 3 # changes tools/query_verification/src/main/java/com/google/bigquery/QueryJobResults.java x: 16 lines of code y: 3 # changes tools/query_verification/src/main/java/com/google/bigquery/QueryVerifier.java x: 160 lines of code y: 8 # changes tools/query_verification/src/main/java/com/google/bigquery/TeradataManager.java x: 247 lines of code y: 1 # changes tools/vscode_automatic_query_fixer/src/extension.ts x: 66 lines of code y: 2 # changes tools/sql_extraction/build.gradle.kts x: 86 lines of code y: 5 # changes tools/sql_extraction/src/main/kotlin/Cli.kt x: 104 lines of code y: 8 # changes tools/sql_extraction/src/main/kotlin/SqlExtractor.kt x: 95 lines of code y: 6 # changes tools/vscode_sql_extraction/src/sql_extraction_runner.ts x: 73 lines of code y: 3 # changes tools/unsupervised_dataset/run_crawler.py x: 22 lines of code y: 3 # changes tools/unsupervised_dataset/sql_crawler/crawler.py x: 53 lines of code y: 3 # changes tools/unsupervised_dataset/sql_crawler/extraction_modules/google_extraction_module.py x: 12 lines of code y: 2 # changes tools/unsupervised_dataset/sql_crawler/extractor.py x: 34 lines of code y: 4 # changes tools/sql_extraction/src/main/kotlin/PythonAnalyzer.kt x: 140 lines of code y: 2 # changes tools/sql_extraction/src/main/kotlin/DataFlowEngine.kt x: 156 lines of code y: 5 # changes tools/sql_extraction/src/main/kotlin/Environment.kt x: 62 lines of code y: 3 # changes tools/sql_extraction/src/main/kotlin/JavaAnalyzer.kt x: 143 lines of code y: 2 # changes tools/vscode_sql_extraction/src/tree_view.ts x: 152 lines of code y: 1 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/entity/Position.java x: 10 lines of code y: 2 # changes tools/query_breakdown/src/main/java/com/google/bigquery/CalciteParser.java x: 29 lines of code y: 3 # changes tools/sql_extraction/src/main/kotlin/DataFlowSolver.kt x: 22 lines of code y: 4 # changes tools/query_verification/src/main/java/com/google/bigquery/Main.java x: 138 lines of code y: 2 # changes tools/template_based_query_generation/src/main/java/parser/Keywords.java x: 39 lines of code y: 3 # changes tools/vscode_sql_extraction/copy_binaries.js x: 33 lines of code y: 1 # changes tools/sql_extraction/src/main/kotlin/ConfidenceRater.kt x: 92 lines of code y: 1 # changes tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/BigQueryParserFactory.java x: 59 lines of code y: 2 # changes tools/sql_extraction/src/main/kotlin/output/QueryFragment.kt x: 64 lines of code y: 3 # changes scripts/billing/sql/daily_compute_usage_cud_sud_coverage.sql x: 123 lines of code y: 3 # changes views/audit/query_audit.sql x: 114 lines of code y: 2 # changes
11.0
# changes
  min: 1.0
  average: 2.12
  25th percentile: 1.0
  median: 2.0
  75th percentile: 2.5
  max: 11.0
0 986.0
lines of code
min: 1.0 | average: 61.01 | 25th percentile: 13.5 | median: 33.0 | 75th percentile: 76.0 | max: 986.0

Number of Contributors vs. Number of Changes: 277 points

dashboards/geospatial/bigquery_geospatial_visualization.ipynb x: 2 # contributors y: 3 # changes scripts/optimization/storage_billing_model_savings_ddl.sql x: 2 # contributors y: 2 # changes release/terraform/main.tf x: 3 # contributors y: 7 # changes udfs/datasketches/cloudbuild.yaml x: 1 # contributors y: 1 # changes cloudbuild.yaml x: 3 # contributors y: 9 # changes udfs/cloudbuild.yaml x: 4 # contributors y: 11 # changes udfs/deploy.yaml x: 2 # contributors y: 5 # changes dashboards/system_tables/sql/job_execution.sql x: 3 # contributors y: 3 # changes tools/protobuf_export/Main.java x: 1 # contributors y: 2 # changes tools/query_breakdown/src/main/java/com/google/bigquery/Main.java x: 2 # contributors y: 9 # changes tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/main.py x: 2 # contributors y: 7 # changes tools/cloud_functions/gcs_event_based_ingest/__init__.py x: 1 # contributors y: 3 # changes tools/cloud_functions/gcs_event_based_ingest/cloudbuild.yaml x: 1 # contributors y: 4 # changes tools/query_breakdown/src/main/java/com/google/bigquery/InputReader.java x: 1 # contributors y: 6 # changes tools/query_breakdown/src/main/java/com/google/bigquery/LocationTracker.java x: 1 # contributors y: 5 # changes tools/query_breakdown/src/main/java/com/google/bigquery/QueryBreakdown.java x: 1 # contributors y: 8 # changes tools/template_based_query_generation/src/main/java/data/Table.java x: 2 # contributors y: 6 # changes tools/template_based_query_generation/src/main/java/parser/KeywordsMapping.java x: 2 # contributors y: 4 # changes tools/template_based_query_generation/src/main/java/parser/Utils.java x: 2 # contributors y: 8 # changes
11.0
# changes
  min: 1.0
  average: 2.12
  25th percentile: 1.0
  median: 2.0
  75th percentile: 2.5
  max: 11.0
0 4.0
# contributors
min: 1.0 | average: 1.23 | 25th percentile: 1.0 | median: 1.0 | 75th percentile: 1.0 | max: 4.0

Number of Contributors vs. File Size: 277 points

dashboards/geospatial/bigquery_geospatial_visualization.ipynb x: 2 # contributors y: 986 lines of code scripts/optimization/storage_billing_model_savings_ddl.sql x: 2 # contributors y: 116 lines of code release/terraform/main.tf x: 3 # contributors y: 171 lines of code udfs/datasketches/cloudbuild.yaml x: 1 # contributors y: 16 lines of code udfs/dir_to_dataset_map.yaml x: 2 # contributors y: 8 lines of code tools/cloud_functions/bq_table_snapshots/bq_backup_fetch_tables_names/main.py x: 2 # contributors y: 40 lines of code cloudbuild.yaml x: 3 # contributors y: 28 lines of code udfs/cloudbuild.yaml x: 4 # contributors y: 56 lines of code udfs/deploy.yaml x: 2 # contributors y: 16 lines of code dashboards/system_tables/sql/job_execution.sql x: 3 # contributors y: 18 lines of code release/terraform/variables.tf x: 2 # contributors y: 49 lines of code stored_procedures/workflow_settings.yaml x: 1 # contributors y: 1 lines of code tools/custom_java_jdbc_client/src/main/java/com/example/BQSimbaExample.java x: 1 # contributors y: 65 lines of code tools/custom_java_jdbc_client/src/main/java/com/example/OAuthUserConfig.java x: 1 # contributors y: 95 lines of code tools/custom_java_jdbc_client/src/main/java/com/example/OAuthUserType.java x: 1 # contributors y: 12 lines of code scripts/optimization/daily_reservation_analysis.sql x: 2 # contributors y: 75 lines of code scripts/optimization/anti-pattern-recognittion-tool-scripts/anti_pattern_recoginition_tool_tables.sql x: 1 # contributors y: 24 lines of code scripts/optimization/anti-pattern-recognittion-tool-scripts/update_queries_by_hash_w_anti_patterns.sql x: 1 # contributors y: 6 lines of code scripts/optimization/queries_grouped_by_hash_org.sql x: 1 # contributors y: 48 lines of code scripts/optimization/hourly_slot_consumption_by_labels.sql x: 1 # contributors y: 118 lines of code scripts/optimization/hourly_slot_consumption_by_query_hash.sql x: 2 # contributors y: 119 lines of code scripts/optimization/assured_workloads_compliant/actively_read_tables_with_partitioning_clustering_info.sql x: 1 # contributors y: 84 lines of code scripts/optimization/assured_workloads_compliant/table_read_patterns.sql x: 1 # contributors y: 32 lines of code scripts/optimization/daily_project_analysis.sql x: 1 # contributors y: 67 lines of code scripts/optimization/queries_grouped_by_script.sql x: 1 # contributors y: 59 lines of code scripts/optimization/table_read_patterns.sql x: 1 # contributors y: 162 lines of code scripts/optimization/tables_without_partitioning_or_clustering.sql x: 1 # contributors y: 73 lines of code scripts/optimization/viewable_queries_grouped_by_hash.sql x: 1 # contributors y: 132 lines of code scripts/optimization/views_with_nonoptimal_join_condition.sql x: 1 # contributors y: 46 lines of code tools/cloud_functions/bq_table_snapshots/bq_backup_create_snapshots/main.py x: 1 # contributors y: 56 lines of code tools/cloud_functions/bq_table_snapshots/terraform/function.tf x: 1 # contributors y: 88 lines of code tools/cloud_functions/bq_table_snapshots/terraform/variables.tf x: 1 # contributors y: 38 lines of code tools/legacy_sql_tranlsation_helper/patternScan.py x: 1 # contributors y: 98 lines of code tools/legacy_sql_tranlsation_helper/sample_sql/sample1.sql x: 1 # contributors y: 8 lines of code tools/legacy_sql_tranlsation_helper/translatorCommaJoin.py x: 1 # contributors y: 110 lines of code dashboards/system_tables/sql/hourly_utilization.sql x: 2 # contributors y: 20 lines of code scripts/billing/sql/monthly_invoice_costs_credits.sql x: 3 # contributors y: 9 lines of code tools/query_breakdown/src/main/java/com/google/bigquery/Main.java x: 2 # contributors y: 163 lines of code tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/exceptions.py x: 2 # contributors y: 15 lines of code tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/ordering.py x: 2 # contributors y: 320 lines of code tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py x: 2 # contributors y: 676 lines of code tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/main.py x: 2 # contributors y: 127 lines of code tools/cloud_functions/gcs_event_based_ingest/terraform_module/gcs_ocn_bq_ingest_function/main.tf x: 2 # contributors y: 110 lines of code views/audit/bigquery_audit_logs_v1.sql x: 1 # contributors y: 166 lines of code views/audit/bigquery_audit_logs_v2.sql x: 1 # contributors y: 841 lines of code views/audit/bigquery_script_logs_v2.sql x: 1 # contributors y: 578 lines of code dashboards/system_tables/sql/reservation_utilization_week.sql x: 2 # contributors y: 64 lines of code tools/cloud_functions/gcs_event_based_ingest/backfill.py x: 1 # contributors y: 126 lines of code tools/cloud_functions/gcs_event_based_ingest/cloudbuild.yaml x: 1 # contributors y: 137 lines of code tools/cloud_functions/gcs_event_based_ingest/terraform_module/gcs_ocn_bq_ingest_function/versions.tf x: 1 # contributors y: 23 lines of code dashboards/system_tables/sql/job_analyzer_slow.sql x: 1 # contributors y: 121 lines of code dashboards/system_tables/sql/job_concurrency_comparison_slow.sql x: 1 # contributors y: 174 lines of code tools/query_breakdown/src/main/java/com/google/bigquery/InputReader.java x: 1 # contributors y: 106 lines of code tools/query_breakdown/src/main/java/com/google/bigquery/LocationTracker.java x: 1 # contributors y: 113 lines of code tools/query_breakdown/src/main/java/com/google/bigquery/Node.java x: 1 # contributors y: 80 lines of code tools/query_breakdown/src/main/java/com/google/bigquery/QueryBreakdown.java x: 1 # contributors y: 189 lines of code tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/entity/ZetaSqlToken.java x: 1 # contributors y: 77 lines of code tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/util/ByteOffsetTranslator.java x: 1 # contributors y: 42 lines of code tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/SqlErrorFactory.java x: 1 # contributors y: 148 lines of code tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/ColumnNotGroupedFixer.java x: 1 # contributors y: 29 lines of code tools/zetasql_helper/zetasql_helper/scanner/extract_function.cc x: 1 # contributors y: 52 lines of code tools/template_based_query_generation/src/main/java/QueryGenerator.java x: 2 # contributors y: 132 lines of code tools/template_based_query_generation/src/main/java/parser/Utils.java x: 2 # contributors y: 282 lines of code tools/template_based_query_generation/src/main/java/token/TokenProvider.java x: 1 # contributors y: 167 lines of code tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/NoMatchingSignatureError.java x: 1 # contributors y: 103 lines of code tools/template_based_query_generation/src/main/java/graph/MarkovChain.java x: 2 # contributors y: 27 lines of code tools/query_verification/src/main/java/com/google/bigquery/BigQueryManager.java x: 1 # contributors y: 251 lines of code tools/query_verification/src/main/java/com/google/bigquery/TeradataManager.java x: 1 # contributors y: 247 lines of code tools/sql_extraction/build.gradle.kts x: 2 # contributors y: 86 lines of code tools/sql_extraction/src/main/kotlin/PythonAnalyzer.kt x: 1 # contributors y: 140 lines of code tools/sql_extraction/src/main/kotlin/DataFlowEngine.kt x: 1 # contributors y: 156 lines of code tools/vscode_sql_extraction/src/tree_view.ts x: 1 # contributors y: 152 lines of code tools/query_verification/src/main/java/com/google/bigquery/Main.java x: 2 # contributors y: 138 lines of code tools/sql_extraction/src/main/kotlin/ConfidenceRater.kt x: 1 # contributors y: 92 lines of code scripts/billing/sql/daily_compute_usage_cud_sud_coverage.sql x: 2 # contributors y: 123 lines of code scripts/billing/sql/previous_day_costs_by_project.sql x: 2 # contributors y: 7 lines of code
986.0
lines of code
  min: 1.0
  average: 61.01
  25th percentile: 13.5
  median: 33.0
  75th percentile: 76.0
  max: 986.0
0 4.0
# contributors
min: 1.0 | average: 1.23 | 25th percentile: 1.0 | median: 1.0 | 75th percentile: 1.0 | max: 4.0