elastic / dbt-project-evaluator

Intro

For duplication, we look at places in code where there are 6 or more lines of code that are exactly the same.
Before duplication is calculated, the code is cleaned to remove empty lines, comments, and frequently duplicated constructs such as imports.
You should aim at having as little as possible (<5%) of duplicated code as high-level of duplication can lead to maintenance difficulties, poor factoring, and logical contradictions.

Learn more...

Duplication Overall

15% duplication:

2,339 cleaned lines of cleaned code (without empty lines, comments, and frequently duplicated constructs such as imports)
353 duplicated lines

63 duplicates

dependency graphs: 2D graph | 3D graph | 3D graph (with duplicates)...

Duplication per Extension

Duplication per Component (primary)

Longest Duplicates

The list of 50 longest duplicates.

See data for all 63 duplicates...

Size	#	Folders	Files	Lines	Code
25	x 2	macros macros	find_all_hard_coded_references.sql find_all_hard_coded_references.sql	122:155 (13%) 161:194 (13%)	view
16	x 2	macros macros	find_all_hard_coded_references.sql find_all_hard_coded_references.sql	52:73 (8%) 79:100 (8%)	view
14	x 2	models/staging/graph/base models/staging/graph/base	base_exposure_relationships.sql base_metric_relationships.sql	5:23 (77%) 5:23 (77%)	view
14	x 2	models/staging/graph/base models/staging/graph/base	base_node_columns.sql base_source_columns.sql	5:21 (60%) 5:21 (60%)	view
14	x 2	models/staging/graph/base models/staging/graph/base	base_exposure_relationships.sql base_node_relationships.sql	5:23 (77%) 5:22 (77%)	view
14	x 2	models/staging/graph/base models/staging/graph/base	base_metric_relationships.sql base_node_relationships.sql	5:23 (77%) 5:22 (77%)	view
13	x 2	models/staging/graph models/staging/graph	stg_metrics.sql stg_nodes.sql	5:21 (40%) 5:22 (30%)	view
12	x 2	models/marts/dag models/marts/dag	fct_unused_sources.sql fct_unused_staging_models.sql	8:22 (70%) 9:23 (66%)	view
11	x 2	models/staging/graph models/staging/graph	stg_metrics.sql stg_sources.sql	5:19 (34%) 5:20 (33%)	view
11	x 2	models/staging/graph models/staging/graph	stg_nodes.sql stg_sources.sql	5:20 (25%) 5:20 (33%)	view
10	x 2	macros/unpack macros/unpack	get_exposure_values.sql get_metric_values.sql	10:21 (34%) 9:20 (29%)	view
9	x 2	models/staging/graph/base models/staging/graph/base	base_exposure_relationships.sql base_node_columns.sql	5:17 (50%) 5:16 (39%)	view
9	x 2	models/staging/graph/base models/staging/graph/base	base_exposure_relationships.sql base_source_columns.sql	5:17 (50%) 5:16 (39%)	view
9	x 2	models/staging/graph/base models/staging/graph/base	base_node_relationships.sql base_source_columns.sql	5:16 (50%) 5:16 (39%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_source_columns.sql stg_nodes.sql	5:16 (39%) 5:17 (20%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_node_columns.sql stg_sources.sql	5:16 (39%) 5:17 (27%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_exposure_relationships.sql stg_metrics.sql	5:17 (50%) 5:16 (28%)	view
9	x 2	models/staging/graph models/staging/graph	stg_exposures.sql stg_metrics.sql	5:16 (33%) 5:16 (28%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_node_columns.sql stg_metrics.sql	5:16 (39%) 5:16 (28%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_metric_relationships.sql stg_nodes.sql	5:17 (50%) 5:17 (20%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_source_columns.sql stg_metrics.sql	5:16 (39%) 5:16 (28%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_metric_relationships.sql stg_metrics.sql	5:17 (50%) 5:16 (28%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_source_columns.sql stg_sources.sql	5:16 (39%) 5:17 (27%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_node_relationships.sql stg_sources.sql	5:16 (50%) 5:17 (27%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_exposure_relationships.sql stg_sources.sql	5:17 (50%) 5:17 (27%)	view
9	x 2	models/staging/graph models/staging/graph	stg_exposures.sql stg_sources.sql	5:16 (33%) 5:17 (27%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_metric_relationships.sql stg_sources.sql	5:17 (50%) 5:17 (27%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_node_relationships.sql stg_metrics.sql	5:16 (50%) 5:16 (28%)	view
9	x 2	models/staging/graph/base models/staging/graph/base	base_node_columns.sql base_node_relationships.sql	5:16 (39%) 5:16 (50%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_exposure_relationships.sql stg_exposures.sql	5:17 (50%) 5:16 (33%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_node_columns.sql stg_exposures.sql	5:16 (39%) 5:16 (33%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_source_columns.sql stg_exposures.sql	5:16 (39%) 5:16 (33%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_exposure_relationships.sql stg_nodes.sql	5:17 (50%) 5:17 (20%)	view
9	x 2	models/staging/graph models/staging/graph	stg_exposures.sql stg_nodes.sql	5:16 (33%) 5:17 (20%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_node_relationships.sql stg_nodes.sql	5:16 (50%) 5:17 (20%)	view
9	x 2	models/staging/graph/base models/staging/graph/base	base_metric_relationships.sql base_node_columns.sql	5:17 (50%) 5:16 (39%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_metric_relationships.sql stg_exposures.sql	5:17 (50%) 5:16 (33%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_node_relationships.sql stg_exposures.sql	5:16 (50%) 5:16 (33%)	view
9	x 2	models/staging/graph/base models/staging/graph	base_node_columns.sql stg_nodes.sql	5:16 (39%) 5:17 (20%)	view
9	x 2	models/staging/graph/base models/staging/graph/base	base_metric_relationships.sql base_source_columns.sql	5:17 (50%) 5:16 (39%)	view
8	x 2	models/marts/governance models/marts/governance	fct_public_models_without_contract.sql fct_undocumented_public_models.sql	1:11 (47%) 1:10 (34%)	view
8	x 2	macros/unpack macros/unpack	get_exposure_values.sql get_metric_values.sql	27:38 (27%) 31:42 (23%)	view
7	x 2	macros macros	find_all_hard_coded_references.sql find_all_hard_coded_references.sql	122:131 (3%) 216:225 (3%)	view
7	x 2	macros macros	find_all_hard_coded_references.sql find_all_hard_coded_references.sql	79:88 (3%) 216:225 (3%)	view
7	x 2	macros macros	find_all_hard_coded_references.sql find_all_hard_coded_references.sql	161:170 (3%) 216:225 (3%)	view
7	x 2	macros/unpack macros/unpack	get_exposure_values.sql get_source_values.sql	28:38 (24%) 36:47 (18%)	view
7	x 2	macros/unpack macros/unpack	get_metric_values.sql get_node_values.sql	32:42 (20%) 50:60 (14%)	view
7	x 2	macros macros	find_all_hard_coded_references.sql find_all_hard_coded_references.sql	79:88 (3%) 122:131 (3%)	view
7	x 2	macros macros	find_all_hard_coded_references.sql find_all_hard_coded_references.sql	52:61 (3%) 216:225 (3%)	view
7	x 2	macros macros	find_all_hard_coded_references.sql find_all_hard_coded_references.sql	52:61 (3%) 161:170 (3%)	view