microsoft / AzureDWScriptsandUtilities
Metrics

All numeric values measured by Sokrates.

Intro
  • Metrics are all numeric values measured by Sokrates.
  • You can use these metrics to define goals and controls.
Metrics
Metric Value
TOTAL_NUMBER_OF_FILES 79
NUMBER_OF_FILES_MAIN 18
LINES_OF_CODE_MAIN 3,581
NUMBER_OF_FILES_MAIN_EXT_PS1 16
LINES_OF_CODE_MAIN_EXT_PS1 3,296
NUMBER_OF_FILES_MAIN_EXT_PY 2
LINES_OF_CODE_MAIN_EXT_PY 285
NUMBER_OF_FILES_TEST 0
LINES_OF_CODE_TEST 0
TEST_VS_MAIN_LINES_OF_CODE_PERCENTAGE 0
NUMBER_OF_FILES_GENERATED 0
LINES_OF_CODE_GENERATED 0
NUMBER_OF_FILES_BUILD_AND_DEPLOYMENT 0
LINES_OF_CODE_BUILD_AND_DEPLOYMENT 0
NUMBER_OF_FILES_OTHER 51
LINES_OF_CODE_OTHER 1,183
NUMBER_OF_FILES_OTHER_EXT_MD 13
LINES_OF_CODE_OTHER_EXT_MD 690
NUMBER_OF_FILES_OTHER_EXT_SQL 37
LINES_OF_CODE_OTHER_EXT_SQL 382
NUMBER_OF_FILES_OTHER_EXT_JSON 1
LINES_OF_CODE_OTHER_EXT_JSON 111
NUMBER_OF_FILES_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_0_PREASSESSMENT 3
LINES_OF_CODE_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_0_PREASSESSMENT 418
NUMBER_OF_FILES_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_0_PREASSESSMENT_EXT_PS1 3
LINES_OF_CODE_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_0_PREASSESSMENT_EXT_PS1 418
NUMBER_OF_FILES_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_1_CREATEMPPSCRIPTS 2
LINES_OF_CODE_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_1_CREATEMPPSCRIPTS 140
NUMBER_OF_FILES_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_1_CREATEMPPSCRIPTS_EXT_PS1 2
LINES_OF_CODE_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_1_CREATEMPPSCRIPTS_EXT_PS1 140
NUMBER_OF_FILES_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS 1
LINES_OF_CODE_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS 153
NUMBER_OF_FILES_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_EXT_PY 1
LINES_OF_CODE_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_EXT_PY 153
NUMBER_OF_FILES_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS 1
LINES_OF_CODE_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS 132
NUMBER_OF_FILES_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_EXT_PY 1
LINES_OF_CODE_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_EXT_PY 132
NUMBER_OF_FILES_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_4_CREATEAPSEXPORTSCRIPTSQLDWIMPORTSCRIPT 2
LINES_OF_CODE_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_4_CREATEAPSEXPORTSCRIPTSQLDWIMPORTSCRIPT 375
NUMBER_OF_FILES_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_4_CREATEAPSEXPORTSCRIPTSQLDWIMPORTSCRIPT_EXT_PS1 2
LINES_OF_CODE_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_4_CREATEAPSEXPORTSCRIPTSQLDWIMPORTSCRIPT_EXT_PS1 375
NUMBER_OF_FILES_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_5_CREATEEXTERNALTABLESSQLDW 3
LINES_OF_CODE_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_5_CREATEEXTERNALTABLESSQLDW 407
NUMBER_OF_FILES_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_5_CREATEEXTERNALTABLESSQLDW_EXT_PS1 3
LINES_OF_CODE_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_5_CREATEEXTERNALTABLESSQLDW_EXT_PS1 407
NUMBER_OF_FILES_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_6_DEPLOYSCRIPTSTOSQLDW 3
LINES_OF_CODE_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_6_DEPLOYSCRIPTSTOSQLDW 816
NUMBER_OF_FILES_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_6_DEPLOYSCRIPTSTOSQLDW_EXT_PS1 3
LINES_OF_CODE_DECOMPOSITION_PRIMARY_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_6_DEPLOYSCRIPTSTOSQLDW_EXT_PS1 816
NUMBER_OF_FILES_DECOMPOSITION_PRIMARY_ASSESSMENT 3
LINES_OF_CODE_DECOMPOSITION_PRIMARY_ASSESSMENT 1,140
NUMBER_OF_FILES_DECOMPOSITION_PRIMARY_ASSESSMENT_EXT_PS1 3
LINES_OF_CODE_DECOMPOSITION_PRIMARY_ASSESSMENT_EXT_PS1 1,140
NUMBER_OF_DEPENDENCY_LINKS_DECOMPOSITION_PRIMARY 0
NUMBER_OF_DEPENDENCIES_DECOMPOSITION_PRIMARY 0
NUMBER_OF_PLACES_WITH_CYCLIC_DEPENDENCIES_DECOMPOSITION_PRIMARY 0
NUMBER_OF_FILES_CONCERN_GENERAL_TODOS 0
LINES_OF_CODE_CONCERN_GENERAL_TODOS 0
NUMBER_OF_FILES_CONCERN_GENERAL_UNCLASSIFIED 18
LINES_OF_CODE_CONCERN_GENERAL_UNCLASSIFIED 3,581
NUMBER_OF_FILES_CONCERN_GENERAL_UNCLASSIFIED_EXT_PS1 16
LINES_OF_CODE_CONCERN_GENERAL_UNCLASSIFIED_EXT_PS1 3,296
NUMBER_OF_FILES_CONCERN_GENERAL_UNCLASSIFIED_EXT_PY 2
LINES_OF_CODE_CONCERN_GENERAL_UNCLASSIFIED_EXT_PY 285
NEGLIGIBLE_RISK_FILE_SIZE_COUNT 4
LOW_RISK_FILE_SIZE_COUNT 7
MEDIUM_RISK_FILE_SIZE_COUNT 6
HIGH_RISK_FILE_SIZE_COUNT 1
VERY_HIGH_RISK_FILE_SIZE_COUNT 0
NEGLIGIBLE_RISK_FILE_SIZE_LOC 289
LOW_RISK_FILE_SIZE_LOC 947
MEDIUM_RISK_FILE_SIZE_LOC 1,698
HIGH_RISK_FILE_SIZE_LOC 647
VERY_HIGH_RISK_FILE_SIZE_LOC 0
FILE_CHANGE_HISTORY_TOTAL_AGE_DAYS 1,239
FILE_CHANGE_HISTORY_ACTIVE_DAYS 39
FILE_CHANGE_HISTORY_WEEKS 158
FILE_CHANGE_HISTORY_ESTIMATED_WORKING_DAYS 790
FILE_AGE_NEGLIGIBLE_RISK_COUNT 0
FILE_AGE_LOW_RISK_COUNT 0
FILE_AGE_MEDIUM_RISK_COUNT 0
FILE_AGE_HIGH_RISK_COUNT 0
FILE_AGE_VERY_HIGH_RISK_COUNT 18
FILE_AGE_NEGLIGIBLE_RISK_LOC 0
FILE_AGE_LOW_RISK_LOC 0
FILE_AGE_MEDIUM_RISK_LOC 0
FILE_AGE_HIGH_RISK_LOC 0
FILE_AGE_VERY_HIGH_RISK_LOC 3,581
NUMBER_OF_CONTRIBUTORS 4
NUMBER_OF_UNITS 4
LINES_OF_CODE_IN_UNITS 164
LINES_OF_CODE_OUTSIDE_UNITS 3,417
UNIT_SIZE_NEGLIGIBLE_RISK_LOC 2
UNIT_SIZE_NEGLIGIBLE_RISK_PERCENTAGE 1.22
UNIT_SIZE_NEGLIGIBLE_RISK_COUNT 1
UNIT_SIZE_LOW_RISK_LOC 15
UNIT_SIZE_LOW_RISK_PERCENTAGE 9.15
UNIT_SIZE_LOW_RISK_COUNT 1
UNIT_SIZE_MEDIUM_RISK_LOC 0
UNIT_SIZE_MEDIUM_RISK_PERCENTAGE 0
UNIT_SIZE_MEDIUM_RISK_COUNT 0
UNIT_SIZE_HIGH_RISK_LOC 147
UNIT_SIZE_HIGH_RISK_PERCENTAGE 89.63
UNIT_SIZE_HIGH_RISK_COUNT 2
UNIT_SIZE_VERY_HIGH_RISK_LOC 0
UNIT_SIZE_VERY_HIGH_RISK_PERCENTAGE 0
UNIT_SIZE_VERY_HIGH_RISK_COUNT 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_NEGLIGIBLE_RISK_LOC 2
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_NEGLIGIBLE_RISK_PERCENTAGE 2.04
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_NEGLIGIBLE_RISK_COUNT 1
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_LOW_RISK_LOC 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_LOW_RISK_PERCENTAGE 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_LOW_RISK_COUNT 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_MEDIUM_RISK_LOC 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_MEDIUM_RISK_PERCENTAGE 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_MEDIUM_RISK_COUNT 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_HIGH_RISK_LOC 96
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_HIGH_RISK_PERCENTAGE 97.96
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_HIGH_RISK_COUNT 1
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_VERY_HIGH_RISK_LOC 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_VERY_HIGH_RISK_PERCENTAGE 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_VERY_HIGH_RISK_COUNT 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_NEGLIGIBLE_RISK_LOC 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_NEGLIGIBLE_RISK_PERCENTAGE 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_NEGLIGIBLE_RISK_COUNT 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_LOW_RISK_LOC 15
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_LOW_RISK_PERCENTAGE 22.73
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_LOW_RISK_COUNT 1
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_MEDIUM_RISK_LOC 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_MEDIUM_RISK_PERCENTAGE 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_MEDIUM_RISK_COUNT 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_HIGH_RISK_LOC 51
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_HIGH_RISK_PERCENTAGE 77.27
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_HIGH_RISK_COUNT 1
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_VERY_HIGH_RISK_LOC 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_VERY_HIGH_RISK_PERCENTAGE 0
UNIT_SIZE_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_VERY_HIGH_RISK_COUNT 0
UNIT_SIZE_EXTENSION_PY_NEGLIGIBLE_RISK_LOC 2
UNIT_SIZE_EXTENSION_PY_NEGLIGIBLE_RISK_PERCENTAGE 1.22
UNIT_SIZE_EXTENSION_PY_NEGLIGIBLE_RISK_COUNT 1
UNIT_SIZE_EXTENSION_PY_LOW_RISK_LOC 15
UNIT_SIZE_EXTENSION_PY_LOW_RISK_PERCENTAGE 9.15
UNIT_SIZE_EXTENSION_PY_LOW_RISK_COUNT 1
UNIT_SIZE_EXTENSION_PY_MEDIUM_RISK_LOC 0
UNIT_SIZE_EXTENSION_PY_MEDIUM_RISK_PERCENTAGE 0
UNIT_SIZE_EXTENSION_PY_MEDIUM_RISK_COUNT 0
UNIT_SIZE_EXTENSION_PY_HIGH_RISK_LOC 147
UNIT_SIZE_EXTENSION_PY_HIGH_RISK_PERCENTAGE 89.63
UNIT_SIZE_EXTENSION_PY_HIGH_RISK_COUNT 2
UNIT_SIZE_EXTENSION_PY_VERY_HIGH_RISK_LOC 0
UNIT_SIZE_EXTENSION_PY_VERY_HIGH_RISK_PERCENTAGE 0
UNIT_SIZE_EXTENSION_PY_VERY_HIGH_RISK_COUNT 0
CONDITIONAL_COMPLEXITY_NEGLIGIBLE_RISK_LOC 68
CONDITIONAL_COMPLEXITY_NEGLIGIBLE_RISK_PERCENTAGE 41.46
CONDITIONAL_COMPLEXITY_NEGLIGIBLE_RISK_COUNT 3
CONDITIONAL_COMPLEXITY_LOW_RISK_LOC 0
CONDITIONAL_COMPLEXITY_LOW_RISK_PERCENTAGE 0
CONDITIONAL_COMPLEXITY_LOW_RISK_COUNT 0
CONDITIONAL_COMPLEXITY_MEDIUM_RISK_LOC 0
CONDITIONAL_COMPLEXITY_MEDIUM_RISK_PERCENTAGE 0
CONDITIONAL_COMPLEXITY_MEDIUM_RISK_COUNT 0
CONDITIONAL_COMPLEXITY_HIGH_RISK_LOC 96
CONDITIONAL_COMPLEXITY_HIGH_RISK_PERCENTAGE 58.54
CONDITIONAL_COMPLEXITY_HIGH_RISK_COUNT 1
CONDITIONAL_COMPLEXITY_VERY_HIGH_RISK_LOC 0
CONDITIONAL_COMPLEXITY_VERY_HIGH_RISK_PERCENTAGE 0
CONDITIONAL_COMPLEXITY_VERY_HIGH_RISK_COUNT 0
CONDITIONAL_COMPLEXITY_HIGH_PLUS_RISK_COUNT 1
CONDITIONAL_COMPLEXITY_HIGH_PLUS_RISK_LOC 96
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_NEGLIGIBLE_RISK_LOC 2
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_NEGLIGIBLE_RISK_PERCENTAGE 2.04
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_NEGLIGIBLE_RISK_COUNT 1
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_LOW_RISK_LOC 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_LOW_RISK_PERCENTAGE 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_LOW_RISK_COUNT 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_MEDIUM_RISK_LOC 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_MEDIUM_RISK_PERCENTAGE 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_MEDIUM_RISK_COUNT 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_HIGH_RISK_LOC 96
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_HIGH_RISK_PERCENTAGE 97.96
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_HIGH_RISK_COUNT 1
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_VERY_HIGH_RISK_LOC 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_VERY_HIGH_RISK_PERCENTAGE 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS_VERY_HIGH_RISK_COUNT 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_NEGLIGIBLE_RISK_LOC 66
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_NEGLIGIBLE_RISK_PERCENTAGE 100
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_NEGLIGIBLE_RISK_COUNT 2
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_LOW_RISK_LOC 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_LOW_RISK_PERCENTAGE 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_LOW_RISK_COUNT 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_MEDIUM_RISK_LOC 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_MEDIUM_RISK_PERCENTAGE 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_MEDIUM_RISK_COUNT 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_HIGH_RISK_LOC 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_HIGH_RISK_PERCENTAGE 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_HIGH_RISK_COUNT 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_VERY_HIGH_RISK_LOC 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_VERY_HIGH_RISK_PERCENTAGE 0
CONDITIONAL_COMPLEXITY_COMPONENT_APS_TO_SQL_DW_MIGRATION_SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS_VERY_HIGH_RISK_COUNT 0
CONDITIONAL_COMPLEXITY_COMPONENT_PY_NEGLIGIBLE_RISK_LOC 68
CONDITIONAL_COMPLEXITY_COMPONENT_PY_NEGLIGIBLE_RISK_PERCENTAGE 41.46
CONDITIONAL_COMPLEXITY_COMPONENT_PY_NEGLIGIBLE_RISK_COUNT 3
CONDITIONAL_COMPLEXITY_COMPONENT_PY_LOW_RISK_LOC 0
CONDITIONAL_COMPLEXITY_COMPONENT_PY_LOW_RISK_PERCENTAGE 0
CONDITIONAL_COMPLEXITY_COMPONENT_PY_LOW_RISK_COUNT 0
CONDITIONAL_COMPLEXITY_COMPONENT_PY_MEDIUM_RISK_LOC 0
CONDITIONAL_COMPLEXITY_COMPONENT_PY_MEDIUM_RISK_PERCENTAGE 0
CONDITIONAL_COMPLEXITY_COMPONENT_PY_MEDIUM_RISK_COUNT 0
CONDITIONAL_COMPLEXITY_COMPONENT_PY_HIGH_RISK_LOC 96
CONDITIONAL_COMPLEXITY_COMPONENT_PY_HIGH_RISK_PERCENTAGE 58.54
CONDITIONAL_COMPLEXITY_COMPONENT_PY_HIGH_RISK_COUNT 1
CONDITIONAL_COMPLEXITY_COMPONENT_PY_VERY_HIGH_RISK_LOC 0
CONDITIONAL_COMPLEXITY_COMPONENT_PY_VERY_HIGH_RISK_PERCENTAGE 0
CONDITIONAL_COMPLEXITY_COMPONENT_PY_VERY_HIGH_RISK_COUNT 0
DUPLICATION_NUMBER_OF_DUPLICATES 55
DUPLICATION_NUMBER_OF_FILES_WITH_DUPLICATES 17
DUPLICATION_NUMBER_OF_DUPLICATED_LINES 1,034
DUPLICATION_NUMBER_OF_CLEANED_LINES 3,569
DUPLICATION_PERCENTAGE 28.97
UNIT_DUPLICATES_COUNT 0
DUPLICATION_NUMBER_OF_DUPLICATED_LINES_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_5_CREATEEXTERNALTABLESSQLDW 262
DUPLICATION_NUMBER_OF_CLEANED_LINES_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_5_CREATEEXTERNALTABLESSQLDW 262
DUPLICATION_PERCENTAGE_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_5_CREATEEXTERNALTABLESSQLDW 100
DUPLICATION_NUMBER_OF_DUPLICATED_LINES_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_6_DEPLOYSCRIPTSTOSQLDW 219
DUPLICATION_NUMBER_OF_CLEANED_LINES_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_6_DEPLOYSCRIPTSTOSQLDW 219
DUPLICATION_PERCENTAGE_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_6_DEPLOYSCRIPTSTOSQLDW 100
DUPLICATION_NUMBER_OF_DUPLICATED_LINES_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_4_CREATEAPSEXPORTSCRIPTSQLDWIMPORTSCRIPT 230
DUPLICATION_NUMBER_OF_CLEANED_LINES_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_4_CREATEAPSEXPORTSCRIPTSQLDWIMPORTSCRIPT 230
DUPLICATION_PERCENTAGE_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_4_CREATEAPSEXPORTSCRIPTSQLDWIMPORTSCRIPT 100
DUPLICATION_NUMBER_OF_DUPLICATED_LINES_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS 43
DUPLICATION_NUMBER_OF_CLEANED_LINES_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS 43
DUPLICATION_PERCENTAGE_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_2_CLEANSCRIPTS 100
DUPLICATION_NUMBER_OF_DUPLICATED_LINES_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS 43
DUPLICATION_NUMBER_OF_CLEANED_LINES_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS 43
DUPLICATION_PERCENTAGE_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_3_CHANGESCHEMAS 100
DUPLICATION_NUMBER_OF_DUPLICATED_LINES_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_0_PREASSESSMENT 87
DUPLICATION_NUMBER_OF_CLEANED_LINES_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_0_PREASSESSMENT 87
DUPLICATION_PERCENTAGE_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_0_PREASSESSMENT 100
DUPLICATION_NUMBER_OF_DUPLICATED_LINES_PRIMARY_ASSESSMENT 140
DUPLICATION_NUMBER_OF_CLEANED_LINES_PRIMARY_ASSESSMENT 140
DUPLICATION_PERCENTAGE_PRIMARY_ASSESSMENT 100
DUPLICATION_NUMBER_OF_DUPLICATED_LINES_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_1_CREATEMPPSCRIPTS 10
DUPLICATION_NUMBER_OF_CLEANED_LINES_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_1_CREATEMPPSCRIPTS 10
DUPLICATION_PERCENTAGE_PRIMARY_APS_TO_SQL_DW_MIGRATION___SCHEMA_AND_DATA_MIGRATION_WITH_POLYBASE_1_CREATEMPPSCRIPTS 100
DUPLICATION_NUMBER_OF_DUPLICATED_LINES_PS1 948
DUPLICATION_NUMBER_OF_CLEANED_LINES_PS1 3,296
DUPLICATION_PERCENTAGE_PS1 28.76
DUPLICATION_NUMBER_OF_DUPLICATED_LINES_PY 86
DUPLICATION_NUMBER_OF_CLEANED_LINES_PY 273
DUPLICATION_PERCENTAGE_PY 31.5
TOTAL_ANALYSIS_TIME_IN_MILLIS 500