• File size measurements show the distribution of size of files.
• Files are classified in four categories based on their size (lines of code): 1-100 (very small files), 101-200 (small files), 201-500 (medium size files), 501-1000 (long files), 1001+(very long files).
• It is a good practice to keep files small. Long files may become "bloaters", code that have increased to such gargantuan proportions that they are hard to work with.

• There are 277 files with 16,901 lines of code.
• 0 very long files (0 lines of code)
• 4 long files (3,081 lines of code)
• 4 medium size files (1,100 lines of codeclsfd_ftr_w_mp_ins)
• 39 small files (5,125 lines of code)
• 230 very small files (7,595 lines of code)

There are 38 files with lines longer than 120 characters. In total, there are 156 long lines.

File	# lines	# units	# long lines
bigquery_geospatial_visualization.ipynb in dashboards/geospatial	986	-	64
QueryVerifier.java in tools/query_verification/src/main/java/com/google/bigquery	160	10	13
BigQueryManager.java in tools/query_verification/src/main/java/com/google/bigquery	251	12	8
TokenProvider.java in tools/template_based_query_generation/src/main/java/token	167	12	6
TeradataManager.java in tools/query_verification/src/main/java/com/google/bigquery	247	12	6
run_crawler.py in tools/unsupervised_dataset	22	2	5
QueryFixerOptions.java in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/cmd	121	6	4
Utils.java in tools/template_based_query_generation/src/main/java/parser	282	23	4
Main.java in tools/query_verification/src/main/java/com/google/bigquery	138	4	4
query_audit.sql in views/audit	114	-	3
patternScan.py in tools/legacy_sql_tranlsation_helper	98	1	3
KeywordsMapping.java in tools/template_based_query_generation/src/main/java/parser	49	5	3
main.tf in tools/cloud_functions/gcs_event_based_ingest/terraform_module/gcs_ocn_bq_ingest_function	110	-	3
BQSimbaExample.java in tools/custom_java_jdbc_client/src/main/java/com/example	65	3	3
storage_billing_model_savings_ddl.sql in scripts/optimization	116	-	3
variables.tf in tools/cloud_functions/bq_table_snapshots/terraform	38	-	2
bigquery_audit_logs_v1.sql in views/audit	166	-	1
bigquery_audit_logs_v2.sql in views/audit	841	-	1
bigquery_script_logs_v2.sql in views/audit	578	-	1
translatorCommaJoin.py in tools/legacy_sql_tranlsation_helper	110	9	1
ColumnNotGroupedFixer.java in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer	29	1	1
QueryFixerMain.java in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer	53	2	1
BigQueryParserFactory.java in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer	59	5	1
FixResult.java in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/entity	61	5	1
NoMatchingSignatureError.java in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors	103	4	1
QueryGenerator.java in tools/template_based_query_generation/src/main/java	132	2	1
extraction_module_4.py in tools/unsupervised_dataset/sql_crawler/extraction_modules	14	1	1
extraction_module_2.py in tools/unsupervised_dataset/sql_crawler/extraction_modules	13	1	1
variables.tf in tools/cloud_functions/gcs_event_based_ingest/terraform_module/gcs_ocn_bq_ingest_function	50	-	1
function.tf in tools/cloud_functions/bq_table_snapshots/terraform	88	-	1
main.py in tools/cloud_functions/bq_table_snapshots/bq_backup_create_snapshots	56	4	1
LocalServiceDockerProvider.java in tools/zetasql_helper/java/com/google/bigquery/utils/zetasqlhelper	95	7	1
QueryJobResults.java in tools/query_verification/src/main/java/com/google/bigquery	16	1	1
QueryErrors.java in tools/query_verification/src/main/java/com/google/bigquery	13	1	1
BigQuerySchemaJsonDeserializer.java in tools/query_verification/src/main/java/com/google/bigquery	29	1	1
frequent_daily_table_dml.sql in scripts/optimization	26	-	1
table_read_patterns.sql in scripts/optimization	162	-	1
job_analyzer_slow.sql in dashboards/system_tables/sql	121	-	1