• 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 18 files with 3,581 lines of code.
• 0 very long files (0 lines of code)
• 1 long files (647 lines of code)
• 6 medium size files (1,698 lines of codeclsfd_ftr_w_mp_ins)
• 7 small files (947 lines of code)
• 4 very small files (289 lines of code)

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

File	# lines	# units	# long lines
AssessmentDriver_V2.ps1 in Assessment	647	-	51
RunSQLStatementExportCSV.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment	222	-	46
CopyDataToExcel_V2.ps1 in Assessment	302	-	31
RunDSQLScriptsDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw	267	-	30
PreAssessmentDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment	94	-	17
CopyDataToExcel.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment	102	-	16
ScriptCreateExportImportStatementsDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript	123	-	16
ScriptCreateExternalTableDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW	70	-	14
CreateSQLDWExtTableStatements.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW	91	-	12
Generate_Step6_ConfigFiles.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw	409	-	11
RunSQLStatement.ps1 in Assessment	191	-	11
ScriptMPPObjectsDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/1_CreateMPPScripts	106	-	9
RunSQLScriptFile.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw	140	-	7
Generate_Step4_ConfigFiles.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript	252	-	6
ScriptObjectsTodSQL.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/1_CreateMPPScripts	34	-	4
ChangeSchemas.py in APS to SQL DW Migration - Schema and Data Migration with PolyBase/3_ChangeSchemas	132	2	4
Generate_Step5_ConfigFiles.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW	246	-	4
CleanScripts.py in APS to SQL DW Migration - Schema and Data Migration with PolyBase/2_CleanScripts	153	2	3