• 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 287 files with 68,371 lines of code.
• 11 very long files (33,711 lines of code)
• 17 long files (12,901 lines of code)
• 29 medium size files (8,692 lines of codeclsfd_ftr_w_mp_ins)
• 44 small files (5,912 lines of code)
• 186 very small files (7,155 lines of code)

There are 158 files with lines longer than 120 characters. In total, there are 1945 long lines.

File	# lines	# units	# long lines
04-Data-Governance.ipynb in data-analytics-demos/bigquery-data-governance/colab-enterprise	3513	-	129
BigLake-Demo.ipynb in colab-enterprise	4387	-	128
sp_step_00_initialize.sql in sql-scripts/rideshare_llm_curated	393	-	117
main.py in cloud-functions/bigquery-external-function	416	8	90
tf-deploy-files.tf in terraform-modules/deploy-files	928	-	67
BigQuery-Analytics-with-GenAI.ipynb in colab-enterprise	1823	-	61
Data-Engineering-Agents-Demo.ipynb in data-analytics-demos/data-engineering-agents	916	-	61
synthetic_data_generation_using_llms.ipynb in colab-enterprise	2456	-	57
rideshare_llm_ai_lakehouse_demo.ipynb in colab-enterprise	1340	-	54
05-Data-Quality.ipynb in data-analytics-demos/bigquery-data-governance/colab-enterprise	1391	-	52
rideshare_llm_step_04_driver_summary.ipynb in colab-enterprise	666	-	49
rideshare_llm_step_06_driver_quantitative_analysis.ipynb in colab-enterprise	351	-	47
BigLake-Iceberg-Sync-Demo.ipynb in colab-enterprise	1393	-	45
rideshare_llm_ai_lakehouse_embeddings.ipynb in colab-enterprise	8357	-	39
terraform.tf in cloud-composer/data/terraform/dataplex-with-hms	978	-	36
terraform.tf in cloud-composer/data/terraform/dataplex	990	-	36
sp_demo_federated_query.sql in sql-scripts/taxi_dataset	102	-	31
02-Data-Profile.ipynb in data-analytics-demos/bigquery-data-governance/colab-enterprise	761	-	31
tf-dataform.tf in terraform-modules/dataform	601	-	31
Veo-2-text-to-video.ipynb in colab-enterprise	794	-	29
03-Data-Insights.ipynb in data-analytics-demos/bigquery-data-governance/colab-enterprise	755	-	28
sp_create_taxi_internal_tables.sql in sql-scripts/taxi_dataset	205	-	27
sp_step_03_extract_customer_attributes.sql in sql-scripts/rideshare_llm_enriched	58	-	26
rideshare_iceberg_serverless.py in dataproc	169	1	26
tf-resources.tf in terraform-modules/resources	2317	-	24
tf-resources.tf in data-analytics-demos/bigquery-data-governance/terraform-modules/resources	810	-	23
sp_iceberg_spark_transformation.py in sql-scripts/rideshare_lakehouse_enriched	157	-	22
dataplex_data_quality_taxi.yaml in dataplex/data-quality	216	-	21
sp_demo_datastudio_report.sql in sql-scripts/taxi_dataset	95	-	21
06-Data-Discovery-Scan.ipynb in data-analytics-demos/bigquery-data-governance/colab-enterprise	773	-	21
cshtml _Layout.cshtml in cloud-run/rideshare-plus-website/RidesharePlus/Views/Shared	114	-	20
dataplex_data_quality_rideshare.yaml in dataplex/data-quality	169	-	16
tf-deploy-files.tf in deprecated-code/terraform-modules/deploy-files	234	-	15
initialize.sql in data-analytics-demos/bigquery-data-governance/sql-scripts/governed_data_curated	252	-	15
07-Sensitive-Data-Protection-Scan.ipynb in data-analytics-demos/bigquery-data-governance/colab-enterprise	793	-	15
sp_demo_security_col_encryption_shredding.sql in sql-scripts/taxi_dataset	132	-	14
cshtml DemoOverview.cshtml in cloud-run/rideshare-plus-website/RidesharePlus/Views/Home	107	-	14
rideshare_llm_step_07_customer_quantitative_analysis.ipynb in colab-enterprise	284	-	14
sample-rideshare-hydrate-data.py in cloud-composer/dags	160	-	14
step-01-taxi-data-download.py in cloud-composer/dags	224	3	13
demo_queries.sql in sql-scripts/thelook_ecommerce	107	-	12
sp_step_02_extract_driver_attributes.sql in sql-scripts/rideshare_llm_enriched	47	-	11
rideshare_llm_step_05_customer_summary.ipynb in colab-enterprise	560	-	11
cshtml Index.cshtml in cloud-run/rideshare-plus-website/RidesharePlus/Views/LLM	85	-	10
GenAI-Generate-Table-and-Column-Descriptions.ipynb in colab-enterprise	730	-	10
sp_create_datastream_cdc_data.sql in sql-scripts/taxi_dataset	88	-	9
tf-variables.tf in terraform	294	-	9
sp_demo_external_function.sql in sql-scripts/taxi_dataset	82	-	8
sp_unstructured_data_analysis.sql in sql-scripts/rideshare_lakehouse_enriched	141	-	8
sp_demo_script.sql in sql-scripts/rideshare_lakehouse_curated	51	-	7