azure / AnalyticsinaBox
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 17 files with 1,817 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)
    • 17 files changed 1-5 times (1,817 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 17 files with 1,817 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)
    • 13 files changed by 2-5 contributors (1,303 lines of code)
    • 4 files changed by 1 contributor (514 lines of code)
0% | 0% | 0% | 71% | 28%
Legend:
26+
11-25
6-10
2-5
1

explore: grouped by folders | grouped by contributors count | data
File Change Frequency per File Extension
json, md, sql, yaml, py, ipynb, ps1, txt, gitignore
File Change Frequency per Extension
The number of recorded file updates
101+
51-100
21-50
6-20
1-5
ps10% | 0% | 0% | 0% | 100%
sql0% | 0% | 0% | 0% | 100%
py0% | 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
Synapse0% | 0% | 0% | 0% | 100%
Fabric0% | 0% | 0% | 0% | 100%
Most Frequently Changed Files (Top 17)

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
create_mi_user_orcehstratordb.sql
in Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/post_pipeline_deployment_scripts
 2 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
create_mi_user_wwi.sql
in Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/post_pipeline_deployment_scripts
 3 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
create_database_and_schemas.sql
in Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/synapse_serverless_scripts
 5 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
recv-events.py
in Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/streaming
 20 - 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
send_event_for_synapsestreaming.py
in Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/streaming
 24 - 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
send-event-to-event-hub.py
in Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/streaming
 36 - 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
create_metadata_tables.sql
in Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/sql_scripts/PostDeployment
 40 - 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
created_view_serverless.sql
in Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/sql_scripts/PostDeployment
 42 - 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
__init__.py
in Synapse/src/bicep-deployment/Pattern3_streaming_ingestion/src/EventGeneratorApp/EventGenerator
 55 1 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
create_orchestrator_table.sql
in Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/orchestrator_scripts
 72 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
create-fabric-dw-views.sql
in Fabric/src/deployment/Pattern1and2/src/fabricdw
 91 - 2023-10-27 2023-10-30 2 1 57195527+jehayesms@users.no... 57195527+jehayesms@users.no...
create_source_views.sql
in Fabric/src/deployment/Pattern1and2/src/sql/1-wwi
 102 - 2023-10-27 2023-10-30 2 1 57195527+jehayesms@users.no... 57195527+jehayesms@users.no...
create_source_views.sql
in Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/wwi_source_scripts
 122 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
create-metadata-tables.sql
in Fabric/src/deployment/Pattern1and2/src/sql/2-metadatadb
 149 - 2023-10-27 2023-10-30 2 1 57195527+jehayesms@users.no... 57195527+jehayesms@users.no...
create-fabric-dw-objects.sql
in Fabric/src/deployment/Pattern1and2/src/fabricdw
 172 - 2023-10-27 2023-10-30 2 1 57195527+jehayesms@users.no... 57195527+jehayesms@users.no...
SynapseDeployArtifacts.ps1
in Synapse/src/bicep-deployment/Pattern1/PowerShellScripts
 441 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
SynapseDeployArtifacts.ps1
in Synapse/src/bicep-deployment/Pattern2/PowerShellScripts
 441 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
Files With Most Contributors (Top 17)
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
SynapseDeployArtifacts.ps1
in Synapse/src/bicep-deployment/Pattern2/PowerShellScripts
 441 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
create_orchestrator_table.sql
in Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/orchestrator_scripts
 72 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
create_source_views.sql
in Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/wwi_source_scripts
 122 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
create_mi_user_orcehstratordb.sql
in Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/post_pipeline_deployment_scripts
 2 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
create_mi_user_wwi.sql
in Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/post_pipeline_deployment_scripts
 3 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
create_database_and_schemas.sql
in Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/synapse_serverless_scripts
 5 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
create_metadata_tables.sql
in Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/sql_scripts/PostDeployment
 40 - 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
created_view_serverless.sql
in Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/sql_scripts/PostDeployment
 42 - 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
recv-events.py
in Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/streaming
 20 - 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
send_event_for_synapsestreaming.py
in Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/streaming
 24 - 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
send-event-to-event-hub.py
in Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/streaming
 36 - 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
__init__.py
in Synapse/src/bicep-deployment/Pattern3_streaming_ingestion/src/EventGeneratorApp/EventGenerator
 55 1 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
SynapseDeployArtifacts.ps1
in Synapse/src/bicep-deployment/Pattern1/PowerShellScripts
 441 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
create_source_views.sql
in Fabric/src/deployment/Pattern1and2/src/sql/1-wwi
 102 - 2023-10-27 2023-10-30 2 1 57195527+jehayesms@users.no... 57195527+jehayesms@users.no...
create-metadata-tables.sql
in Fabric/src/deployment/Pattern1and2/src/sql/2-metadatadb
 149 - 2023-10-27 2023-10-30 2 1 57195527+jehayesms@users.no... 57195527+jehayesms@users.no...
create-fabric-dw-objects.sql
in Fabric/src/deployment/Pattern1and2/src/fabricdw
 172 - 2023-10-27 2023-10-30 2 1 57195527+jehayesms@users.no... 57195527+jehayesms@users.no...
create-fabric-dw-views.sql
in Fabric/src/deployment/Pattern1and2/src/fabricdw
 91 - 2023-10-27 2023-10-30 2 1 57195527+jehayesms@users.no... 57195527+jehayesms@users.no...
Files With Least Contributors (Top 17)
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
create-fabric-dw-objects.sql
in Fabric/src/deployment/Pattern1and2/src/fabricdw
 172 - 2023-10-27 2023-10-30 2 1 57195527+jehayesms@users.no... 57195527+jehayesms@users.no...
create-metadata-tables.sql
in Fabric/src/deployment/Pattern1and2/src/sql/2-metadatadb
 149 - 2023-10-27 2023-10-30 2 1 57195527+jehayesms@users.no... 57195527+jehayesms@users.no...
create_source_views.sql
in Fabric/src/deployment/Pattern1and2/src/sql/1-wwi
 102 - 2023-10-27 2023-10-30 2 1 57195527+jehayesms@users.no... 57195527+jehayesms@users.no...
create-fabric-dw-views.sql
in Fabric/src/deployment/Pattern1and2/src/fabricdw
 91 - 2023-10-27 2023-10-30 2 1 57195527+jehayesms@users.no... 57195527+jehayesms@users.no...
SynapseDeployArtifacts.ps1
in Synapse/src/bicep-deployment/Pattern2/PowerShellScripts
 441 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
SynapseDeployArtifacts.ps1
in Synapse/src/bicep-deployment/Pattern1/PowerShellScripts
 441 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
create_source_views.sql
in Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/wwi_source_scripts
 122 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
create_orchestrator_table.sql
in Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/orchestrator_scripts
 72 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
__init__.py
in Synapse/src/bicep-deployment/Pattern3_streaming_ingestion/src/EventGeneratorApp/EventGenerator
 55 1 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
created_view_serverless.sql
in Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/sql_scripts/PostDeployment
 42 - 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
create_metadata_tables.sql
in Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/sql_scripts/PostDeployment
 40 - 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
send-event-to-event-hub.py
in Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/streaming
 36 - 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
send_event_for_synapsestreaming.py
in Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/streaming
 24 - 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
recv-events.py
in Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/streaming
 20 - 2023-09-15 2023-09-29 2 2 samarendra.panda@outlook.com 57195527+jehayesms@users.no...
create_database_and_schemas.sql
in Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/synapse_serverless_scripts
 5 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
create_mi_user_wwi.sql
in Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/post_pipeline_deployment_scripts
 3 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
create_mi_user_orcehstratordb.sql
in Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/post_pipeline_deployment_scripts
 2 - 2023-09-12 2023-09-14 2 2 69865428+andrespad@users.no... 57195527+jehayesms@users.no...
Correlations

File Size vs. Number of Changes: 17 points

Fabric/src/deployment/Pattern1and2/src/fabricdw/create-fabric-dw-objects.sql x: 172 lines of code y: 2 # changes Fabric/src/deployment/Pattern1and2/src/fabricdw/create-fabric-dw-views.sql x: 91 lines of code y: 2 # changes Fabric/src/deployment/Pattern1and2/src/sql/1-wwi/create_source_views.sql x: 102 lines of code y: 2 # changes Fabric/src/deployment/Pattern1and2/src/sql/2-metadatadb/create-metadata-tables.sql x: 149 lines of code y: 2 # changes Synapse/src/bicep-deployment/Pattern3_streaming_ingestion/src/EventGeneratorApp/EventGenerator/__init__.py x: 55 lines of code y: 2 # changes Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/sql_scripts/PostDeployment/create_metadata_tables.sql x: 40 lines of code y: 2 # changes Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/sql_scripts/PostDeployment/created_view_serverless.sql x: 42 lines of code y: 2 # changes Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/streaming/recv-events.py x: 20 lines of code y: 2 # changes Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/streaming/send-event-to-event-hub.py x: 36 lines of code y: 2 # changes Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/streaming/send_event_for_synapsestreaming.py x: 24 lines of code y: 2 # changes Synapse/src/bicep-deployment/Pattern1/PowerShellScripts/SynapseDeployArtifacts.ps1 x: 441 lines of code y: 2 # changes Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/orchestrator_scripts/create_orchestrator_table.sql x: 72 lines of code y: 2 # changes Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/post_pipeline_deployment_scripts/create_mi_user_orcehstratordb.sql x: 2 lines of code y: 2 # changes Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/post_pipeline_deployment_scripts/create_mi_user_wwi.sql x: 3 lines of code y: 2 # changes Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/synapse_serverless_scripts/create_database_and_schemas.sql x: 5 lines of code y: 2 # changes Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/wwi_source_scripts/create_source_views.sql x: 122 lines of code y: 2 # changes
2.0
# changes
  min: 2.0
  average: 2.0
  25th percentile: 2.0
  median: 2.0
  75th percentile: 2.0
  max: 2.0
0 441.0
lines of code
min: 2.0 | average: 106.88 | 25th percentile: 22.0 | median: 55.0 | 75th percentile: 135.5 | max: 441.0

Number of Contributors vs. Number of Changes: 17 points

Fabric/src/deployment/Pattern1and2/src/fabricdw/create-fabric-dw-objects.sql x: 1 # contributors y: 2 # changes Synapse/src/bicep-deployment/Pattern3_streaming_ingestion/src/EventGeneratorApp/EventGenerator/__init__.py x: 2 # contributors y: 2 # changes
2.0
# changes
  min: 2.0
  average: 2.0
  25th percentile: 2.0
  median: 2.0
  75th percentile: 2.0
  max: 2.0
0 2.0
# contributors
min: 1.0 | average: 1.76 | 25th percentile: 1.5 | median: 2.0 | 75th percentile: 2.0 | max: 2.0

Number of Contributors vs. File Size: 17 points

Fabric/src/deployment/Pattern1and2/src/fabricdw/create-fabric-dw-objects.sql x: 1 # contributors y: 172 lines of code Fabric/src/deployment/Pattern1and2/src/fabricdw/create-fabric-dw-views.sql x: 1 # contributors y: 91 lines of code Fabric/src/deployment/Pattern1and2/src/sql/1-wwi/create_source_views.sql x: 1 # contributors y: 102 lines of code Fabric/src/deployment/Pattern1and2/src/sql/2-metadatadb/create-metadata-tables.sql x: 1 # contributors y: 149 lines of code Synapse/src/bicep-deployment/Pattern3_streaming_ingestion/src/EventGeneratorApp/EventGenerator/__init__.py x: 2 # contributors y: 55 lines of code Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/sql_scripts/PostDeployment/create_metadata_tables.sql x: 2 # contributors y: 40 lines of code Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/sql_scripts/PostDeployment/created_view_serverless.sql x: 2 # contributors y: 42 lines of code Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/streaming/recv-events.py x: 2 # contributors y: 20 lines of code Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/streaming/send-event-to-event-hub.py x: 2 # contributors y: 36 lines of code Synapse/src/bicep-deployment/Pattern4_batch_ingestion/src/streaming/send_event_for_synapsestreaming.py x: 2 # contributors y: 24 lines of code Synapse/src/bicep-deployment/Pattern1/PowerShellScripts/SynapseDeployArtifacts.ps1 x: 2 # contributors y: 441 lines of code Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/orchestrator_scripts/create_orchestrator_table.sql x: 2 # contributors y: 72 lines of code Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/post_pipeline_deployment_scripts/create_mi_user_orcehstratordb.sql x: 2 # contributors y: 2 lines of code Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/synapse_serverless_scripts/create_database_and_schemas.sql x: 2 # contributors y: 5 lines of code Synapse/src/bicep-deployment/Pattern5/src/sql_scripts/wwi_source_scripts/create_source_views.sql x: 2 # contributors y: 122 lines of code
441.0
lines of code
  min: 2.0
  average: 106.88
  25th percentile: 22.0
  median: 55.0
  75th percentile: 135.5
  max: 441.0
0 2.0
# contributors
min: 1.0 | average: 1.76 | 25th percentile: 1.5 | median: 2.0 | 75th percentile: 2.0 | max: 2.0