Get started with Atlassian Analytics
Learn how to add Atlassian Analytics to a site and understand what you need to query data and create charts.
Schema for DevOps data
If your organization has integrated your DevOps tools to Jira, you can access your DevOps data in Atlassian Analytics. Discover Atlassian’s available DevOps integrations.
These tables will only be available for Atlassian Data Lake connections that include Jira data.
Columns with an asterisk (*) are only available when you include all data for your products in a Data Lake connection. Learn more about how to set the scope of data for Atlassian Data Lake connections.
Tables for branch data
There are several tables for branch data:
Branch
Branch association mapping
Branch last commit file
Branch
The devops_branch table contains the latest information about each branch.
Branch ID
The unique identifier of the branch. Use this as the primary key for branch data.
SQL name | branch_id |
|---|---|
Data type | String |
Branch reference*
An internal identifier for the branch, which may be useful for debugging purposes.
SQL name | branch_ref |
|---|---|
Data type | String |
Last commit authored by
The unique identifier of the person who authored the most recent commit in the branch.
SQL name | last_commit_authored_by |
|---|---|
Data type | String |
Foreign key | Links to a record in the account table. |
Last commit committed at
The date and time (UTC) when the most recent commit against this branch was committed.
SQL name | last_commit_committed_at |
|---|---|
Data type | Datetime |
Last commit file count
The number of files impacted by the most recent commit.
SQL name | last_commit_file_count |
|---|---|
Data type | Number |
Last commit flags*
The set of flags related to the most recent commit.
SQL name | last_commit_flags |
|---|---|
Data type | Array of strings |
Last commit message*
The message included with the most recent commit.
SQL name | last_commit_message |
|---|---|
Data type | String |
Last commit name*
The display name of the most recent commit.
SQL name | last_commit_name |
|---|---|
Data type | String |
Last commit reference*
The identifier of the most recent commit.
SQL name | last_commit_ref |
|---|---|
Data type |
|
Last commit URL*
The URL associated with the most recent commit.
SQL name | last_commit_url |
|---|---|
Data type | String |
Name*
The name of the branch.
SQL name | name |
|---|---|
Data type | String |
Repository ID
The URL of the provider.
SQL name | repository_id |
|---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Update sequence number*
A number sent by the provider to indicate the order of an event. A record with a larger number is assumed to have occurred later than those with smaller numbers.
SQL name | update_sequence_number |
|---|---|
Data type | Number |
Updated at
The date and time (UTC) when the branch was last updated.
SQL name | updated_at |
|---|---|
Data type | Datetime |
URL*
The URL of the branch.
SQL name | url |
|---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Branch association mapping
The devops_branch_association_mapping table holds associations between branches and issues.
Branch ID
The unique identifier of a branch.
SQL name | branch_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the devops_branch table. |
Issue ID
The unique identifier of an issue.
SQL name | issue_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the jira_issue table. |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Type*
The type of the associated object.
SQL name | type |
|---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Branch last commit file
The devops_branch_last_commit_file table lists information about the files impacted by the latest commit in the branch. It will only hold information for up to 10 files per branch.
Branch ID
The unique identifier of the branch.
SQL name | branch_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the devops_branch table. |
Branch reference*
The identifier of the branch given by the provider. It would be unique per provider.
SQL name | branch_ref |
|---|---|
Data type | String |
Change type*
The type of change made to the file.
SQL name | change_type |
|---|---|
Data type | String |
Example values |
|
File path*
The path of the file in the repository.
SQL name | file_path |
|---|---|
Data type | String |
File URL*
The URL of the file.
SQL name | file_url |
|---|---|
Data type | String |
Lines added
The number of lines added to the file.
SQL name | lines_added |
|---|---|
Data type | Number |
Lines removed
The number of lines removed from the file.
SQL name | lines_removed |
|---|---|
Data type | Number |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Tables for build data
There are several tables for build data:
Build
Build association mapping
Build history
Build history reference
Build reference
Build
The devops_build table contains the latest information about each build.
Build ID
The unique identifier of the build. Use this as the primary key for build data.
SQL name | build_id |
|---|---|
Data type | String |
Build number*
The order in which the build was triggered.
SQL name | build_number |
|---|---|
Data type | String |
Description*
An optional description attached to the build.
SQL name | description |
|---|---|
Data type | String |
Failed tests
The number of tests that failed during the build.
SQL name | failed_tests |
|---|---|
Data type | Number |
Label*
Provides more information about the build.
SQL name | label |
|---|---|
Data type | String |
Name*
The name of the build.
SQL name | name |
|---|---|
Data type | String |
Passed tests
The number of tests that passed during the build.
SQL name | passed_tests |
|---|---|
Data type | Number |
Pipeline reference*
A pipeline that relates a sequence of builds. Depending on the use case, this might be a project ID, pipeline ID, plan key, or some other logical unit used to group a sequence of builds.
SQL name | pipeline_ref |
|---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Skipped tests
The number of tests that skipped during the build.
SQL name | skipped_tests |
|---|---|
Data type | Number |
Status*
The status of the build.
SQL name | status |
|---|---|
Data type | String |
Example values |
|
Total tests
The total number of tests considered during the build.
SQL name | total_tests |
|---|---|
Data type | Number |
Update sequence number*
A number sent by the provider to indicate the order of an event. A record with a larger number is assumed to have occurred later than those with smaller numbers.
SQL name | update_sequence_number |
|---|---|
Data type | Number |
Updated at
The date and time (UTC time zone) when the build was last updated.
SQL name | updated_at |
|---|---|
Data type | Datetime |
URL*
The URL of the build.
SQL name | url |
|---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Build association mapping
The devops_build_association_mapping table holds associations between builds and issues.
Build ID
The unique identifier of a build.
SQL name | build_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the devops_build table. |
Issue ID
The unique identifier of an issue.
SQL name | issue_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the jira_issue table. |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Type*
The type of the associated object.
SQL name | type |
|---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Build history
The devops_build_history table holds associations between all previous versions and the latest version of builds.
Build history ID
The unique identifier of the build history record.
SQL name | build_history_id |
|---|---|
Data type | String |
Build ID
The unique identifier of the build.
SQL name | build_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the devops_build table. |
Description*
An optional description attached to the build.
SQL name | description |
|---|---|
Data type | String |
Failed tests
The number of tests that failed during the build.
SQL name | failed_tests |
|---|---|
Data type | Number |
Label*
Provides more information about the build.
SQL name | label |
|---|---|
Data type | String |
Name*
The name of the build.
SQL name | name |
|---|---|
Data type | String |
Passed tests
The number of tests that passed during the build.
SQL name | passed_tests |
|---|---|
Data type | Number |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Skipped tests
The number of tests that skipped during the build.
SQL name | skipped_tests |
|---|---|
Data type | Number |
Status*
The status of the build.
SQL name | status |
|---|---|
Data type | String |
Total tests
The total number of tests considered during the build.
SQL name | total_tests |
|---|---|
Data type | Number |
Update sequence number*
A number sent by the provider to indicate the order of an event. A record with a larger number is assumed to have occurred later than those with smaller numbers.
SQL name | update_sequence_number |
|---|---|
Data type | Number |
Updated at
The date and time (UTC time zone) when the build was last updated.
SQL name | updated_at |
|---|---|
Data type | Datetime |
URL*
The URL of the build.
SQL name | url |
|---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Build history reference
The devops_build_history_reference table holds historical information that links a build to a commit, branch, and so on.
Build history ID
The unique identifier of the build history record.
SQL name | build_history_id |
|---|---|
Data type | String |
Commit reference
A reference to a commit.
SQL name | commit_ref |
|---|---|
Data type | String |
Foreign key | Links to a record in the devops_commit table. |
Commit repository URI*
The URI of the commit repository.
SQL name | commit_repository_uri |
|---|---|
Data type | String |
Pipeline reference*
A reference to the pipeline that relates to this sequence of builds.
SQL name | pipeline_ref |
|---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Build reference
The devops_build_reference table holds the latest information that links a build to a commit, branch, and so on.
Build ID
The unique identifier of a build.
SQL name | build_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the devops_build table. |
Commit reference
A reference to a commit.
SQL name |
|
|---|---|
Data type | String |
Foreign key | Links to a record in the devops_commit table. |
Commit repository URI*
The URI of the commit repository.
SQL name | commit_repository_uri |
|---|---|
Data type | String |
Pipeline reference*
A reference to the pipeline that relates to this sequence of builds.
SQL name | pipeline_ref |
|---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Tables for commit data
There are several tables for commit data:
Commit
Commit association mapping
Commit file
Commit
The devops_commit table describes each code commit received via toolchain integrations (for example, Bitbucket or GitHub).
Authored by
The unique identifier of the Atlassian account who authored the commit, if it exists.
SQL name | authored_by |
|---|---|
Data type | String |
Commit file count*
The number of files affected by the commit.
SQL name | commit_file_count |
|---|---|
Data type | Number |
Commit flags*
The set of flags related to this commit. The current possible value is MERGE_COMMIT.
SQL name | commit_flags |
|---|---|
Data type | Array of strings |
Commit ID
The unique identifier of the commit.
SQL name | commit_id |
|---|---|
Data type | String |
Commit message*
The message added to the commit.
SQL name | commit_message |
|---|---|
Data type | String |
Commit name*
The short hash of the commit.
SQL name | commit_name |
|---|---|
Data type | String |
Example values | s93H0Xm |
Commit reference*
Arbitrary reference sent by the provider to inidicate relationships between commits and other DevOps entities.
SQL name | commit_ref |
|---|---|
Data type | String |
Commit URL*
The URL that references the commit.
SQL name | commit_url |
|---|---|
Data type | String |
Committed at
The date and time (UTC time zone) when the commit was committed.
SQL name | committed_at |
|---|---|
Data type | Datetime |
Repository ID
The unique identifier of the repository from which the commit was sourced.
SQL name | repository_id |
|---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Update sequence number*
A number sent by the provider to indicate the order of an event. A record with a larger number is assumed to have occured later than those with smaller numbers.
SQL name | update_sequence_number |
|---|---|
Data type | Number |
Updated at
The date and time (UTC time zone) when the commit was last updated.
SQL name | updated_at |
|---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Commit association mapping
The devops_commit_association_mapping table contains all associations between code commits and other entities.
Commit ID
The unique identifier of the associated commit.
SQL name | commit_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the devops_commit table. |
Issue ID
The unique identifier of the associated issue.
SQL name | issue_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the jira_issue table. |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Type*
The type indicator for the type of association represented by the record.
SQL name | type |
|---|---|
Data type | String |
Example values | ati:cloud:jira:issue |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Commit file
The devops_commit_file table contains information about the files affected by the commit, as they’re received from toolchain integrations (for example, Bitbucket or Github).
Change type*
Type of change made to the file.
SQL name | change_type |
|---|---|
Data type | String |
Example values |
|
Commit ID
The unique identifier of the commit associated with the file.
SQL name | commit_id |
|---|---|
Data type | String |
Foreign key | Links to the devops_committable. |
File path*
The path of the file, from the base of the repository.
SQL name | file_path |
|---|---|
Data type | String |
Example values | /example/README.md |
File URL*
The URL of the file.
SQL name | file_url |
|---|---|
Data type | String |
Example values | https://bitbucket.org/example-org/example/src/7Mq9hfR93P1BNA1P0z01uM3taQFPIhh4/README.md |
Lines added
Number of lines being added.
SQL name | lines_added |
|---|---|
Data type | Number |
Lines removed
Number of lines being removed.
SQL name | lines_removed |
|---|---|
Data type | Number |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Tables for deployment data
There are several tables for deployment data:
Deployment
Deployment association mapping
Deployment history
Deployment
The devops_deployment table contains the latest software deployment information received from toolchain integrations (for example, Bitbucket or Github).
Commands*
A list of commands to be actioned by the deployment.
SQL name | commands |
|---|---|
Data type | Array of strings |
Deployment ID
The unique identifier of the deployment. Use this as the primary key for deployment data.
SQL name | deployment_id |
|---|---|
Data type | String |
Deployment sequence number*
A number sent by the provider to indicate the order of deployments. A record with a larger number is assumed to have occured later than those with smaller numbers.
SQL name | deployment_sequence_number |
|---|---|
Data type | Number |
Description*
The description of the deployment.
SQL name | description |
|---|---|
Data type | String |
Environment name*
The name of the deployment environment as sent by provider.
SQL name | environment_name |
|---|---|
Data type | String |
Example values | Staging — US East |
Environment reference*
Reference to the deployment environment as sent by the provider to track relationships for that environment.
SQL name | environment_ref |
|---|---|
Data type | String |
Example values | stg-us-east-015 |
Environment type*
The type of the environment that the deployment was made into.
SQL name | environment_type |
|---|---|
Data type | String |
Example values |
|
Label*
A label, or tag, associated with the deployment.
SQL name | label |
|---|---|
Data type | String |
Name*
The name of the deployment.
SQL name | name |
|---|---|
Data type | String |
Pipeline name*
The name of the build pipeline that triggered the deployment.
SQL name | pipeline_name |
|---|---|
Data type | String |
Pipeline reference*
Arbitrary reference sent by the provider that indicates the build pipeline that created the deployment.
SQL name | pipeline_ref |
|---|---|
Data type | String |
Pipeline URL*
A URL to the build pipeline that created the deployment.
SQL name | pipeline_url |
|---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
State*
The deployment state associated with the deployment.
SQL name | state |
|---|---|
Data type | String |
Example values |
|
Update sequence number*
A number sent by the provider to indicate the order of an event. A record with a larger number is assumed to have occured later than those with smaller numbers.
SQL name | update_sequence_number |
|---|---|
Data type | Number |
Updated at
The date and time (UTC time zone) when the deployment was last updated.
SQL name | updated_at |
|---|---|
Data type | Datetime |
URL*
A URL to an artifact representing the deployment.
SQL name | url |
|---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Deployment association mapping
The devops_deployment_association_mapping table holds associations between the latest version of software deployments and other entities.
Deployment ID
The unique identifier of the associated deployment.
SQL name | deployment_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the devops_deployment table. |
Issue ID
The unique identifier of the associated issue.
SQL name | issue_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the jira_issue table. |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Type*
The type indicator for the type of association represented by the record.
SQL name | type |
|---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Deployment history
The devops_deployment_history table holds associations between all previous versions and the latest version of software deployments and other entities.
Commands*
A list of commands to be actioned by the deployment.
SQL name | commands |
|---|---|
Data type | Array of strings |
Deployment history ID
The unique identifier of the deployment history record.
SQL name | deployment_history_id |
|---|---|
Data type | String |
Deployment ID
The unique identifier of the deployment associated with the record.
SQL name | deployment_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the devops_deployment table. |
Deployment sequence number*
A number sent by the provider to indicate the order of deployments. A record with a larger number is assumed to have occured later than those with smaller numbers.
SQL name | deployment_sequence_number |
|---|---|
Data type | Number |
Description*
The description of the deployment.
SQL name | description |
|---|---|
Data type | String |
Environment name*
The name of the deployment environment as sent by provider.
SQL name | environment_name |
|---|---|
Data type | String |
Example values | Staging — US East |
Label*
A label, or tag, associated with the deployment.
SQL name | label |
|---|---|
Data type | String |
Name*
The name of the deployment.
SQL name | name |
|---|---|
Data type | String |
Pipeline name*
The name of the build pipeline that triggered the deployment.
SQL name | pipeline_name |
|---|---|
Data type | String |
Pipeline reference*
Arbitrary reference sent by the provider that indicates the build pipeline that created the deployment.
SQL name | pipeline_ref |
|---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
State*
The deployment state associated with the deployment.
SQL name | state |
|---|---|
Data type | String |
Example values |
|
Update sequence number*
A number sent by the provider to indicate the order of an event. A record with a larger number is assumed to have occurred later than those with smaller numbers.
SQL name | update_sequence_number |
|---|---|
Data type | Number |
Updated at
The date and time (UTC time zone) when the deployment was last updated.
SQL name | updated_at |
|---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Tables for feature flag data
There are several tables for feature flag data:
Feature flag
Feature flag association mapping
Feature flag details
Feature flag history
Feature flag history details
Feature flag
The devops_feature_flag table contains the latest information about each feature flag.
Default value*
The value served by the feature flag when it’s disabled. It could be an actual value or an alias.
SQL name | default_value |
|---|---|
Data type | String |
Feature flag ID
The unique identifier of the feature flag.
SQL name | feature_flag_id |
|---|---|
Data type | String |
Is enabled*
Specifies whether the feature flag is turned on or off.
SQL name | is_enabled |
|---|---|
Data type | Boolean |
Name*
The human-readable name for the feature flag.
SQL name | name |
|---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Summary rollout percentage*
The rollout percentage of the feature flag in the environment.
SQL name | summary_rollout_percentage |
|---|---|
Data type | Number |
Summary rollout rules*
The number of active rules for the feature flag in the environment.
SQL name | summary_rollout_rules |
|---|---|
Data type | Number |
Summary rollout text*
A text status to display that represents the rollout.
SQL name | summary_rollout_text |
|---|---|
Data type | String |
Summary updated at
The date and time (UTC time zone) when the summary was last updated. Providers decide where they supply this timestamp from. For example, they may choose to supply the timestamp from a specific environment or the 'most recent' last-updated timestamp across all environments.
SQL name | summary_updated_at |
|---|---|
Data type | Datetime |
Summary URL*
The URL that links to a summary view of the feature flag, if appropriate.
SQL name | summary_updated_at |
|---|---|
Data type | Datetime |
Update sequence number*
A number sent by the provider to indicate the order of an event. A record with a larger number is assumed to have occurred later than those with smaller numbers.
SQL name | update_sequence_number |
|---|---|
Data type | Number |
Updated at
The date and time (UTC time zone) when the feature flag was last updated.
SQL name | updated_at |
|---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Feature flag association mapping
The devops_feature_flag_association_mapping table holds associations between feature flags and issues.
Feature flag ID
The unique identifier of a feature flag.
SQL name | feature_flag_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the devops_feature_flag table. |
Issue ID
The unique identifier of an issue.
SQL name | issue_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the jira_issue table. |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Type*
The type indicator for the type of association represented by the record.
SQL name | type |
|---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Feature flag details
The devops_feature_flag_details table
Default value*
The value served by the feature flag when it’s disabled. It could be an actual value or an alias.
SQL name | default_value |
|---|---|
Data type | String |
Environment name*
The name of the environment where the feature flag has been deployed.
SQL name | environment_name |
|---|---|
Data type | String |
Environment type*
The type of environment that the environment belongs to.
SQL name | environment_type |
|---|---|
Data type | String |
Example values |
|
Feature flag ID
The unique identifier of the feature flag associated with these details.
SQL name | feature_flag_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the devops_feature_flag table. |
Is enabled*
Specifies whether or not the feature flag is enabled in the given environment (or in summary).
SQL name | is_enabled |
|---|---|
Data type | Boolean |
Rollout percentage*
The rollout percentage of the feature flag in the environment.
SQL name | rollout_percentage |
|---|---|
Data type | String |
Rollout rules*
The number of active rules for the feature flag in the environment.
SQL name | rollout_rules |
|---|---|
Data type | String |
Rollout text*
A text status to display that represents the rollout.
SQL name | rollout_text |
|---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Updated at
The date and time (UTC time zone) when the feature flag was last updated.
SQL name | updated_at |
|---|---|
Data type | String |
URL*
The URL of the feature flag.
SQL name | url |
|---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Feature flag history
The devops_feature_flag_history table holds associations between all previous versions and the latest version of feature flags.
Default value*
The value served by the feature flag when it’s disabled. It could be an actual value or an alias.
SQL name | default_value |
|---|---|
Data type | String |
Feature flag history ID
The unique identifier of the feature flag history record.
SQL name | feature_flag_id |
|---|---|
Data type | String |
Feature flag ID
The unique identifier of the feature flag.
SQL name | feature_flag_id |
|---|---|
Data type | String |
Feature flag key*
The identifier that developers use to reference the feature flag in their source code.
SQL name | feature_flag_key |
|---|---|
Data type | String |
Feature flag reference*
The identifier for the feature flag, which must be unique for a given provider.
SQL name | feature_flag_ref |
|---|---|
Data type | String |
Is enabled*
Specifies whether the feature flag is turned on or off.
SQL name | is_enabled |
|---|---|
Data type | Boolean |
Name*
The human-readable name for the feature flag.
SQL name | name |
|---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Summary rollout percentage*
The rollout percentage of the feature flag in the environment.
SQL name | summary_rollout_percentage |
|---|---|
Data type | Number |
Summary rollout rules*
The number of active rules for the feature flag in the environment.
SQL name | summary_rollout_rules |
|---|---|
Data type | Number |
Summary rollout text*
A text status to display that represents the rollout.
SQL name | summary_rollout_text |
|---|---|
Data type | String |
Summary updated at
The date and time (UTC time zone) when the summary was last updated. Providers decide where they supply this timestamp from. For example, they may choose to supply the timestamp from a specific environment or the 'most recent' last-updated timestamp across all environments.
SQL name | summary_updated_at |
|---|---|
Data type | Datetime |
Summary URL*
The URL that links to a summary view of the feature flag, if appropriate.
SQL name | summary_updated_at |
|---|---|
Data type | Datetime |
Update sequence number*
A number sent by the provider to indicate the order of an event. A record with a larger number is assumed to have occurred later than those with smaller numbers.
SQL name | update_sequence_number |
|---|---|
Data type | Number |
Updated at
The date and time (UTC time zone) when the feature flag was last updated.
SQL name | updated_at |
|---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Feature flag history details
The devops_feature_flag_history_details table holds historical additional information for each feature flag.
Default value*
The value served by the feature flag when it’s disabled. It could be an actual value or an alias.
SQL name | default_value |
|---|---|
Data type | String |
Environment name*
The name of the environment where the feature flag is enabled
SQL name | environment_name |
|---|---|
Data type | String |
Environment type*
The type of environment that the environment belongs to.
SQL name | environment_type |
|---|---|
Data type | String |
Example values |
|
Feature flag history ID
The unique identifier of the feature flag history record associated with these details.
SQL name | feature_flag_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the devops_feature_flag table. |
Is enabled*
Specifies whether or not the feature flag is enabled in the given environment (or in summary).
SQL name | is_enabled |
|---|---|
Data type | Boolean |
Rollout percentage*
The rollout percentage of the feature flag in the environment.
SQL name | rollout_percentage |
|---|---|
Data type | String |
Rollout rules*
The number of active rules for the feature flag in the environment.
SQL name | rollout_rules |
|---|---|
Data type | String |
Rollout text*
A text status to display that represents the rollout.
SQL name | rollout_text |
|---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Updated at
The date and time (UTC time zone) when the feature flag was last updated.
SQL name | updated_at |
|---|---|
Data type | String |
URL*
The URL of the feature flag.
SQL name | url |
|---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Tables for pull request data
There are several tables for pull request data:
Pull request
Pull request association mapping
Pull request history
Pull request history reviewer
Pull request reviewer
Pull request
The devops_pull_request table contains the latest information about each pull request.
Approved count
The number of approvals on the pull request.
SQL name | approved_count |
|---|---|
Data type | Number |
Authored by
The unique identifier of the pull request author.
SQL name | authored_by |
|---|---|
Data type | String |
Foreign key | Links to a record in the account table. |
Closed at
The date and time (UTC time zone) when the pull request was closed.
SQL name | closed_at |
|---|---|
Data type | Datetime |
Comment count
The number of comments made on the pull request.
SQL name | comment_count |
|---|---|
Data type | Number |
Cycle time (seconds)
The amount of time in seconds taken from the time the pull request was created to when it was merged or closed.
SQL name | cycle_time_seconds |
|---|---|
Data type | Number |
Destination branch name*
The name of the destination branch.
SQL name | destination_branch_name |
|---|---|
Data type | String |
Destination branch URL*
The URL of the destination branch.
SQL name | destination_branch_url |
|---|---|
Data type | String |
Display reference*
A short ID for the pull request, which is displayed in Jira.
SQL name | display_ref |
|---|---|
Data type | String |
Max row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Opened at
The date and time (UTC time zone) when the pull request was opened.
SQL name | opened_at |
|---|---|
Data type | Datetime |
Pull request ID
The unique identifier of the pull request. Use this as the primary key for pull request data.
SQL name | pull_request_id |
|---|---|
Data type | String |
Pull request reference*
The identifier of the pull request provided by the provider.
SQL name | pull_request_ref |
|---|---|
Data type | String |
Repository ID
The unique identifier of the provider.
SQL name | repository_id |
|---|---|
Data type | String |
Reviewer count
The number of reviewers on the pull request.
SQL name | reviewer_count |
|---|---|
Data type | Number |
Max row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | max_row_refreshed_at |
|---|---|
Data type | Datetime |
Source branch name*
The name of the source branch.
SQL name | source_branch_name |
|---|---|
Data type | String |
Source branch URL*
The URL of the source branch.
SQL name | source_branch_url |
|---|---|
Data type | String |
Status*
The status of the pull request.
SQL name | status |
|---|---|
Data type | String |
Example values |
|
Title*
The title of the pull request.
SQL name | title |
|---|---|
Data type | String |
Update sequence number*
A number sent by the provider to indicate the order of an event. A record with a larger number is assumed to have occurred later than those with smaller numbers.
SQL name | update_sequence_number |
|---|---|
Data type | Number |
Updated at
The date and time (UC time zone) when the pull request was last updated.
SQL name | updated_at |
|---|---|
Data type | Datetime |
URL*
The URL of the pull request.
SQL name | url |
|---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Pull request association mapping
The devops_pull_request_association_mapping table holds associations between pull requests and issues.
Issue ID
The unique identifier of an issue.
SQL name | issue_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the jira_issue table. |
Pull request ID
The unique identifier of a pull request.
SQL name | pull_request_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the devops_pull_request table. |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Type*
The type indicator for the type of association represented by the record.
SQL name | type |
|---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Pull request history
The devops_pull_request_history table holds the historical information of pull requests.
Authored by
The unique identifier of the pull request author.
SQL name | authored_by |
|---|---|
Data type | String |
Foreign key | Links to a record in the account table. |
Comment count
The number of comments made on the pull request.
SQL name | comment_count |
|---|---|
Data type | Number |
Destination branch name*
The name of the destination branch.
SQL name | destination_branch_name |
|---|---|
Data type | String |
Destination branch URL*
The URL of the destination branch.
SQL name | destination_branch_url |
|---|---|
Data type | String |
Display reference*
A short ID for the pull request, which is displayed in Jira.
SQL name | display_ref |
|---|---|
Data type | String |
Pull request history ID
The unique identifier of the pull request history record.
SQL name | pull_request_history_id |
|---|---|
Data type | String |
Pull request ID
The unique identifier of the pull request.
SQL name | pull_request_id |
|---|---|
Data type | String |
Pull request reference*
The identifier of the pull request provided by the provider.
SQL name | pull_request_ref |
|---|---|
Data type | String |
Repository ID
The unique identifier of the provider.
SQL name | repository_id |
|---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Source branch name*
The name of the source branch.
SQL name | source_branch_name |
|---|---|
Data type | String |
Source branch URL*
The URL of the source branch.
SQL name | source_branch_url |
|---|---|
Data type | String |
Status*
The status of the pull request.
SQL name | status |
|---|---|
Data type | String |
Example values |
|
Title*
The title of the pull request.
SQL name | title |
|---|---|
Data type | String |
Update sequence number*
A number sent by the provider to indicate the order of an event. A record with a larger number is assumed to have occurred later than those with smaller numbers.
SQL name | update_sequence_number |
|---|---|
Data type | Number |
Updated at
The date and time (UC time zone) when the pull request was last updated.
SQL name | updated_at |
|---|---|
Data type | Datetime |
URL*
The URL of the pull request.
SQL name | url |
|---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Pull request history reviewer
The devops_pull_request_history_reviewer table holds historical information about a pull request’s reviewers and their approval statuses.
Approval status*
The approval status given by the reviewer.
SQL name | approval_status |
|---|---|
Data type | String |
Example values |
|
Pull request history ID
The unique identifier of the pull request history record.
SQL name | pull_request_history_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the devops_pull_request_history table. |
Reviewed by
The unique identifier of the pull request reviewer.
SQL name | reviewed_by |
|---|---|
Data type | String |
Foreign key | Links to a record in the account table. |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Pull request reviewer
The devops_pull_request_reviewer table contains information about a pull request’s reviewers and their approval statuses.
Approval status*
The approval status given by the reviewer.
SQL name | approval_status |
|---|---|
Data type | String |
Example values |
|
Pull request ID
The unique identifier of the pull request.
SQL name | pull_request_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the devops_pull_request table. |
Reviewed by
The unique identifier of the pull request reviewer.
SQL name | reviewed_by |
|---|---|
Data type | String |
Foreign key | Links to a record in the account table. |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
|---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Was this helpful?
Still need help?
The Atlassian Community is here for you.