Database schema information

The following diagrams displays a high-level database schema structure for the tables and views created in AWS Glue and Amazon Athena database. The data model is not normalized and includes redundant attributes for reporting performance.

The aws_devops_metrics_table is a primary table for data related to AWS Developer Tools (not including AWS CodeBuild) in the Amazon S3 metrics bucket. The detail column in the table uses a struct data type and contains data for different metrics. Several views are built based on this table. Each view contains only a subset of the base table’s data for a specific metrics, such as code change activity and code deployment. A view’s data is mainly extracted from the detail column in the table for those metrics.

The aws_codebuild_metrics_table is a primary table that points to AWS CodeBuild data in the Amazon S3 metrics bucket. It is the base table for the code build view.

The aws_github_metrics_table is a primary table for GitHub data in the Amazon S3 metrics bucket. It is the base table for the GitHub change activity view.

The tagged_codecommit_table contains the data for the AWS CodeCommit repositories tagged by the user-specified tags in the Amazon S3 metrics bucket. It is used to join aws_devops_metrics_table to get the tag information for the CodeCommit change activity view.

The tagged_codepipeline_table contains the data for the AWS CodePipeline pipelines tagged by the user-specified tags in the Amazon S3 metrics bucket. It is used to join aws_devops_metrics_table to get the tag information for the CodePipeline view.

The tagged_codebuild_table contains the data for the AWS CodeBuild projects tagged by the user-specified tags in the Amazon S3 metrics bucket. It is used to join aws_codebuild_metrics_table to get the tag information for the CodeBuild view.

CodeCommit metrics database schema structure

CodePipeline metrics database schema structure

CodeBuild metrics database schema structure

CodeDeploy and MTTR metrics database schema structure

GitHub change activity metrics database schema structure