File age measurements show the distribution of file ages (days since the first commit) and the recency of file updates (days since the latest commit).
Summary
- Number of files: 18
- Daily file updates (only one update per file and date counted): 172
- First update: 2018-09-10
- Latest update: 2021-09-20
- Days between first and latest update: 1107 (158 weeks, estimated 790 working days)
- Active days (at least one file change): 39
- Data:
File Change History Overall
File Age Distribution Overall
Days since first update
- There are 18 files with 3,581 lines of code in files.
- 18 files that are 366+ days old (3,581 lines of code)
- 0 files that are 181-365 days old (0 lines of code)
- 0 files that are 91-180 days old (0 lines of code)
- 0 files that are 31-90 days old (0 lines of code)
- 0 files that are 1-30 days old (0 lines of code)
Legend:
366+
181-365
91-180
31-90
1-30
Latest Change Distribution Overall
Days since last update
- There are 18 files with 3,581 lines of code in files.
- 18 files have been last changed 366+ days ago (3,581 lines of code)
- 0 files have been last changed 181-365 days ago (0 lines of code)
- 0 files have been last changed 91-180 days ago (0 lines of code)
- 0 files have been last changed 31-90 days ago (0 lines of code)
- 0 files have been last changed 1-30 days ago (0 lines of code)
Legend:
366+
181-365
91-180
31-90
1-30
File Change History per File Extension
sql, ps1, md, gitignore, json, py, txt
File Age Distribution per Extension
Days since first update
366+
181-365
91-180
31-90
1-30
Latest Change Distribution per Extension
Days since last update
366+
181-365
91-180
31-90
1-30
File Change History per Logical Decomposition
primary
primary (file age distribution)
Days since first update
366+
181-365
91-180
31-90
1-30
primary (latest change distribution)
Days since last update
366+
181-365
91-180
31-90
1-30
Oldest Files (Top 18)
| File | # lines | # units | last modified (days ago) | created (days ago) | # changes |
|---|---|---|---|---|---|
 Generate_Step6_ConfigFiles.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw |
409 | - | 1175 | 1238 | 3 |
RunDSQLScriptsDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw |
267 | - | 808 | 1238 | 8 |
Generate_Step4_ConfigFiles.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript |
252 | - | 1176 | 1238 | 3 |
Generate_Step5_ConfigFiles.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW |
246 | - | 1176 | 1238 | 3 |
RunSQLStatementExportCSV.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment |
222 | - | 1238 | 1238 | 1 |
 CleanScripts.py in APS to SQL DW Migration - Schema and Data Migration with PolyBase/2_CleanScripts |
153 | 2 | 711 | 1238 | 2 |
RunSQLScriptFile.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw |
140 | - | 1189 | 1238 | 3 |
ChangeSchemas.py in APS to SQL DW Migration - Schema and Data Migration with PolyBase/3_ChangeSchemas |
132 | 2 | 1238 | 1238 | 1 |
ScriptCreateExportImportStatementsDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript |
123 | - | 1176 | 1238 | 2 |
ScriptMPPObjectsDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/1_CreateMPPScripts |
106 | - | 1139 | 1238 | 3 |
CopyDataToExcel.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment |
102 | - | 1238 | 1238 | 1 |
PreAssessmentDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment |
94 | - | 1201 | 1238 | 2 |
CreateSQLDWExtTableStatements.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW |
91 | - | 1238 | 1238 | 1 |
ScriptCreateExternalTableDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW |
70 | - | 1176 | 1238 | 2 |
ScriptObjectsTodSQL.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/1_CreateMPPScripts |
34 | - | 1139 | 1238 | 2 |
AssessmentDriver_V2.ps1 in Assessment |
647 | - | 556 | 1139 | 8 |
CopyDataToExcel_V2.ps1 in Assessment |
302 | - | 1139 | 1139 | 1 |
RunSQLStatement.ps1 in Assessment |
191 | - | 885 | 1139 | 2 |
Files Not Recently Changed (Top 18)
| File | # lines | # units | last modified (days ago) | created (days ago) | # changes |
|---|---|---|---|---|---|
CreateSQLDWExtTableStatements.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW |
91 | - | 1238 | 1238 | 1 |
CopyDataToExcel.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment |
102 | - | 1238 | 1238 | 1 |
ChangeSchemas.py in APS to SQL DW Migration - Schema and Data Migration with PolyBase/3_ChangeSchemas |
132 | 2 | 1238 | 1238 | 1 |
RunSQLStatementExportCSV.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment |
222 | - | 1238 | 1238 | 1 |
PreAssessmentDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment |
94 | - | 1201 | 1238 | 2 |
RunSQLScriptFile.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw |
140 | - | 1189 | 1238 | 3 |
ScriptCreateExternalTableDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW |
70 | - | 1176 | 1238 | 2 |
ScriptCreateExportImportStatementsDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript |
123 | - | 1176 | 1238 | 2 |
Generate_Step5_ConfigFiles.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW |
246 | - | 1176 | 1238 | 3 |
Generate_Step4_ConfigFiles.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript |
252 | - | 1176 | 1238 | 3 |
Generate_Step6_ConfigFiles.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw |
409 | - | 1175 | 1238 | 3 |
ScriptObjectsTodSQL.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/1_CreateMPPScripts |
34 | - | 1139 | 1238 | 2 |
ScriptMPPObjectsDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/1_CreateMPPScripts |
106 | - | 1139 | 1238 | 3 |
CopyDataToExcel_V2.ps1 in Assessment |
302 | - | 1139 | 1139 | 1 |
RunSQLStatement.ps1 in Assessment |
191 | - | 885 | 1139 | 2 |
RunDSQLScriptsDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw |
267 | - | 808 | 1238 | 8 |
CleanScripts.py in APS to SQL DW Migration - Schema and Data Migration with PolyBase/2_CleanScripts |
153 | 2 | 711 | 1238 | 2 |
AssessmentDriver_V2.ps1 in Assessment |
647 | - | 556 | 1139 | 8 |
Most Recently Created Files (Top 18)
| File | # lines | # units | last modified (days ago) | created (days ago) | # changes |
|---|---|---|---|---|---|
AssessmentDriver_V2.ps1 in Assessment |
647 | - | 556 | 1139 | 8 |
CopyDataToExcel_V2.ps1 in Assessment |
302 | - | 1139 | 1139 | 1 |
RunSQLStatement.ps1 in Assessment |
191 | - | 885 | 1139 | 2 |
Generate_Step6_ConfigFiles.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw |
409 | - | 1175 | 1238 | 3 |
RunDSQLScriptsDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw |
267 | - | 808 | 1238 | 8 |
Generate_Step4_ConfigFiles.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript |
252 | - | 1176 | 1238 | 3 |
Generate_Step5_ConfigFiles.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW |
246 | - | 1176 | 1238 | 3 |
RunSQLStatementExportCSV.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment |
222 | - | 1238 | 1238 | 1 |
CleanScripts.py in APS to SQL DW Migration - Schema and Data Migration with PolyBase/2_CleanScripts |
153 | 2 | 711 | 1238 | 2 |
RunSQLScriptFile.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw |
140 | - | 1189 | 1238 | 3 |
ChangeSchemas.py in APS to SQL DW Migration - Schema and Data Migration with PolyBase/3_ChangeSchemas |
132 | 2 | 1238 | 1238 | 1 |
ScriptCreateExportImportStatementsDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript |
123 | - | 1176 | 1238 | 2 |
ScriptMPPObjectsDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/1_CreateMPPScripts |
106 | - | 1139 | 1238 | 3 |
CopyDataToExcel.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment |
102 | - | 1238 | 1238 | 1 |
PreAssessmentDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment |
94 | - | 1201 | 1238 | 2 |
CreateSQLDWExtTableStatements.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW |
91 | - | 1238 | 1238 | 1 |
ScriptCreateExternalTableDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW |
70 | - | 1176 | 1238 | 2 |
ScriptObjectsTodSQL.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/1_CreateMPPScripts |
34 | - | 1139 | 1238 | 2 |
Most Recently Changed Files (Top 18)
| File | # lines | # units | last modified (days ago) | created (days ago) | # changes |
|---|---|---|---|---|---|
AssessmentDriver_V2.ps1 in Assessment |
647 | - | 556 | 1139 | 8 |
CleanScripts.py in APS to SQL DW Migration - Schema and Data Migration with PolyBase/2_CleanScripts |
153 | 2 | 711 | 1238 | 2 |
RunDSQLScriptsDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw |
267 | - | 808 | 1238 | 8 |
RunSQLStatement.ps1 in Assessment |
191 | - | 885 | 1139 | 2 |
CopyDataToExcel_V2.ps1 in Assessment |
302 | - | 1139 | 1139 | 1 |
ScriptMPPObjectsDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/1_CreateMPPScripts |
106 | - | 1139 | 1238 | 3 |
ScriptObjectsTodSQL.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/1_CreateMPPScripts |
34 | - | 1139 | 1238 | 2 |
Generate_Step6_ConfigFiles.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw |
409 | - | 1175 | 1238 | 3 |
Generate_Step4_ConfigFiles.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript |
252 | - | 1176 | 1238 | 3 |
Generate_Step5_ConfigFiles.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW |
246 | - | 1176 | 1238 | 3 |
ScriptCreateExportImportStatementsDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/4_CreateAPSExportScriptSQLDWImportScript |
123 | - | 1176 | 1238 | 2 |
ScriptCreateExternalTableDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW |
70 | - | 1176 | 1238 | 2 |
RunSQLScriptFile.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/6_DeployScriptsToSqldw |
140 | - | 1189 | 1238 | 3 |
PreAssessmentDriver.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment |
94 | - | 1201 | 1238 | 2 |
RunSQLStatementExportCSV.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment |
222 | - | 1238 | 1238 | 1 |
ChangeSchemas.py in APS to SQL DW Migration - Schema and Data Migration with PolyBase/3_ChangeSchemas |
132 | 2 | 1238 | 1238 | 1 |
CopyDataToExcel.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/0_PreAssessment |
102 | - | 1238 | 1238 | 1 |
CreateSQLDWExtTableStatements.ps1 in APS to SQL DW Migration - Schema and Data Migration with PolyBase/5_CreateExternalTablesSQLDW |
91 | - | 1238 | 1238 | 1 |