• Products
  • Documentation
  • Resources

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

  • added

  • copied

  • deleted

  • modified

  • moved

  • unknown

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

  • cancelled

  • failed

  • in-progress

  • pending

  • successful

  • unknown

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

  • added

  • copied

  • deleted

  • modified

  • moved

  • unknown

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

  • staging

  • testing

  • unmapped

  • development

  • production

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

  • cancelled

  • in_progress

  • successful

  • failed

  • rolled_back

  • unknown

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

  • cancelled

  • in_progress

  • successful

  • failed

  • rolled_back

  • unknown

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

  • development

  • production

  • staging

  • testing

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

  • development

  • production

  • staging

  • testing

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

  • open

  • draft

  • merged

  • declined

  • unknown

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

  • open

  • draft

  • merged

  • declined

  • unknown

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

  • approved

  • needswork

  • unapproved

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

  • approved

  • needswork

  • unapproved

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.

Still need help?

The Atlassian Community is here for you.