azure / Databricks360
File Change Frequency

File change frequency (churn) shows the distribution of file updates (days with at least one commit).

Overview
File Change Frequency Overall
  • There are 26 files with 1,195 lines of code.
    • 0 files changed more than 100 times (0 lines of code)
    • 0 files changed 51-100 times (0 lines of code)
    • 0 files changed 21-50 times (0 lines of code)
    • 0 files changed 6-20 times (0 lines of code)
    • 26 files changed 1-5 times (1,195 lines of code)
0% | 0% | 0% | 0% | 100%
Legend:
101+
51-100
21-50
6-20
1-5

explore: grouped by folders | grouped by update frequency | data
Contributors Count Frequency Overall
  • There are 26 files with 1,195 lines of code.
    • 0 files changed by more than 25 contributors (0 lines of code)
    • 0 files changed by 11-25 contributors (0 lines of code)
    • 0 files changed by 6-10 contributors (0 lines of code)
    • 25 files changed by 2-5 contributors (1,032 lines of code)
    • 1 file changed by 1 contributor (163 lines of code)
0% | 0% | 0% | 86% | 13%
Legend:
26+
11-25
6-10
2-5
1

explore: grouped by folders | grouped by contributors count | data
File Change Frequency per File Extension
py, md, yaml, sh, sql, json, gitignore, txt
File Change Frequency per Extension
The number of recorded file updates
101+
51-100
21-50
6-20
1-5
py0% | 0% | 0% | 0% | 100%
sql0% | 0% | 0% | 0% | 100%
File Change Frequency per Logical Decomposition
primary
primary (file change frequency)
The number of recorded file updates
101+
51-100
21-50
6-20
1-5
bundle_adb_3600% | 0% | 0% | 0% | 100%
content-adb-3600% | 0% | 0% | 0% | 100%
Most Frequently Changed Files (Top 26)

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
2_goldtables.py
in content-adb-360/tools/views
 17 - 2024-02-09 2024-05-13 4 2 chrey-gh 58181624+chrey-gh@users.nor...
12_applyIncrementalToSilver.py
in bundle_adb_360/src/c_Incremental
 35 - 2024-05-20 2024-05-23 4 3 chrey@microsoft.com 58181624+chrey-gh@users.nor...
11_IncDataGeneration.py
in bundle_adb_360/src/c_Incremental
 72 3 2024-05-20 2024-05-23 4 3 chrey@microsoft.com 58181624+chrey-gh@users.nor...
0_instrumentation.py
in bundle_adb_360/src/tools
 1 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
0_instrumentation.py
in content-adb-360/tools
 1 - 2024-02-09 2024-02-12 2 2 chrey-gh 58181624+chrey-gh@users.nor...
3a_deletallgold.sql
in bundle_adb_360/src/b_historical
 2 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
2a_deletallsilver.sql
in bundle_adb_360/src/b_historical
 2 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
10_IncDataDeleteOnBronze.py
in bundle_adb_360/src/c_Incremental
 8 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
bronze-volume-setup.sql
in bundle_adb_360/src/a_init
 8 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
0_deleteAllHistorical.py
in bundle_adb_360/src/b_historical
 9 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
0_bronzetables.py
in bundle_adb_360/src/tools/views
 16 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
1_silvertables.py
in bundle_adb_360/src/tools/views
 16 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
0_bronzetables.py
in content-adb-360/tools/views
 16 - 2024-02-09 2024-02-12 2 2 chrey-gh 58181624+chrey-gh@users.nor...
1_silvertables.py
in content-adb-360/tools/views
 16 - 2024-02-09 2024-02-12 2 2 chrey-gh 58181624+chrey-gh@users.nor...
2c_moveToSilverHist.py
in bundle_adb_360/src/b_historical
 17 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
2_goldtables.py
in bundle_adb_360/src/tools/views
 17 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
3e_loadFactsHist.py
in bundle_adb_360/src/b_historical
 38 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
2b_createsilverdbandtables.sql
in bundle_adb_360/src/b_historical
 51 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
3b_creategolddbandtables.sql
in bundle_adb_360/src/b_historical
 64 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
3d_loadSCD2DimensionsHist.py
in bundle_adb_360/src/b_historical
 68 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
13_Scd1ToGold.py
in bundle_adb_360/src/c_Incremental
 79 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
3c_loadSCD1DimensionsHist.py
in bundle_adb_360/src/b_historical
 94 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
1_createhistbronzeparquets.py
in bundle_adb_360/src/b_historical
 94 4 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
14_Scd2ToGold.py
in bundle_adb_360/src/c_Incremental
 128 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
163 2 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
163 2 2024-01-29 2024-01-29 1 1 chrey@microsoft.com chrey@microsoft.com
Files With Most Contributors (Top 26)
Based on the number of unique email addresses found in commits.

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
12_applyIncrementalToSilver.py
in bundle_adb_360/src/c_Incremental
 35 - 2024-05-20 2024-05-23 4 3 chrey@microsoft.com 58181624+chrey-gh@users.nor...
11_IncDataGeneration.py
in bundle_adb_360/src/c_Incremental
 72 3 2024-05-20 2024-05-23 4 3 chrey@microsoft.com 58181624+chrey-gh@users.nor...
2_goldtables.py
in content-adb-360/tools/views
 17 - 2024-02-09 2024-05-13 4 2 chrey-gh 58181624+chrey-gh@users.nor...
1_silvertables.py
in content-adb-360/tools/views
 16 - 2024-02-09 2024-02-12 2 2 chrey-gh 58181624+chrey-gh@users.nor...
0_bronzetables.py
in content-adb-360/tools/views
 16 - 2024-02-09 2024-02-12 2 2 chrey-gh 58181624+chrey-gh@users.nor...
0_instrumentation.py
in content-adb-360/tools
 1 - 2024-02-09 2024-02-12 2 2 chrey-gh 58181624+chrey-gh@users.nor...
1_silvertables.py
in bundle_adb_360/src/tools/views
 16 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
0_bronzetables.py
in bundle_adb_360/src/tools/views
 16 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
2_goldtables.py
in bundle_adb_360/src/tools/views
 17 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
0_instrumentation.py
in bundle_adb_360/src/tools
 1 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
163 2 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
3e_loadFactsHist.py
in bundle_adb_360/src/b_historical
 38 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
2a_deletallsilver.sql
in bundle_adb_360/src/b_historical
 2 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
1_createhistbronzeparquets.py
in bundle_adb_360/src/b_historical
 94 4 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
3c_loadSCD1DimensionsHist.py
in bundle_adb_360/src/b_historical
 94 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
0_deleteAllHistorical.py
in bundle_adb_360/src/b_historical
 9 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
2b_createsilverdbandtables.sql
in bundle_adb_360/src/b_historical
 51 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
3d_loadSCD2DimensionsHist.py
in bundle_adb_360/src/b_historical
 68 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
3a_deletallgold.sql
in bundle_adb_360/src/b_historical
 2 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
2c_moveToSilverHist.py
in bundle_adb_360/src/b_historical
 17 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
3b_creategolddbandtables.sql
in bundle_adb_360/src/b_historical
 64 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
bronze-volume-setup.sql
in bundle_adb_360/src/a_init
 8 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
13_Scd1ToGold.py
in bundle_adb_360/src/c_Incremental
 79 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
14_Scd2ToGold.py
in bundle_adb_360/src/c_Incremental
 128 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
10_IncDataDeleteOnBronze.py
in bundle_adb_360/src/c_Incremental
 8 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
163 2 2024-01-29 2024-01-29 1 1 chrey@microsoft.com chrey@microsoft.com
Files With Least Contributors (Top 26)
Based on the number of unique email addresses found in commits.

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
163 2 2024-01-29 2024-01-29 1 1 chrey@microsoft.com chrey@microsoft.com
163 2 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
14_Scd2ToGold.py
in bundle_adb_360/src/c_Incremental
 128 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
1_createhistbronzeparquets.py
in bundle_adb_360/src/b_historical
 94 4 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
3c_loadSCD1DimensionsHist.py
in bundle_adb_360/src/b_historical
 94 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
13_Scd1ToGold.py
in bundle_adb_360/src/c_Incremental
 79 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
3d_loadSCD2DimensionsHist.py
in bundle_adb_360/src/b_historical
 68 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
3b_creategolddbandtables.sql
in bundle_adb_360/src/b_historical
 64 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
2b_createsilverdbandtables.sql
in bundle_adb_360/src/b_historical
 51 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
3e_loadFactsHist.py
in bundle_adb_360/src/b_historical
 38 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
2_goldtables.py
in content-adb-360/tools/views
 17 - 2024-02-09 2024-05-13 4 2 chrey-gh 58181624+chrey-gh@users.nor...
2_goldtables.py
in bundle_adb_360/src/tools/views
 17 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
2c_moveToSilverHist.py
in bundle_adb_360/src/b_historical
 17 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
1_silvertables.py
in content-adb-360/tools/views
 16 - 2024-02-09 2024-02-12 2 2 chrey-gh 58181624+chrey-gh@users.nor...
0_bronzetables.py
in content-adb-360/tools/views
 16 - 2024-02-09 2024-02-12 2 2 chrey-gh 58181624+chrey-gh@users.nor...
1_silvertables.py
in bundle_adb_360/src/tools/views
 16 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
0_bronzetables.py
in bundle_adb_360/src/tools/views
 16 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
0_deleteAllHistorical.py
in bundle_adb_360/src/b_historical
 9 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
bronze-volume-setup.sql
in bundle_adb_360/src/a_init
 8 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
10_IncDataDeleteOnBronze.py
in bundle_adb_360/src/c_Incremental
 8 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
2a_deletallsilver.sql
in bundle_adb_360/src/b_historical
 2 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
3a_deletallgold.sql
in bundle_adb_360/src/b_historical
 2 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
0_instrumentation.py
in content-adb-360/tools
 1 - 2024-02-09 2024-02-12 2 2 chrey-gh 58181624+chrey-gh@users.nor...
0_instrumentation.py
in bundle_adb_360/src/tools
 1 - 2024-05-20 2024-05-21 2 2 chrey@microsoft.com 58181624+chrey-gh@users.nor...
11_IncDataGeneration.py
in bundle_adb_360/src/c_Incremental
 72 3 2024-05-20 2024-05-23 4 3 chrey@microsoft.com 58181624+chrey-gh@users.nor...
12_applyIncrementalToSilver.py
in bundle_adb_360/src/c_Incremental
 35 - 2024-05-20 2024-05-23 4 3 chrey@microsoft.com 58181624+chrey-gh@users.nor...
Correlations

File Size vs. Number of Changes: 26 points

bundle_adb_360/src/c_Incremental/11_IncDataGeneration.py x: 72 lines of code y: 4 # changes bundle_adb_360/src/c_Incremental/12_applyIncrementalToSilver.py x: 35 lines of code y: 4 # changes bundle_adb_360/src/a_init/bronze-volume-setup.sql x: 8 lines of code y: 2 # changes bundle_adb_360/src/b_historical/0_deleteAllHistorical.py x: 9 lines of code y: 2 # changes bundle_adb_360/src/b_historical/1_createhistbronzeparquets.py x: 94 lines of code y: 2 # changes bundle_adb_360/src/b_historical/2a_deletallsilver.sql x: 2 lines of code y: 2 # changes bundle_adb_360/src/b_historical/2b_createsilverdbandtables.sql x: 51 lines of code y: 2 # changes bundle_adb_360/src/b_historical/2c_moveToSilverHist.py x: 17 lines of code y: 2 # changes bundle_adb_360/src/b_historical/3b_creategolddbandtables.sql x: 64 lines of code y: 2 # changes bundle_adb_360/src/b_historical/3d_loadSCD2DimensionsHist.py x: 68 lines of code y: 2 # changes bundle_adb_360/src/b_historical/3e_loadFactsHist.py x: 38 lines of code y: 2 # changes bundle_adb_360/src/c_Incremental/13_Scd1ToGold.py x: 79 lines of code y: 2 # changes bundle_adb_360/src/c_Incremental/14_Scd2ToGold.py x: 128 lines of code y: 2 # changes bundle_adb_360/src/tools/0_instrumentation.py x: 1 lines of code y: 2 # changes bundle_adb_360/src/tools/azure-diagnostic-logs-etl-unity-catalog.py x: 163 lines of code y: 2 # changes bundle_adb_360/src/tools/views/0_bronzetables.py x: 16 lines of code y: 2 # changes content-adb-360/tools/views/2_goldtables.py x: 17 lines of code y: 4 # changes content-adb-360/tools/azure-diagnostic-logs-etl-unity-catalog.py x: 163 lines of code y: 1 # changes
4.0
# changes
  min: 1.0
  average: 2.19
  25th percentile: 2.0
  median: 2.0
  75th percentile: 2.0
  max: 4.0
0 163.0
lines of code
min: 1.0 | average: 45.96 | 25th percentile: 8.75 | median: 17.0 | 75th percentile: 73.75 | max: 163.0

Number of Contributors vs. Number of Changes: 26 points

bundle_adb_360/src/c_Incremental/11_IncDataGeneration.py x: 3 # contributors y: 4 # changes bundle_adb_360/src/a_init/bronze-volume-setup.sql x: 2 # contributors y: 2 # changes content-adb-360/tools/views/2_goldtables.py x: 2 # contributors y: 4 # changes content-adb-360/tools/azure-diagnostic-logs-etl-unity-catalog.py x: 1 # contributors y: 1 # changes
4.0
# changes
  min: 1.0
  average: 2.19
  25th percentile: 2.0
  median: 2.0
  75th percentile: 2.0
  max: 4.0
0 3.0
# contributors
min: 1.0 | average: 2.04 | 25th percentile: 2.0 | median: 2.0 | 75th percentile: 2.0 | max: 3.0

Number of Contributors vs. File Size: 26 points

bundle_adb_360/src/c_Incremental/11_IncDataGeneration.py x: 3 # contributors y: 72 lines of code bundle_adb_360/src/c_Incremental/12_applyIncrementalToSilver.py x: 3 # contributors y: 35 lines of code bundle_adb_360/src/a_init/bronze-volume-setup.sql x: 2 # contributors y: 8 lines of code bundle_adb_360/src/b_historical/0_deleteAllHistorical.py x: 2 # contributors y: 9 lines of code bundle_adb_360/src/b_historical/1_createhistbronzeparquets.py x: 2 # contributors y: 94 lines of code bundle_adb_360/src/b_historical/2a_deletallsilver.sql x: 2 # contributors y: 2 lines of code bundle_adb_360/src/b_historical/2b_createsilverdbandtables.sql x: 2 # contributors y: 51 lines of code bundle_adb_360/src/b_historical/2c_moveToSilverHist.py x: 2 # contributors y: 17 lines of code bundle_adb_360/src/b_historical/3b_creategolddbandtables.sql x: 2 # contributors y: 64 lines of code bundle_adb_360/src/b_historical/3d_loadSCD2DimensionsHist.py x: 2 # contributors y: 68 lines of code bundle_adb_360/src/b_historical/3e_loadFactsHist.py x: 2 # contributors y: 38 lines of code bundle_adb_360/src/c_Incremental/13_Scd1ToGold.py x: 2 # contributors y: 79 lines of code bundle_adb_360/src/c_Incremental/14_Scd2ToGold.py x: 2 # contributors y: 128 lines of code bundle_adb_360/src/tools/0_instrumentation.py x: 2 # contributors y: 1 lines of code bundle_adb_360/src/tools/azure-diagnostic-logs-etl-unity-catalog.py x: 2 # contributors y: 163 lines of code bundle_adb_360/src/tools/views/0_bronzetables.py x: 2 # contributors y: 16 lines of code content-adb-360/tools/azure-diagnostic-logs-etl-unity-catalog.py x: 1 # contributors y: 163 lines of code
163.0
lines of code
  min: 1.0
  average: 45.96
  25th percentile: 8.75
  median: 17.0
  75th percentile: 73.75
  max: 163.0
0 3.0
# contributors
min: 1.0 | average: 2.04 | 25th percentile: 2.0 | median: 2.0 | 75th percentile: 2.0 | max: 3.0