GoogleCloudPlatform / zetasql-toolkit

Intro

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.

Learn more...

File Size Overall

There are 56 files with 5,672 lines of code.

0 very long files (0 lines of code)
0 long files (0 lines of code)
8 medium size files (2,670 lines of codeclsfd_ftr_w_mp_ins)
14 small files (2,000 lines of code)
34 very small files (1,002 lines of code)

Legend:

1001+

501-1000

201-500

101-200

1-100

explore: grouped by folders | grouped by size | sunburst | 3D view

File Size per Extension

1001+

501-1000

201-500

101-200

1-100

File Size per Logical Decomposition

primary

1001+

501-1000

201-500

101-200

1-100

Longest Files (Top 50)

File	# lines	# units
Coercer.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit	489	8
BigQueryCatalog.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery	452	45
StatementRewriter.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit	408	3
BigQueryAPIResourceProvider.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery	359	30
JsonCatalogDeserializer.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog/io	319	13
ZetaSQLToolkitAnalyzer.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit	225	18
CatalogOperations.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog	213	21
ParentColumnFinder.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/tools/lineage	205	20
ColumnLineageExtractor.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/tools/lineage	200	13
SpannerCatalog.java in zetasql-toolkit-spanner/src/main/java/com/google/zetasql/toolkit/catalog/spanner	172	25
BigQueryBuiltIns.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery	166	3
LocalBigQueryResourceProvider.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery	158	14
BigQueryLanguageOptions.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/options	155	2
BigQueryService.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery	153	16
CatalogUpdaterVisitor.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit	143	17
FunctionResultTypeResolver.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery	139	5
AnalyzerExtensions.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit	131	5
ExpressionParentFinder.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/tools/lineage	130	12
FunctionInfo.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog	129	26
TVFInfo.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog	117	20
BasicCatalogWrapper.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog/basic	106	18
ZetaSQLTypeParser.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog/typeparser	101	8
SpannerResourceProviderImpl.java in zetasql-toolkit-spanner/src/main/java/com/google/zetasql/toolkit/catalog/spanner	93	7
BigQueryReference.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery	91	15
ZetaSQLPatcher.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/tools/patch	81	5
ZetaSQLStrings.java in zetasql-toolkit-core/src/main/java/com/google/zetasql	80	13
ZetaSQLTypeGrammar.g4 in zetasql-toolkit-core/src/main/antlr4/com/google/zetasql/toolkit/catalog/typeparser	79	-
SpannerLanguageOptions.java in zetasql-toolkit-spanner/src/main/java/com/google/zetasql/toolkit/options	61	2
CatalogWrapper.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog	57	8
CatalogResources.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog/io	39	6
UsageTracking.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/usage	30	2
ColumnEntity.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/tools/lineage	29	4
SpannerBuiltIns.java in zetasql-toolkit-spanner/src/main/java/com/google/zetasql/toolkit/catalog/spanner	28	1
ColumnLineage.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/tools/lineage	26	3
MissingFunctionResultType.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery/exceptions	26	5
ProcedureInfo.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog	21	4
BigQueryResourceProvider.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery	21	-
LocalSpannerResourceProvider.java in zetasql-toolkit-spanner/src/main/java/com/google/zetasql/toolkit/catalog/spanner	21	3
AnalyzedStatement.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit	19	3
CatalogResourceAlreadyExists.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog/exceptions	19	4
CatalogResourceDoesNotExist.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog/exceptions	19	4
CouldNotInferFunctionReturnType.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery/exceptions	17	3
BigQueryCreateError.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery/exceptions	17	3
InvalidBigQueryReference.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery/exceptions	15	3
BigQueryAPIRoutineType.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery	14	1
SpannerTablesNotFound.java in zetasql-toolkit-spanner/src/main/java/com/google/zetasql/toolkit/catalog/spanner/exceptions	12	2
BigQueryResourceNotFound.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery/exceptions	11	2
InvalidSpannerTableName.java in zetasql-toolkit-spanner/src/main/java/com/google/zetasql/toolkit/catalog/spanner/exceptions	11	2
AnalysisException.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit	10	2
BigQueryCatalogException.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery/exceptions	10	2

Files With Most Units (Top 50)

File	# lines	# units
BigQueryCatalog.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery	452	45
BigQueryAPIResourceProvider.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery	359	30
FunctionInfo.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog	129	26
SpannerCatalog.java in zetasql-toolkit-spanner/src/main/java/com/google/zetasql/toolkit/catalog/spanner	172	25
CatalogOperations.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog	213	21
ParentColumnFinder.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/tools/lineage	205	20
TVFInfo.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog	117	20
ZetaSQLToolkitAnalyzer.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit	225	18
BasicCatalogWrapper.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog/basic	106	18
CatalogUpdaterVisitor.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit	143	17
BigQueryService.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery	153	16
BigQueryReference.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery	91	15
LocalBigQueryResourceProvider.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery	158	14
ZetaSQLStrings.java in zetasql-toolkit-core/src/main/java/com/google/zetasql	80	13
ColumnLineageExtractor.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/tools/lineage	200	13
JsonCatalogDeserializer.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog/io	319	13
ExpressionParentFinder.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/tools/lineage	130	12
Coercer.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit	489	8
CatalogWrapper.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog	57	8
ZetaSQLTypeParser.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog/typeparser	101	8
SpannerResourceProviderImpl.java in zetasql-toolkit-spanner/src/main/java/com/google/zetasql/toolkit/catalog/spanner	93	7
CatalogResources.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog/io	39	6
ZetaSQLPatcher.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/tools/patch	81	5
AnalyzerExtensions.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit	131	5
MissingFunctionResultType.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery/exceptions	26	5
FunctionResultTypeResolver.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery	139	5
ColumnEntity.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/tools/lineage	29	4
CatalogResourceAlreadyExists.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog/exceptions	19	4
CatalogResourceDoesNotExist.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog/exceptions	19	4
ProcedureInfo.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog	21	4
ColumnLineage.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/tools/lineage	26	3
AnalyzedStatement.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit	19	3
StatementRewriter.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit	408	3
BigQueryBuiltIns.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery	166	3
CouldNotInferFunctionReturnType.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery/exceptions	17	3
BigQueryCreateError.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery/exceptions	17	3
InvalidBigQueryReference.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery/exceptions	15	3
LocalSpannerResourceProvider.java in zetasql-toolkit-spanner/src/main/java/com/google/zetasql/toolkit/catalog/spanner	21	3
UsageTracking.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/usage	30	2
AnalysisException.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit	10	2
CatalogException.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog/exceptions	9	2
BigQueryLanguageOptions.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/options	155	2
BigQueryResourceNotFound.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery/exceptions	11	2
BigQueryCatalogException.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery/exceptions	10	2
SpannerLanguageOptions.java in zetasql-toolkit-spanner/src/main/java/com/google/zetasql/toolkit/options	61	2
InvalidSpannerTableName.java in zetasql-toolkit-spanner/src/main/java/com/google/zetasql/toolkit/catalog/spanner/exceptions	11	2
SpannerTablesNotFound.java in zetasql-toolkit-spanner/src/main/java/com/google/zetasql/toolkit/catalog/spanner/exceptions	12	2
SimpleCatalogUtil.java in zetasql-toolkit-core/src/main/java/com/google/zetasql	9	1
ZetaSQLTypeParseError.java in zetasql-toolkit-core/src/main/java/com/google/zetasql/toolkit/catalog/typeparser	6	1
BigQueryAPIError.java in zetasql-toolkit-bigquery/src/main/java/com/google/zetasql/toolkit/catalog/bigquery/exceptions	7	1

Files With Long Lines (Top 0)

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

File	# lines	# units	# long lines

Correlations

File Size vs. Commits (all time): 56 points

		489.0	lines of code min: 6.0 average: 101.29 25th percentile: 17.0 median: 59.0 75th percentile: 150.5 max: 489.0
0	21.0
commits (all time) min: 1.0 \| average: 4.88 \| 25th percentile: 2.0 \| median: 4.0 \| 75th percentile: 6.75 \| max: 21.0

File Size vs. Contributors (all time): 56 points

		489.0	lines of code min: 6.0 average: 101.29 25th percentile: 17.0 median: 59.0 75th percentile: 150.5 max: 489.0
0	2.0
contributors (all time) min: 1.0 \| average: 1.04 \| 25th percentile: 1.0 \| median: 1.0 \| 75th percentile: 1.0 \| max: 2.0

File Size vs. Commits (30 days): 0 points

No data for "commits (30d)" vs. "lines of code".

File Size vs. Contributors (30 days): 0 points

No data for "contributors (30d)" vs. "lines of code".

File Size vs. Commits (90 days): 0 points

No data for "commits (90d)" vs. "lines of code".

File Size vs. Contributors (90 days): 0 points

No data for "contributors (90d)" vs. "lines of code".