Area paths of work items for projects
Unique identifier for the row.
Area path of a work item
ID of the project to which it belongs
Details about Azure DevOps organizations.
Unique identifier for the row.
Name of the organization in Azure DevOps.
Base URL used for API retrieval
Details about Azure DevOps projects.
Unique identifier for the row.
Identifier of the project in Azure DevOps
ID of the organization to which the project belongs
Name of the project
Indicates whether a project is public or private
Project last update time.
When this project last did a sync on its work items
The earliest timestamp of the projects work items
Join table between deployments and pull requests with details
Unique identifier for the row.
ID of the pull request to which it belongs
ID of the deployment to which it belongs
The environment the deployment went to
The difference in seconds between the merged_at of the pull and deployed_at of the deployment
The difference in seconds between the created_at of the pull and the deployed_at of the deployment
The name of the service the deployment belongs to
Details about pull requests in Azure DevOps
Unique identifier for the row.
Identifier of the pull request in Azure DevOps
ID of the repository to which the pull request belongs
ID of the project to which the pull request belongs
ID of the user who created the pull request
Name of the pull request
Status of the pull request. One of: 'abandoned', 'active', 'completed', 'notSet'
The name of the source branch of the pull request.
The name of the target branch of the pull request.
The date when the pull request was created.
The date when the pull request was closed (completed, abandoned, or merged externally).
The most recent date at which the pull request entered the queue to be completed.
Draft / WIP pull request.
The commit of the most recent pull request merge.
The difference (in seconds) between when the pull request was merged and created
The difference (in seconds) between the first approval and the pull request created_at
Number of files changed in the pull request
Number of commits in the pull request
URL of the pull request
Details about repositories in Azure DevOps
Unique identifier for the row.
The identifier of the repository in Azure DevOps
ID of the project to which the repository belongs
Name of the repository
Timestamp of earliest pull request synced to the repository
Default branch of the repository
URL of the repository
Compressed size (bytes) of the repository.
True if the repository is disabled. False otherwise.
True if the repository is in maintenance. False otherwise.
Details about reviews of pull requests
Unique identifier for the row.
ID of the review in Azure DevOps
ID of the pull request to which the review belongs
ID of the user who provided the review
ID of the repository to which the review belongs
One of: 'approved', 'waiting', 'rejected', 'active', 'byDesign', 'closed', 'fixed', 'pending', 'unknown', 'wontFix'
10 - approved, 5 - approved with suggestions, 0 - no vote, -5 - waiting for author, -10 - rejected
The timestamp of when the review was submitted
Difference (in seconds) between the submitted review and the pull request created_at
Number of comments in the review
URL of the review
Membership of users to their Azure DevOps team.
Unique identifier for the row.
ID of the team
ID of the user
Boolean indicating if the team member is an admin
Details about Azure DevOps teams.
Unique identifier for the row.
ID of the team in Azure DevOps
ID of the organization to which the team belongs
ID of the project to which the team belongs
Team name
Team REST API Url
True if team was listed in API in most recent sync
Details about Azure DevOps users.
Unique identifier for the row.
ID of the user in Azure DevOps
ID of the organization to which the user belongs
Name of the user. Non unique.
PrincipalName of the user
Email of the user
If the type of source provider for the origin identifier is 'vsts'
If the user was listed in the API in the most recent sync
Details about when a work item changes state. Changes to a work item not involving state are not stored
Unique identifier for the row.
ID of the work item
ID of the work item type state it began with
The revision number of the state change
ID of the work item type state it ended with
Date of the change of state
Tags for work items
Unique identifier for the row.
Name of the tag
ID of the work item to which it belongs
Categories for work items
Unique identifier for the row.
Name of the work item category.
ID of the project to which the category belongs
The reference name of the category.
States for work item types
Unique identifier for the row.
ID of the project to which it belongs
ID of the work item type to which it belongs
Work item type state name
Category of state
Details about work item types
Unique identifier for the row.
ID of the project to which it belongs
The name of the work item type.
The description of the work item type.
Boolean that is true if work item type is disabled
Details about work items
Unique identifier for the row.
The work item ID.
ID of the project to which it belongs
ID of the area path to which it belongs
ID of the work item type to which it belongs
ID of the team to which it belongs
ID of the work item state to which it belongs
ID of the user who created the work item
ID of the user who is assigned the work item
ID of the user who is assigned the work item
URL for the work item
Title of the work item
Number of points
Dude date of the work item
Creation date of the work item
Activated date of the work item
Closed date of the work item
The changed date of the work item
Difference between completed_at and started_at in seconds
Details of custom fields in Asana.
Unique identifier for the row.
Asana ID of the custom field.
ID of the workspace associated with the custom field.
Name of the custom field.
Type of the custom field.
Details of the association between tasks and projects in Asana.
Unique identifier for the row.
ID of the task.
ID of the project.
Details of Asana projects.
Unique identifier for the row.
Asana ID of the project.
ID of the workspace associated with the project.
ID of the team associated with the project.
Name of the project.
Details of sections in Asana.
Unique identifier for the row.
Asana ID of the section.
ID of the project associated with the section.
Name of the section.
State of the section.
Details of custom field values associated with tasks in Asana.
Unique identifier for the row.
ID of the task.
ID of the custom field.
Value of the custom field.
A record of when tasks changed between sections.
Unique identifier for the row.
Asana ID of the section change.
ID of the task.
Section changes are interpreted from story text. This row contains the raw story text.
ID of the starting section.
ID of the finishing section.
Timestamp when the section change ocurred.
Details of Asana tasks.
Unique identifier for the row.
Asana ID of the task.
ID of the workspace associated with the task.
ID of the user assigned to the task.
Name of the task.
Approval status of the task.
Timestamp when the task was created.
Timestamp when the task was started this is interpreted from stories and section changes.
Timestamp when the task was completed.
Timestamp when the task was last updated.
Time taken to complete the task (in seconds).
Timestamp when the task was last synced.
Details of the association between users and teams in Asana.
Unique identifier for the row.
ID of the team.
ID of the user.
Details of Asana teams.
Unique identifier for the row.
Asana ID of the team.
Name of the team.
Description of the team.
ID of the workspace associated with the team.
Details of Asana users.
Unique identifier for the row.
Asana ID of the user.
Email of the user.
Name of the user.
Details of Asana workspaces.
Unique identifier for the row.
Asana ID of the workspace.
Name of the workspace.
Boolean indicating if the workspace is an organization.
Timestamp when the workspace was last synced.
Timestamp indicating the end of the sync period.
Details about Backstage applications deployed for your account.
Unique identifier for the row.
The configured `app_id` in backstage. Used for syncing multiple backstage applications with DX. Set to `DEFAULT` if not configured in Backstage.
The title of the Backstage application.
The URL which the Backstage application is available.
Details about Backstage software catalog entities.
Unique identifier for the row.
ID of the Backstage application this entity belongs to.
Backstage entity reference. This can be used as a unique identifier for the Backstage Entity.
The version of specification format for that particular entity that the specification is made against.
The Software Catalog Entity kind. One of Component, Template, API, Group, User, Resource, System, Domain, Location.
Name of the Entity. Used for human readability, and for machines to reference the entity.
ID of the namespace that the Entity belongs to.
A display name of the Entity, to be presented in user interfaces instead of the name property above, when available.
A human readable description of the Entity.
The type of Entity. e.g. website. Present for only some kinds of Entities.
The lifecycle state of the Entity. e.g. production. Present for only some kinds of Entities.
Stringified definition of the API Entity, based on the type given. Only present for API entity kinds.
Details of the Entity annotations defined in Backstage.
Unique identifier for the row.
ID of the Backstage entity.
Annotation key in Backstage
Annotation value in Backstage
Details of the Entity labels defined in Backstage.
Unique identifier for the row.
ID of the Backstage entity.
Key of the Label given to the Backstage Entity.
Value of the Label given to the Backstage Entity.
Details of the Entity links defined in Backstage.
Unique identifier for the row.
ID of the Backstage Entity.
URL for the link, in standard URI format.
A user friendly display name for the link.
A key representing a visual icon to be displayed in the UI.
An optional value to categorize links into specific groups.
Profile details of a given entity. Can be either a User or Group entity.
Unique identifier for the row.
ID of the User or Group entity.
The display name given in the profile for the entity.
The email given in the profile for the entity.
A URL to a picture representing the group, given in the profile for the entity.
Details of the relationships between catalog entities in Backstage. Relations in this table can be understood as `source_entity_ref` - `type` - `target_entity_ref`. i.e. `component:app` - `ownedBy` - `group:developers`.
Unique identifier for the row.
Backstage Entity Reference of the Source Backstage Entity.
The type of relation FROM a source entity TO the target
Backstage Entity Reference of the Target Backstage Entity.
Details of the Entity tags defined in Backstage.
Unique identifier for the row.
ID of the Backstage entity.
Tag in Backstage.
Details about Bitbucket pull requests
Unique identifier for the row.
ID of the pull request in Bitbucket
ID of the repository to which the pull request belongs
ID of the user who authored the pull request
Title of the pull request
One of: OPEN, MERGED, DECLINED, SUPERSEDED
Timestamp of when the pull request is merged
Name of the branch with the pull request changes
Name of the branch the pull request is being merged in to
Commit SHA of the merge
Timestamp of when the pull request creation
Timestamp of when the pull request was last updated
Difference (in seconds) between merged_at and created_at
Difference (in seconds) between first review creation and created_at of pull request
Difference (in seconds) between first approval and created_at of pull request
URL of Bitbucket pull request
Details about Bitbucket repositories
Unique identifier for the row.
ID of repository in Bitbucket
ID of the workspace to which the repository belongs
Name of the repository
Slug of the repository
Description of the repository
Boolean indicating if the repository is public
Creation date of the repository
Updated date of the repository
URL of the Bitbucket repository
Timestamp of when DX last synced pull requests for the repository
Timestamp of when DX last synced pipelines for the repository
Details about Bitbucket reviews.
Unique identifier for the row.
ID of review in Bitbucket
ID of the Bitbucket pull request associated with this review.
ID of the Bitbucket user who created this review.
Time between PR being created and first review comment being created.
Creation date of the review
Updated date of the review
URL of the Bitbucket review
One of: APPROVED, DECLINED, COMMENTED
Details about Bitbucket projects
Unique identifier for the row.
ID of the project in Bitbucket
URL to the project
Key for the project
Name of the project
Description of the project
Boolean indicating if the project is public or not
Details about Bitbucket pull requests
Unique identifier for the row.
ID of the pull request
ID of the repository to which the pull request belongs
ID of the author of the pull request
URL of the pull request
Title of the pull request
Description of the pull request
One of: 'OPEN', 'DECLINED' or 'MERGED'
Timestamp of when the pull request is merged
Name of the branch with the pull request changes
Name of the branch the pull request is being merged in to
Merge Commit SHA of the pull request
Creation date of the pull request
Updated date of the pull request
The date the pull request was closed via merge or by decline
Difference (in seconds) between the merged_at and created_at
Difference (in seconds) between the first review's creation date and the created_at timestamp of the pull request
Difference (in seconds) between the first approval's creation date and the created_at timestamp of the pull request
Details about Bitbucket repositories
Unique identifier for the row.
ID of the repository in Bitbucket
ID of the project to which the repository belongs
URL to the repository
Name of the repository
Slug of the repository
Description of the repository
Boolean indicating if the repository is public
Default branch of the repository
Details of the reviews given on a pull request.
Unique identifier for the row.
ID of the review in Bitbucket
ID of the pull request to which the review belongs
ID of the user who authored the review
Difference (in seconds) between created_at and the created_at timestamp of the pull request
One of: APPROVED, DECLINED, COMMENTED
Total number of review comments
Timestamp of when the review was created
Timestamp of when the review was updated
Details about Bitbucket users
Unique identifier for the row.
ID of the user in Bitbucket Server
URL of the user
Name of the user
Email address of the user
Creation date of the user
If the user was listed in the API in the most recent sync
Details about the bitbucket users in a workspace.
Unique identifier for the row.
ID of the user in Bitbucket Server
ID of the workspace to which the user belongs
Name of the user
Email of the user
If the user was listed in the API in the most recent sync
Details of the distinct Bitbucket workspaces for your account.
Unique identifier for the row.
Name of the workspace
ID of the Data Cloud connection importing the workspace's data
An Error is a grouping of events of the same crash/exception reported to Bugsnag.
Bugsnag ID for the error.
The severity of the error.
Project ID associated with the error.
Bugsnag URL for the error.
Error class of the error.
Error message of the error.
The Error's original severity.
The Error's updated severity.
Status of the error.
Total number of occurrences.
Total number of users affected by the error.
Timestamp when the item was first seen.
Timestamp when the error was last seen.
Timestamp when the item was last synced.
An Organization is a collection of Bugsnag projects.
Bugsnag ID for the organization.
Name of the organization.
Human-readable identifier for the organization.
A Project is used to record errors from an individual application that are reported.
Bugsnag ID for the project.
Name of the project.
Organization ID associated with the project.
Human-readable identifier for the project.
Records of ClickUp folders
Unique identifier for the row.
ID of the folder in ClickUp
ID of the space to which the folder belongs
Name of the folder
Boolean indicating if the folder is hidden
Records of ClickUp lists
Unique identifier for the row.
ID of the list in ClickUp
ID of the folder to which the list belongs
Name of the list
Boolean indicating if list is archived
Records of ClickUp spaces
Unique identifier for the row.
ID of the space in ClickUp
ID of the team to which the space belongs
Name of the space
Boolean indicating if the space is private
Join table between tasks and users
Unique identifier for the row.
ID of the task the user has been assigned
ID of the user who has been assigned the task
Details about ClickUp tasks
Unique identifier for the row.
ID of the task in ClickUp
ID of the list to which the task belongs
Name of the task
Status of the task
Creation timestamp of the task
Last updated timestamp of the task
Timestamp of when the task began
Timestamp of when the task was finished
Timestamp of when the task was closed
Difference (in seconds) of finished_at and started_at
URL of the task
Records of ClickUp teams
Unique identifier for the row.
ID of the team in ClickUp
Name of the team
Records of ClickUp users
Unique identifier for the row.
ID of the user in ClickUp
Email of the user
Labels associated with Confluence pages.
Unique identifier for the row.
Confluence ID of the label.
ID of the page this label is associated with.
Name of the label.
Prefix of the label (e.g., "global").
Details about Confluence page versions.
Unique identifier for the row.
ID of the page this version belongs to.
Version number of the page.
Message or description of the changes in this version.
ID of the author who made the version.
Indicates whether the version is a minor edit.
Date and time the version was created.
Details about Confluence pages.
Unique identifier for the row.
Confluence ID of the page.
Title of the Confluence page.
Position of the page in the space.
Status of the page (e.g., "current").
ID of the space the page belongs to.
ID of the author who created the page.
ID of the current owner of the page.
ID of the last owner of the page.
URL to the Confluence page.
Date and time the page was created.
Date and time the page was last updated.
Details about Confluence spaces.
Unique identifier for the row.
Confluence ID of the space.
Name of the Confluence space.
ID of the author who created the space.
Status of the space (e.g., "current").
Key of the Confluence space.
Type of the Confluence space (e.g., "global").
URL to the Confluence space.
Date and time the space was created.
Details about Confluence users.
Unique identifier for the row.
Confluence ID of the user.
Email address of the user.
Name of the user.
Type of the Confluence account (e.g., "atlassian").
Status of the Confluence account (e.g., "active").
Date and time the row was created.
Date and time the row was last updated.
Details of the association between incidents and services in Datadog.
Unique identifier for the row.
ID of the incident.
ID of the service.
Details of Datadog incidents.
Unique identifier for the row.
Datadog ID of the incident.
Title of the incident.
State of the incident.
Severity of the incident.
Boolean indicating if the incident impacted customers.
ID of the user who created the incident.
ID of the user who is the commander for the incident.
Timestamp when the incident started.
Timestamp when the incident was resolved.
Time taken to resolve the incident (in seconds).
Time taken for internal response (in seconds).
Time taken to detect the incident (in seconds).
Time taken to repair the issue (in seconds).
Details of Datadog monitors.
Datadog ID of the monitor.
Name of the monitor.
The type of monitor (composite, event alert, log alert, metric alert, process alert, etc).
A message included in notifications for this monitor.
List of options associated with monitor..
The different states your monitor can be in (Alert, Ignored, No Data, OK, Skipped, Unknown, Warn).
Timestamp at which the overall state has been modified.
A list of active downtimes that match this monitor.
Array of tags associated with monitor.
Details of Datadog services.
Unique identifier for the row.
Datadog ID of the service.
Name of the service.
Description of the service.
Name of the team associated with the service.
ID of the team associated with the service.
Details of Datadog SLO values.
Unique identifier for the row.
ID of the associated SLO.
Timestamp of the SLO value.
Value of the SLO at the given timestamp.
Details of tags associated with SLOs.
ID of the associated SLO.
Name of the tag.
Details of Datadog SLOs (Service Level Objectives).
Unique identifier for the row.
Datadog ID of the SLO.
Name of the SLO.
Target threshold for the SLO.
Timeframe for the SLO.
Timestamp when the SLO was created.
Timestamp when the SLO was last updated.
Boolean indicating if the SLO is accessible via API.
Details of Datadog teams.
Unique identifier for the row.
Datadog ID of the team.
Handle of the team.
Name of the team.
Boolean indicating if the team is accessible via API.
Details of the association between users and teams in Datadog.
Unique identifier for the row.
ID of the user.
ID of the team.
Details of Datadog users.
Unique identifier for the row.
Datadog ID of the user.
Username of the user.
Full name of the user.
Email of the user.
Custom data table for storing arbitrary data.
Unique identifier for the row.
Reference for the custom data.
Key for the custom data.
Value for the custom data.
Timestamp of when the custom data was last updated.
Custom metrics table for storing arbitrary metrics.
Unique identifier for the row.
Reference for the custom metric.
Key for the custom metric.
Value for the custom metric.
Additional metadata for the custom metric.
Timestamp of when the custom metric was created.
Record of all deployment inference rules.
Unique identifier for the row.
The name of the rule.
Their hierarchy level of the CI/CD job that triggered the deployment.
Reference to the branch where changes would be pulled into. Typically a branch name.
The repository specified for the deployments.
ID of the pipeline source for the deployment inference rule.
Boolean indicating if the service name is defaulted to the repository name.
Date at which the rule was deleted, if ever.
Metadata sent with deployments api requests.
Unique identifier for the row.
ID of the deployment.
Key of the metadata. Nested keys are separated by periods.
Value of the metadata.
Record of all services that have been tracked with the deployments API.
Unique identifier for the row.
The given unique identifier for the deployment.
Record of all deployments that have been tracked.
Unique identifier for the row.
The given unique identifier for the deployment.
Name of the repository being deployed including the org name.
The > 7 digit commit SHA being deployed. This is used to attribute deploys to code changes. Without this
The date which the deployment was attributed to a pull request. Empty if no pull request was found.
Date which the deployment occurred.
URL containing more information about the deployment.
The name of the system which initiated the deployment.
ID of the deployment inference rule which created this deployment.
ID of the deployment service associated with the deployment.
Data about your DX account.
Unique identifier for the row.
DX ID of the account.
The name of your DX account.
Factors that are surveyed about for the onboarding survey.
Unique identifier for the row.
DX ID of the onboarding factor.
Name of the onboarding factor.
Text displayed to the user in the survey.
JSON array of options for the survey.
Boolean indicating if the factor is active.
Onboarding data for users with start_date set including onboarding survey responses and first contribution metrics.
ID of the user associated with the entry.
Perceived ramp-up value aka 90 day sentiment.
Overall score from the onboarding survey.
How many days from start date to the first code contribution.
How many days from start date to the tenth code contribution.
Comment associated with the entry.
ID of the sender associated with the onboarding survey.
Type of the sender associated with the onboarding survey ("Bot" or "User").
Time at which the entry was submitted by the user.
Time at which the entry was deleted null if not deleted.
Time at which the entry was triggered.
User reponses to the onboarding survey sentiment questions.
ID of the onboarding response.
ID of the onboarding factor.
Index of the selected option for the factor.
Unique identifier for the row.
DX ID of the platform event.
ID of the platform project.
ID of the user who triggered the event.
Name of the event.
Email of the user who triggered the event.
Github username of the user who triggered the event
Time at which the event was triggered.
JSON field with arbitraty metadata given for the event.
Time at which the DB record was created.
Unique identifier for the row.
DX ID of the platform project.
User ID of the creator of the project.
Name of the project.
Name of the team.
Date the project was created.
DX PlatformX survey question options.
ID of the question associated with the option.
Label for the option.
Value for the option.
Position of the option for the question.
DX PlatformX survey questions.
ID of the survey associated with the question.
Type of the question.
Unique key for the question.
Label for the question.
Position of the question in the survey.
DX PlatformX survey response answers.
ID of the response associated with the answer.
ID of the question associated with the answer.
ID of the option associated with the answer.
Value of the answer.
DX PlatformX survey responses.
DX ID of the response.
ID of the survey associated with the response.
ID of the user who responded to the survey.
Date the user was prequalified for the survey.
Date the user responded to the survey.
Date the response was created.
DX PlatformX surveys.
DX ID of the survey.
ID of the project associated with the survey.
Name of the survey.
Date the survey was created.
Record of each item presented to users in a snapshot.
Unique identifier for the row.
DX ID of the snapshot item.
ID of the snapshot associated with this item.
Name of the snapshot item presented to the user.
Type of the snapshot item. One of kpi, csat, or sentiment.
The prompt that would be shown to the user when taking a snapshot
For workflow items, the recommended target area
The hierarchy of snapshot teams. Data is modeled in a tree structure.
Unique identifier for the row.
ID of the ancestor team in the heirarchy.
ID of the descendant team in the heirarchy.
Generation number in the tree structure.
Scores for teams during a given snapshot.
Unique identifier for the row.
ID of the snapshot team for these scores.
ID of the snapshot item relating to this score.
ID of the snapshot relating to this score.
ID of the dx team associated with this score.
Comparative score vs your own organization.
Comparative score vs the previous snapshot.
Comparative score vs the industry 50th percentile.
Comparative score vs the industry 75th percentile.
Comparative score vs the industry 90th percentile.
The actual score given.
History of teams at the time a snapshot occurred.
Unique identifier for the row.
DX ID of the snapshot team.
DX ID of the parent to this team.
ID of the snapshot associated with this snapshot team.
ID of the dx team associated with this snapshot team.
Name of the team.
Boolean indicating if this is a parent team.
String showing a hierarchy of the parents preceding this team. i.e. "ALL » Sub-Team » Sub-Sub-Team".
Count of contributors on the team.
Rate of snapshot participation for this team. 1 is 100%, 0.93 is 93%, etc.
History of DX Snapshots.
Unique identifier for the row.
DX ID of the snapshot.
ID of the account associated to this snapshot.
Date the snapshot started.
Date the snapshot ended.
Rate of snapshot participation. 1 is 100%, 0.93 is 93%, etc.
Number of individuals who completed or were expected to complete the snapshot.
A grouping of custom attributes which can be assigned to a user.
Unique identifier for the row.
DX ID of the tag group.
ID of the account associated with this tag group.
Name of the tag group.
Time at which the DB record was created.
Custom attributes which can be assigned to a user.
Unique identifier for the row.
DX ID of the tag.
ID of the account associated with this tag group.
ID of the tag group associated with this tag.
Name of the tag.
Time at which the DB record was created.
The current hierarchy of DX teams. Data is modeled in a tree structure.
Unique identifier for the row.
ID of the ancestor team in the heirarchy.
ID of the descendant team in the heirarchy.
Generation number in the tree structure.
Current DX team structure.
Unique identifier for the row.
DX ID of the team.
DX ID of the parent team.
DX ID of team lead.
Name of the team as shown to users.
Boolean indicating if this is a parent team.
String showing a hierarchy of the parents preceding this team. i.e. "ALL » Sub-Team » Sub-Sub-Team".
Count of contributors on the team.
Date at which the team was deleted, null if not deleted.
A unique identifier provided by customer in CSV upload.
Custom attributes assignment to DX users.
Unique identifier for the row.
ID of the user for which this tag is associated.
ID of the tag given to this user.
ID of the tag group for the tag.
DX User information.
Unique identifier for the row.
DX ID of the user.
ID of the team which this user belongs.
Name of the user.
Email of the user.
Github username of the user, if github is connected.
Gitlab username of the user, if gitlab is connected.
Boolean indicating whether or not this user is a developer.
Start date is set for users included in onboarding.
When a user was marked as deleted in DX. Is NULL for non-deleted users.
Mapping table of DX users to external systems.
Unique identifier for the row.
DX ID of the user.
Primary key ID of the record on the source table, defined by the source column.
String representing the source for the identity. i.e. github, gitlab, jira, opsgenie, etc.
Join table for incidents to services. Incidents <> Services is one-to-many where one incident has one more services associated.
Unique identifier for the row.
The ID of the incident.
The ID of the service.
A unified table of your incident data from various sources. (i.e. PagerDuty, OpsGenie)
Unique identifier for the row.
The name given to the incident.
Priority assigned to the incident, as given by the source data.
Source system where the incident was created. (i.e. PagerDuty, OpsGenie)
ID of the incident in the source system.
Direct URL to the incident in the source system.
Date which the incident was started.
Date which the incident was resolved.
Time difference in seconds between an incident starting and being resolved.
Issues collected in an issue collection.
Unique identifier for the row.
ID of the issue.
ID of the issue collection.
Timestamp when the row was created.
Timestamp when the row was last updated.
Collection of issues.
Unique identifier for the row.
Source system of the issue collection.
ID of the issue collection in the source system.
Name of the issue collection.
Type of the issue collection.
Boolean indicating if the collection is accessible via API.
Timestamp when the row was created.
Timestamp when the row was last updated.
External ID of the issue collection.
ID of the source table.
A unified table of your issue data from various sources.
Unique identifier for the row.
Source system where the issue was created.
ID of the issue in the source system.
Direct URL to the issue in the source system.
DX ID of the user associated with the issue.
Title of the issue.
Date the issue was created.
Date the issue was started.
Date the issue was last updated.
Date the issue was completed.
Cycle time of the issue in seconds.
Timestamp when the row was created.
Timestamp when the row was last updated.
ID of the source table.
External ID of the issue.
External URL of the issue.
Boolean indicating if the issue was cancelled.
Boolean indicating if the issue was deleted.
Unique ID for the row.
The unique ID for the associated deployment.
The environment the deployment was associated with.
The time difference in seconds between the merged_at and the deployed_at of the deployment
The difference in seconds between the created_at of the pull and the deployed_at of the deployment
The unique ID for the associated pull_request.
The name of the service the deployment belongs to.
The name of the system that the pull request originated from.
Unique ID for the row.
The number of comments associated with the review
The date that the review was closed in the source system.
The dx_users ID of the user that created the review.
The ID used by the source system.
The URL to the review details in the source system.
The unique ID for the associated pull_request.
The unique ID for the repo that owns the review
The name of the system that the review originated from.
The unique ID for the row in the source table that the review originated from.
The unique ID for the row in the source specific pull/merge request table that the review relates to.
The unique ID for the row in the source specific repository/project table that the review relates to.
Time difference in seconds between when the review was requested and submitted.
Type of the review
Unique ID for the row.
The number of lines added in the pull request.
The name of the branch that the changes are being merged into.
Boolean indicating if the user is a bot. Also known as "Machine User".
The date that the pull request was closed in the source system.
The date that the pull request was created in the source system.
The number of lines deleted in the pull request.
The dx_users ID of the user that owns the pull request.
The URL to the pull request details in the source system.
The ID used by the source system.
The name of the branch that the changes are coming from.
Merge Commit SHA from the source system
The date that the pull request was merged in the source system.
The time difference in seconds between a pull request being approved and being created.
The time difference in seconds between the first review being submitted and the pull request being created.
The time difference in seconds between the pull request being merged and being created.
The unique ID for the repo that owns the pull request
The name of the system that the pull request originated from.
The unique ID for the row in the source table that this pull request originated from.
The unique ID for the row in the source specific repository/project table that this pull request relates to.
The title or summary of the pull request
The date that the pull request was last updated in the source system.
Unique ID for the row.
The name of the default branch for the repo.
The ID used by the source system.
The name of the repository or project as defined in the source system.
The name of the entity that owns the repo in the source system.
The name of the system that the repo originated from.
The unique ID for the row in the source table that the repo originated from.
A unified table of your services from different sources. `service_id` links each service to the central service catalog.
Unique identifier for the row.
The name given to the service.
The link to the service catalog
The source system of the service.
The ID in source system of the service.
Your service catalog.
Unique identifier for the row.
The name given to the service.
The team assigned as owner of the service.
Logical components such as services that Dynatrace monitors and analyzes.
Dynatrace ID of the entity.
The name of the entity, displayed in the dynatrace UI.
The type of the entity.
Objectives that define target performance or reliability goals for monitored entities.
Dynatrace ID of the SLO.
The name of the SLO.
The calculated status value of the SLO.
The target value of the SLO.
The warning value of the SLO.
The timeframe for the SLO evaluation.
Details of responders to incidents in Firehydrant.
Unique identifier for the row.
ID of the incident.
ID of the responder.
Details of services impacted by incidents in Firehydrant.
Unique identifier for the row.
ID of the incident.
ID of the service.
Details of incidents in Firehydrant.
Unique identifier for the row.
Firehydrant ID of the incident.
Name of the incident.
Status of the incident.
Severity of the incident.
priority of the incident.
description of the incident.
True if customers were impacted.
Timestamp when the incident started.
Timestamp when the incident was resolved.
Timestamp when the incident was acknowledged.
Timestamp when the incident was created.
Details of service-team relationships in Firehydrant.
Unique identifier for the row.
ID of the team.
ID of the service.
Details of Firehydrant services.
Unique identifier for the row.
Firehydrant ID of the service.
Name of the service.
Description of the service.
Slug of the service.
Details of Firehydrant teams.
Unique identifier for the row.
Firehydrant ID of the team.
Name of the team.
Description of the team.
Unique team slug.
Details of the association between users and teams in Firehydrant.
Unique identifier for the row.
ID of the user.
ID of the team.
Details of Firehydrant users.
Unique identifier for the row.
Firehydrant ID of the user.
Full name of the user.
Email of the user.
Table for storing GitHub Code Scanning alert data.
The code scanning number for the repository.
ID of the repository associated with the alert.
State of the alert (e.g., open, fixed).
URL for more details about the alert.
Timestamp when the alert was fixed.
ID of the rule that triggered the alert.
Reference to the most recent instance of the alert.
Timestamp when the alert was created.
Impact level of an issue in GitHub code scanning alerts (Error, Warning, or Note).
Shows how risky a code vulnerability is (Critical, High, Medium, or Low).
Daily usage details for GitHub Copilot licensees
Unique identifier of the row
The login of the GitHub user
The date of usage
Enterprise slug
Boolean indicating whether the user was active on this date
Breakdown of GitHub Copilot usage by language and editor.
Unique identifier for the row.
ID of the associated GitHub Copilot usage record.
Programming language of the usage data.
Editor used during the usage data.
Number of suggestions made by Copilot.
Number of suggestions accepted by users.
Number of lines suggested by Copilot.
Number of lines accepted by users.
Number of active users.
Details of GitHub Copilot usage.
Unique identifier for the row.
The day of the usage data.
ID of the organization.
Enterprise slug
Total number of suggestions made by Copilot.
Total number of suggestions accepted by users.
Total number of lines suggested by Copilot.
Total number of lines accepted by users.
Total number of active users.
Total number of chat acceptances.
Total number of chat turns.
Total number of active chat users.
Table for storing GitHub Dependabot alert data.
The dependabot alert number for the repository.
ID of the repository associated with the alert.
State of the alert (e.g., open, fixed).
Name of the package causing the alert.
Summary of the alert.
Severity level of the alert.
URL for more details about the alert.
Timestamp when the alert was fixed.
Timestamp when the alert was created.
Timestamp when the alert was last updated.
Events related to GitHub deployments
Unique identifier for the row
GitHub ID of the deployment event
ID of the GitHub repository
Git commit SHA for the deployment
Git reference for the deployment
Task name for the deployment
Boolean indicating if the deployment was successful
Environment name for the deployment
Boolean indicating if this is a production environment
Timestamp when the deployment event was created
Association between GitHub issues and assignees
Unique identifier of the row
ID of the issue to which the assignee is assigned
ID of the user assigned to the issue
Association between GitHub issues and labels
Unique identifier of the row
ID of the issue to which the label is assigned
ID of the label associated with the issue
Association between GitHub issues and projects
Unique identifier of the row
ID of the issue
ID project
Details about GitHub issues
Unique identifier of the row
ID of the issue in GitHub
URL of the issue in GitHub
ID of the repository to which the issue belongs
State of the issue (e.g., open, closed)
Title of the issue
Number of the issue within the repository
ID of the user who created the issue
Cycle time for the issue in days
Date when the issue was closed
Date when the issue was created
Date when work on the issue started
Date when the issue was last updated
Details about Github labels
Unique identifier for the row.
ID of the repository to which the label belongs
GitHub ID of the label.
URL directly to the label in GitHub.
Indicates whether the label has been deleted in GitHub.
Indicates whether the label is a default GitHub label.
Record of all the machine users in your GitHub organization, mapped to their DX user id.
Unique identifier for the row.
ID of the user.
Details about your GitHub organizations.
Unique identifier for the row.
GitHub ID of the organization.
GitHub App Installation ID.
GitHub Organization slug.
URL directly to the DX app installation details within GitHub.
Github ProjectV2
Unique identifier of the row
ID of the project in GitHub
Number of the project
Title of the project
Date when the project was created
Date when the project was updated
GitHub App Installation ID.
Details about commits in GitHub pull requests.
Unique identifier for the row.
SHA of the commit.
ID of the author of the commit.
ID of the pull request associated with the commit.
Timestamp when the commit was created.
Commit message.
Timestamp when the row was created.
Timestamp when the row was last updated.
URL directly to the commit in GitHub.
Join table between pull requests and labels
Unique identifier for the row.
ID of the label applied to the pull request
ID of the pull request to which the label belongs
Services that pull requests are merged into
Unique identifier for the row.
ID of the pull request
Identifier of the Pull request in Github
Name of the service
Detailed information and metrics about GitHub pull requests.
Unique identifier for the row.
GitHub ID of the repository.
ID of the GitHub repository which this pull request was created for.
ID of the user who created the pull request.
The pull request number for the repository.
Title of the pull request.
Reference to the branch where the pull request changes are implemented. Typically a branch name.
Reference to the branch where changes would be pulled into. Typically a branch name.
Date at which the pull request was created.
Most recent date at which the pull request was updated.
Date at which the pull request was closed. Present only if it is closed.
Date at which the pull request was merged. Present only if it was merged.
Date at which the pull request was marked as ready-for-review (i.e., converted from draft state).
Boolean indicating whether or not the pull request is marked as a "draft" request.
Git commit SHA of the merge commit used to merge into the base branch.
Time difference in seconds between a pull request being merged and being created.
Time difference in seconds between the first review being submitted and the pull request being created. When "ready-for-review" is used, the calculation is instead the difference between the first review being submitted and the pull request being marked as "ready-for-review".
Time difference in seconds between a pull request being approved and being created.
Count of lines added in the pull request.
Count of lines deleted in the pull request.
Count of files changed in the pull request.
Count of commits in the pull request.
URL directly to the pull request within GitHub.
Description of the pull request.
Estimated time spent working on the pull request in hours, calculated from commit history.
Timestamp of the first commit in the pull request.
Details about the GitHub repositories in your organization.
Unique identifier for the row.
GitHub ID of the repository.
ID of the GitHub Organization of the repository.
Name of the repository
Boolean indicating whether the repository is private.
Boolean indicating whether the repository is archived.
The default git branch of the repository.
URL directly to the repository in GitHub.
Properties associated with GitHub repositories
Unique identifier for the row
ID of the GitHub repository
Name of the property
Value of the property
Detailed information and metrics about GitHub review requests.
Unique identifier for the row.
GitHub ID of the review request.
ID of the GitHub pull request which the review was requested.
ID of the GitHub user who requested the review.
ID of the GitHub user who was requested to perform the review.
ID of the GitHub team who was requested to review the pull request.
ID of the GitHub review which was submitted.
Time difference between when the review was requested and submitted.
GitHub API url for the pull request event.
Date at which the review request was created.
Detailed information and metrics about GitHub reviews.
Unique identifier for the row.
GitHub ID of the review.
ID of the GitHub pull request for this review.
ID of the GitHub user who submitted this review.
ID of the GitHub repository for this review.
ID of the GitHub review request submitted for this review.
String describing the current state of the GitHub review.
Date at which the review was submitted.
Time difference between when the review was requested and submitted.
Count of total comments given on the GitHub review.
URL directly to the GitHub review on the pull request.
Table for storing GitHub Secret Scanning alert data.
The secret scanning number for the repository.
ID of the repository associated with the alert.
State of the alert (e.g., open, resolved).
Type of secret causing the alert.
URL for more details about the alert.
Timestamp when the alert was resolved.
Timestamp when the alert was created.
Join table between github_users and github_teams
Unique identifier for the row.
The team the user is a member of
The user that is a member of the team
Boolean indicating if team is active
Details about Github teams
Unique identifier for the row.
Identifier of the team in Github
ID of the organization to which the team belongs
ID of of the parent team that the row is a child of
Name of the team
Boolean indicating if team is active
Organization verified email of user
Details about GitHub users.
Unique identifier for the row.
GitHub ID of the user.
ID of the GitHub organization the user belongs to.
Username of the GitHub user.
Role of the GitHub user.
Boolean indicating if the user is a bot. Also known as "Machine User".
Boolean indicating if the user is currently active.
Details about gitlab groups.
Unique identifier for the row.
Identifier of the group in Gitlab
URL of the gitlab group
Name of the gitlab group
Name of the gitlab group with hierarchy
Path of the gitlab group with the slugs
Description of the Gitlab group
Private or public
Timestamp of the creation date of the group
ID of the parent group in Gitlab
Details of the GitLab labels
Identifier of the label in GitLab
ID of the project to which the label belongs
Name of the label
Description of the label
Color code of the label
Indicates whether the label is active
Join table between merge requests and deployments
Unique identifier for the row.
ID of the merge request associated with the deployment
ID of the deployment associated with the merge request
Environment the deployment was associated with
Difference (in seconds) between deployed_at of the deployment and merged_at of the gitlab merge requests
Difference (in seconds) between deployed_at of the deployment and created_at of the gitlab merge requests
Service the deployment was associated with
Association between GitLab merge requests and labels
ID of the merge request
ID of the label
Details about Gitlab merge requests
Unique identifier for the row.
Identifier of the merge request in Gitlab
IID of the merge request
ID of the project to which the merge project belongs
ID of the user who authored the merge request
Title of the merge request
State of the merge request
Timestamp indicating when the merge request was merged
Timestamp indicating when the merge request was closed
Branch the merge request will be merged into
Branch name of the merge request
Merge commit SHA of the merge request
Timestamp of when the merge request was created
Timestamp of when the merge request was updated
Difference (in seconds) between merged_at and created_at
Difference (in seconds) between first submitted review and merge request created_at
Difference (in seconds) between first approved review and merge request created_at
URL of the merge request
Details about Gitlab projects
Unique identifier for the row.
Identifier of the project in Gitlab
ID of the Gitlab group to which the project belongs
Name of the gitlab project
Path of the gitlab project
Boolean indicating if the project is private
Default branch of the project
Boolean indicating if the project is archived
Timestamp of when the project was created
Timestamp of when the project was updated
URL of the project
Details about Gitlab reviews
Unique identifier for the row.
Identifier of the review in Gitlab
ID of the merge request where the review occurred
ID of the user who submitted the review
Timestamp of when the review was created
Timestamp of when the review was updated
Difference (in seconds) between the review created_at and the merge request created_at
Review approved or not
Type of the review
Details of the Gitlab users
Unique identifier for the row.
Identifier of the user in Gitlab
ID of the group to which the user belongs
Name of the user
Username of the user
State of the user
Timestamp of when the user was created
URL of the Gitlab user
Events from GoogleCalendar.
GoogleCalendar ID of the events.
Google calendar user's ID.
Start time of the event.
Title of the event.
Status of the event.
End time of the event.
Duration of the event.
Number of invitees.
Response status of the event of the user (accepted, tentative, declined, needsAction).
Details of custom fields in Incident.io.
Unique identifier for the row.
Key of the custom field.
Name of the custom field.
Details of custom field values associated with incidents in Incident.io.
Unique identifier for the row.
ID of the incident.
ID of the custom field.
Value of the custom field.
Details of Incident follow ups.
Unique identifier for the row.
Incident.io ID of the incident follow up.
ID of the incident.
ID of the user.
Status of Incident follow up
Priority of Incident follow up
Timestamp when Follow up is completed.
Timestamp when Follow up is created.
Timestamp when Follow up is updated.
Details of responders to incidents in Incident.io.
Unique identifier for the row.
ID of the incident.
ID of the responder.
Type of the responder.
Mapping between incidents and roles in Incident.io.
Unique identifier for the row.
ID of the incident.
ID of the role.
ID of the user assigned to the role.
Details of roles associated with incidents in Incident.io.
Unique identifier for the row.
Incident.io ID of the role.
Name of the role.
Type of the role.
Mapping between incidents and services in Incident.io.
Unique identifier for the row.
ID of the incident.
ID of the service.
Values for timestamps associated with incidents in Incident.io.
Unique identifier for the row.
ID of the incident.
ID of the incident timestamp.
Value of the timestamp.
Details of timestamps related to incidents in Incident.io.
Unique identifier for the row.
Incident.io ID of the timestamp.
Name of the timestamp.
Rank of the timestamp.
Details of incident types in Incident.io.
Unique identifier for the row.
Incident.io ID of the incident type.
Name of the incident type.
Description of the incident type.
Details of incidents in Incident.io.
Unique identifier for the row.
Incident.io ID of the incident.
URL of the incident in Incident.io.
Title of the incident.
State of the incident.
Severity of the incident.
Timestamp when the incident started.
Timestamp when the incident was resolved.
Timestamp when the incident was closed.
Time taken to resolve the incident (in seconds).
Time taken for internal response (in seconds).
ID of the associated incident type.
ID of the user who created the incident.
Mode of the incident (e.g., real, simulated).
Reference identifier for the incident.
Summary of the incident.
Visibility of the incident (e.g., public, private).
Details of on-call schedules in Incident.io.
Unique identifier for the row.
Incident.io ID of the schedule.
Name of the schedule.
ID of the user associated with the schedule shift.
Timestamp when User shift started.
Timestamp when User shift ended.
Details of services in Incident.io.
Unique identifier for the row.
Incident.io ID of the service.
Name of the service.
Details of Incident.io users.
Unique identifier for the row.
Incident.io ID of the user.
Full name of the user.
Email of the user.
Max dev days for users.
Email of the user.
Max capacity represented by a number between 0 and 1. For example, a manager working at 60% capacity as a contributor would have a value of 0.6.
When the limit takes effect. If unspecified, the record is effective until another record with a later date is added.
Details of the boards within Jira.
Unique identifier for the row.
Jira ID of the board.
Name of the board.
Type of the board.
Boolean indicating whether or not the board is private.
Mapping table that links issues to components they belong to.
Unique identifier for the row.
ID of the component.
ID of the issue.
Components are subsections of a project that help you organize and categorize work in Jira.
Unique identifier for the row.
Jira ID of the component.
URL to the component in Jira.
Name of the component.
ID of the project this component belongs to.
Details about the custom fields created in Jira.
Unique identifier for the row.
Jira unique key for the custom field. i.e. `customfield_123`
Name of the custom field.
Records of the fix versions in Jira.
Unique identifier for the row.
Jira ID of the fix version.
Name of the fix version.
Description of the fix version.
Boolean indicating if the fix version has been released.
Date at which the fix version was released.
Boolean indicating if the fix version has been archived.
Time allocation for Jira issue.
Unique identifier for the row.
ID of Jira issue.
ID of Jira user.
Number of dev days the issue took in the month.
Month that the allocated days are in.
Record of custom fields applied to issues in Jira.
Unique identifier for the row.
ID of the issue which the custom field is applied.
ID of the custom field applied to the issue.
Value of the custom field applied to the issue.
Join table that links issues to fix versions.
Unique identifier for the row.
ID of the Jira issue.
ID of the fix version.
Record of labels applied to issues in Jira.
Unique identifier for the row.
ID of the issue which the label is applied.
ID of the label applied to the issue.
Flattened hierarchical relationships between Jira issues.
Unique identifier for the row.
ID of a parent Jira issue.
ID of a child Jira issue.
Record of sprints applied to issues in Jira.
Unique identifier for the row.
ID of the project to which the issue belongs.
ID of the sprint applied to the issue.
ID of the issue which the sprint is applied.
Boolean indicating if the issue was planned for the sprint.
Date at which the issue was removed from the sprint, if ever.
Details of the history of status changes on issues within Jira.
Unique identifier for the row.
ID of the Jira issue.
ID of the Jira status.
Date which the status change occurred.
Details of the issue types used within Jira.
Unique identifier for the row.
Jira ID of the issue type.
ID of the Jira project for which this issue type belongs.
Name of the issue type.
Description of the issue type.
Integer indicating the hierarchical order of the issue type. i.e. Epic > Task > SubTask.
Binary icon data for the issue type.
Details of the issues within Jira.
Unique identifier for the row.
Jira ID of the issue
ID of the issue type of this issue.
ID of the project for which this issue belongs.
ID of the resolution for this issue, if any.
ID of the status for this issue.
ID of the priority for this issue.
ID of the user who is assigned to this issue.
ID of the user who created this issue.
URL directly to the issue within Jira.
Issue title
Identifier key from Jira of the issue.
Identifier key from Jira of the issue's parent issue.
Number of story points assigned to the issue in Jira.
Date at which the issue was resolved in Jira.
Date which the issue is Due.
Date which the issue was created.
Date which the issue was last updated.
Time difference between when the issue was started (started_at) and the issue was resolved (resolved_at).
Earliest date at which the issue changed to a `indeterminate` status category. See `jira_statuses` table for status categories.
Latest date at which the issue changed to a `done` status category. See `jira_statuses` table for status categories.
Details of the all labels in Jira.
Unique identifier for the row.
Name of the Jira label.
Description of each priority in Jira.
Unique identifier for the row.
Jira ID of the priority.
Jira URL of the priority.
Name of the priority.
Description of the priority.
Color of the priority.
Details of the your Jira projects.
Unique identifier for the row.
Jira ID of the project.
Jira indicator for the type of project.
Name of the project.
Boolean indicating whether or not the project is private.
Date at which the project was deleted, if ever.
Date at which the project was archived, if ever.
Total count of the issues within the project.
The key of the project.
Description of different Resolutions within Jira.
Unique identifier for the row.
Jira ID of the resolution.
Name of the resolution.
Description of the resolution.
Boolean indicating if this is the default resolution.
Record of sprints applied to boards in Jira.
Unique identitifer for the row.
ID of the sprint applied to the board.
ID of the board containing the sprint.
Date at which the sprint was removed from the board, if ever.
Details of the sprints within Jira.
Unique identifier for the row.
Jira ID of the sprint.
Name of the sprint.
State of the sprint.
ID of the project which the sprint belongs (deprecated).
ID of the board which the sprint belongs (deprecated).
Date at which the sprint started.
Date at which the sprint ended.
Date at which the sprint was completed.
Stores the issues that are planned for a sprint.
Unique identifier for the row.
ID of the sprint applied to the issue.
ID of the issue which the sprint is applied.
Description of each status in Jira.
Unique identifier for the row.
Jira ID of the status.
Name of the status.
Category of the status in Jira.
Description of the status.
Details of the users within Jira.
Unique identifier for the row.
Jira ID of the user.
Jira ID of the account.
Email of the user.
Name of the user.
If the user was listed in the API in the most recent sync
Details of the JSM custom fields.
JSM ID of the custom field.
JSM custom field key.
Name of the custom field.
Details of the custom field values for incidents.
ID of the related incident.
ID of the custom field.
Value of the custom field.
Details of the labels related to incidents.
ID of the related incident.
ID of the related label.
Details of the organizations related to incidents.
ID of the related incident.
ID of the related organization.
Details of the services related to incidents.
ID of the related incident.
ID of the related service.
Details of the JSM incidents.
JSM ID of the incident.
JSM incident key.
Summary of the incident.
URL of the incident.
Priority of the incident.
ID of the assigned user.
Status of the incident.
ID of the incident creator.
ID of the incident reporter.
ID of the associated project.
Date the incident was resolved.
Whether the incident is marked as major.
Date the incident was created.
Date the incident was last updated.
Details of the JSM labels.
Name of the label.
Details of the JSM organizations.
JSM ID of the organization.
Name of the organization.
Details of the JSM projects.
JSM ID of the project.
JSM project key.
Name of the project.
Last synced incident date.
Active Projects
Details of the JSM services.
JSM ID of the service.
Name of the service.
Details of the JSM users.
JSM account ID of the user.
Account type of the user.
Email of the user.
Name of the user.
Whether the user is active.
Association between feature flags and environments in LaunchDarkly
Unique identifier of the row
ID of the environment in which the feature flag exists
ID of the feature flag associated with the environment
Indicates if the feature flag in the environment is archived
Indicates if the feature flag is on in the environment
Association between feature flags and tags in LaunchDarkly
Unique identifier of the row
ID of the feature flag associated with the tag
ID of the tag associated with the feature flag
Details about feature flags in LaunchDarkly
Unique identifier of the row
Key of the feature flag in LaunchDarkly
ID of the project to which the feature flag belongs
Name of the feature flag
Kind of the feature flag
Indicates if the feature flag is archived
Date when the feature flag was archived
Indicates if the feature flag is deprecated
Date when the feature flag was deprecated
Indicates if the feature flag is temporary
ID of the user who maintains the feature flag
ID of the team responsible for the feature flag
Date when the feature flag was created
Date when the feature flag was last synced
Details about environments for LaunchDarkly projects
Unique identifier of the row
ID of the environment in LaunchDarkly
Key of the environment in LaunchDarkly
ID of the project to which the environment belongs
Name of the environment
Indicates if the environment is accessible via API
Details about LaunchDarkly projects
Unique identifier of the row
ID of the project in LaunchDarkly
Key of the project in LaunchDarkly
Name of the project
Indicates if the project is accessible via API
Details about LaunchDarkly tags
Unique identifier of the row
Name of the tag
Association between LaunchDarkly users and teams for maintainers
Unique identifier of the row
ID of the user who is a maintainer
ID of the team to which the maintainer is associated
Details about LaunchDarkly teams
Unique identifier of the row
Key of the team in LaunchDarkly
Name of the team
Date when the team was created
Date when the team was last updated
Details about LaunchDarkly users
Unique identifier of the row
ID of the user in LaunchDarkly
Email of the user
First name of the user
Last name of the user
Role of the user
Join table between issues and labels
Unique identifier for the row
ID of the issue the label is associated with
ID of the label the issue is associated with
Records of the states issues have had
Unique identifier for the row
ID of the Linear issue to which the record belongs
ID of the Linear state the issue was changed to
Timestamp indicating when DX tracked a change in state
Details about Linear issues
Unique identifier for the row
Identifier in Linear of the issue
ID of the user who is assigned the issue
ID of the parent linear issue
ID of the user who created the issue
ID of the project to which the issue belongs
State that the linear issue is in
ID of the team to which the issue belongs
URL of the issue
Issue's human readable identifier (eg ENG-123)
Issue number
The time at which the entity was archived
The time at which the issue was automatically archived by the auto pruning process
The time at which the issue was automatically closed by the auto pruning process
The estimated start date of the project.
The time at which the issue was moved into started state
The time at which the issue was moved into completed state
The time at which the issue was moved into canceled state
The time at which the issue entered triage
The time at which the issue left triage
Time difference between when the issue was started (started_at) and the issue was completed (completed_at).
The time until an issue will be snoozed in Triage view
Title of the issue
The estimate of the complexity of the issue
The priority of the issue 0 = No priority, 1 = Urgent, 2 = High, 3 = Normal, 4 = Low
Label for the priority
The date at which the issue is due
Boolean that indicates whether the issue is in the trash bin
Details about Linear labels
Unique identifier for the row
Identifier of the label in Linear
ID of the team to which the label belongs
Description of the label
Name of the label
Timestamp of when the label was created
Timestamp of when the label was updated
Details about the Linear organization
Unique identifier for the row
Identifier of the organization in Linear
The time at which the entity was archived
The time at which deletion of the organization was requested
Name of the organization
Timestamp when the organization was created in Linear
Timestamp when the organization was updated in Linear
Details about Linear projects
Unique identifier for the row
Identifier of the project in Linear
Timestamp of when the project was archived
The time at which the project was automatically archived by the auto pruning process
Timestamp of when the project was canceled
Timestamp of when the project was completed
Array of completed issues in the project after each week
Array of completed estimation points after each week
Description of the project
Array of in progress estimation points after each week
Array of issues in the project after each week
Name of the linear project
The overall progress of the project. This is the (completed estimate points + 0.25 * in progress estimate points) / total estimate points.
The overall scope (total estimate points) of the project
Array of estimation points after each week
The time at which the project was moved into started state
The type of the state
The estimated completion date of the project
Timestamp of when the project was created in Linear
Timestamp of when the project was updated in Linear
Details about Linear states
Unique identifier for the row
Identifier of the state in Linear
ID of the team to which the state belongs
The time at which the entity was archived
Description of the state
Name of the state
The position of the state in the team flow
The type of the state. One of 'triage', 'backlog', 'unstarted', 'started', 'completed', 'canceled'.
Timestamp of when the state was created in Linear
Timestamp of when the state was updated in Linear
Join table between Linear teams and Linear projects
Unique identifier for the row
ID of the team with which the project is associated
ID of the project with which the team is associated
Details about Linear teams
Unique identifier for the row
Identifier of the team in Linear
ID of the organization to which the team belongs
Description of the team
The team's unique key
Name of the team
Issues associated with the team
Boolean indicating if the team is private
Timestamp of when the team was archived
Timestamp of when the team was created in Linear
Timestamp of when the team was updated in Linear
Details about Linear users.
Unique identifier for the row
Identifier of the user in Linear
Email of the user
Name of the user
Details about New Relic entities
Unique identifier of the row
ID of the entity in New Relic
Name of the entity
Account ID associated with the entity
Indicates if the entity is accessible via API
Details about New Relic SLIs (Service Level Indicators)
Unique identifier of the row
ID of the SLI in New Relic
ID of the associated entity
Name of the SLI
Indicator value of the SLI
Date when the SLI was created
Date when the SLI was last updated
Indicates if the SLI is accessible via API
Details about New Relic SLOs (Service Level Objectives)
Unique identifier of the row
ID of the associated SLI
Target percentage of the SLO
Time window for the SLO
Attainment value of the SLO
Join table between Opsgenie alerts and responders. A responder can be a user or a team
Unique identifier for the row
ID of the alert associated with the responder
ID of the responder associated with the alert
'Team' or 'User'
Details about OpsGenie alerts.
Unique identifier for the row
Identifier of the alert in Opsgenie
Client-defined identifier of the alert, that is also the key element of Alert De-Duplication
Message of the alert
Status of the alert
Boolean indicating if the alert was acknowledged
Number of times the alert occurred
Most recent occurrence of the alert
Timestamp of when the alert was created
Timestamp of when the alert was updated
Source of the alert (Azure, Datadog, Pingdom, etc.)
Owner of the alert
Priority level of the alert. Possible values are P1, P2, P3, P4 and P5. Default value is P3.
Time (in seconds) to acknowledge
Time (in seconds) to close
Join table between incidents and responders. A responder can be a user or a team
Unique identifier for the row
ID of the incident associated with the responder
ID of the team or user associated with the incident
'Team' or 'User'
Details of Opsgenie incidents
Unique identifier for the row
Identifier of the incident in Opsgenie
Message of the incident
Status of the incident
Priority level of the incident. Possible values are P1, P2, P3, P4 and P5. Default value is P3.
URL of the incident
Timestamp of when the incident first began
Details of Opsgenie teams
Unique identifier for the row
Identifier of the team in Opsgenie
Name of the team
Description of the team
URL of the team
Join table between Opsgenie users and teams
Unique identifier for the row
ID of the user associated with the team
ID of the team associated with the user
Details about Opsgenie users
Unique identifier for the row
Identifier of the user in Opsgenie
Username of the user
Full name of the user
Role of the user (Owner, Admin, User)
Join table between incidents and teams
Unique identifier of the row
ID of the incident with which the team is associated
ID of the team with which the incident is associated
Details about PagerDuty incidents
Unique identifier of the row
Identifier of the incident in PagerDuty
ID of the service to which the incident belongs
The number of the incident (unique to the account)
Summary of the priority, often the same as name
URL of the incident
The current status of the incident
Title of the incident
Urgency level of the incident
Count of all alerts
Count of triggered alerts
Count of alerts resolved
Timestamp when the incident was created
Timestamp when the incident was resolved
Boolean indicating if the incident auto resolved
Count of unique notifications
Number of acknowledged entries in incident logs
Number of unacknowledged entries in incident logs
Number of non-user escalations
Number of user escalations
Seconds to the first ack
Total number of unique interruptions during business hours; 8am-6pm Mon-Fri, based on the user’s time zone
Time from when an incident was triggered until it was resolved
The total response effort in seconds, as defined by the user
Total number of unique interruptions during off hours; 6pm-10pm Mon-Fri and all day Sat-Sun, based on the user’s time zone
Total number of unique interruptions during sleep hours; 10pm-8am every day, based on the user’s time zone
Details about PagerDuty services
Unique identifier of the row
Identifier of the service in PagerDuty
Name of the service
The current state of the service. Allowed values: 'active', 'warning', 'critical', 'maintenance', 'disabled'
URL of the service
Timestamp of when the service was created in PagerDuty
Most recent incident timestamp
Service api_accessible or not
Join table between teams and users
Unique identifier of the row
ID of the team to which the user belongs
ID of the user belonging to the team
Details about PagerDuty teams
Unique identifier of the row
Identifier of the team in PagerDuty
Name of the PagerDuty team
URL of the team
Details about PagerDuty users
Unique identifier of the row
Identifier of the user in PagerDuty
Email of the user
Role of the user
URL of the user
Instances of pipeline runs
Unique identifier of the row
Unique identifier of the row created by DX from data from the upstream source
ID of the pipeline_source to which it belongs
Name of the pipeline run
Resulting status of the pipeline run
When the pipeline run began
When the pipeline run finished
Duration of the pipeline run in seconds
Name of the repository the pipeline run belongs to
Commit sha referenced by the pipeline run
ID of the user whose action initiated the pipeline run
Email of the user whose action initiated the pipeline run, if provided
URL of the pipeline run
Name of the head branch triggering the pipeline run
Stores the different sources an instance is connected to
Unique identifier of the row
Name of the source (e.g., "Github Actions", "Azure DevOps Pipelines")
Boolean indicating if the source is a customer pushing the data into DX via an the API
Names of pipeline stages that have been run. Used for Gitlab and Azure DevOps.
Unique identifier of the row
Name of the pipeline stage
Name of the repository
Details of the Rollbar environments.
System-wide Environment ID.
ID of the associated project.
Name of the environment.
Whether the environment is visible.
Details of the Rollbar items.
System-wide Item ID.
ID of the associated environment.
Computed title of the item.
Project-wide Item ID.
Timestamp of the most recent occurrence.
Timestamp of the first occurrence.
ID of the associated project.
Status of the item.
Item level (critical, error, warning, info, debug).
Total number of occurrences since last resolution.
Timestamp the item was last resolved.
Timestamp when the item was last synced.
Details of the Rollbar projects.
System-wide Project ID.
Name of the project.
Status of the project.
Date the project was created.
Date the project was last updated.
Whether the project is accessible via API.
Details of custom field values linked to incidents.
Unique identifier for the row.
Rootly ID of the incident.
ID of the incident.
ID of the custom field.
The value of the incident_custom_field_selection.
Details of Rootly custom fields.
Unique identifier for the row.
Rootly ID of the custom field.
Name of the custom field.
Details of the association between incidents and services in Rootly.
Unique identifier for the row.
ID of the incident.
ID of the service.
Details of the association between incidents and teams in Rootly.
Unique identifier for the row.
ID of the incident.
ID of the team.
Details of Rootly incidents.
Unique identifier for the row.
Rootly ID of the incident.
Title of the incident.
State of the incident.
Severity of the incident.
Timestamp when the incident started.
Timestamp when the incident was detected.
Timestamp when the incident was acknowledged.
Timestamp when the incident was mitigated.
Timestamp when the incident was resolved.
Timestamp when the incident was cancelled.
Timestamp when the incident was created.
Time taken to resolve the incident (in seconds).
Time taken for internal response (in seconds).
Time taken to detect the incident (in seconds).
Details of Rootly services.
Unique identifier for the row.
Rootly ID of the service.
Name of the service.
Description of the service.
Details of Rootly teams.
Unique identifier for the row.
Rootly ID of the team.
Handle of the team.
Name of the team.
Details of the association between users and teams in Rootly.
Unique identifier for the row.
ID of the user.
ID of the team.
Details of Rootly users.
Unique identifier for the row.
Rootly ID of the user.
Full name of the user.
Email of the user.
Details of the environments associated with Sentry issues.
Name of the environment.
ID of the issue to which the environment belongs.
Total count of occurrences in the environment.
Date the environment was last seen.
Date the environment was first seen.
Details of the Sentry issues.
System-wide Issue ID.
ID of the project to which the issue belongs.
Title of the issue.
URL of the issue.
Level of the issue (e.g., error, warning, info).
Status of the issue (e.g., resolved, unresolved).
Platform where the issue occurred.
Type of the issue.
Category of the issue.
Priority of the issue.
Total count of occurrences of the issue.
Date the issue was first seen.
Date the issue was last seen.
Date the issue was last synced.
Details of the Sentry organizations.
System-wide Organization ID.
Name of the organization.
Slug of the organization.
Status of the organization.
Date the organization was created.
Whether the organization is accessible via API.
Details of the Sentry projects.
System-wide Project ID.
ID of the organization to which the project belongs.
Name of the project.
Slug of the project.
Date the project was created.
Whether the project is accessible via API.
Details about ServiceNow groups
Unique identifier of the group in the ServiceNow system
Name of the group
Incident custom field values
ID of the the incident
Name of custom field
Value of custom field
Display value of custom field
Details about ServiceNow incidents
Unique identifier of the incident in the ServiceNow system
URL pointing to the incident in ServiceNow
Incident number in the ServiceNow system
Brief description of the incident
Current state of the incident (e.g., New, In Progress, Closed)
Priority level of the incident
Severity level of the incident
Urgency level of the incident
Impact level of the incident
Category of the incident (e.g., Software, Hardware)
Date and time when the incident was opened
Date and time when the incident was closed
Date and time when the incident was resolved
Whether the incident is currently active
ID of the user who opened the incident
ID of the user who closed the incident
ID of the user who resolved the incident
ID of the caller (user who reported the incident)
ID of the service associated with the incident
ID of the assignee (user who assign to the incident)
ID of the group handling the incident
Date and time when the record was created
Date and time when the record was last updated
Details about ServiceNow services
Unique identifier of the service in the ServiceNow system
Name of the service
Details about ServiceNow users
Unique identifier of the user in the ServiceNow system
Name of the user
Email of the user
Details about Shortcut stories
Unique identifier of the row
Identifier of the story in Shortcut
An array of UUIDs of the users who are owners
ID of the team which owns the story
Name of the Shortcut story
The estimate (or point value) for the Story
The cycle time (in seconds) of this story when complete.
Timestamp of when the story was created
Timestamp of when the story was updated
Timestamp of when the story was completed
Timestamp of when the story was started
Boolean indicating if the Story is currently blocked
Boolean if the story has been archived
Boolean indicating if the story has been completed
Boolean indicating if the story has been started
The type of story (feature, bug, chore)
URL of the story
Join table between Shortcut stories and users
Unique identifier of the row
ID of the story the user is an owner of
ID of the user that is an owner of the story
Changes of workflow state of a story
Unique identifier of the row
Identifier of the story history in Shortcut
Name of the previous workflow state
Previous workflow state ID
Name of the new workflow state
New workflow state ID
When the workflow state changed
Timestamp of when the user was created in Shortcut
Timestamp of when the user was updated in Shortcut
Join table between Shortcut users and teams
Unique identifier of the row
ID of the team the user belongs to
ID of the user on the team
Details about Shortcut teams
Unique identifier of the row
Identifier of the team in Shortcut
An array of UUIDs of users on the team
Name of the team
Description of the team
Boolean indicating if the team is archived
Number of stories assigned to the team
Details about Shortcut users
Unique identifier of the row
Identifier of the user in Shortcut
Name of the user
Email of the user
Boolean indicating if the user is disabled
Timestamp of when the user was created in Shortcut
Timestamp of when the user was updated in Shortcut
Details about Shortcut workflow states
Unique identifier of the row
Identifier of the workflow state in Shortcut
ID of the workflow to which the workflow state belongs
Type of workflow state
Name of the workflow state
Description of the workflow state
Position of the workflow state
Timestamp of when the user was created in Shortcut
Timestamp of when the user was updated in Shortcut
Details about Shortcut workflows
Unique identifier of the row
Identifier of the workflow in Shortcut
Name of the workflow
Description of the workflow
Timestamp of when the user was created in Shortcut
Timestamp of when the user was updated in Shortcut
Details about Snyk issues
Unique identifier of the row
ID of the issue in Snyk
Key of the issue in Snyk
ID of the project to which the issue belongs
Title of the issue
Tool associated with the issue
Effective severity level of the issue
Status of the issue
Indicates if the issue is ignored
Type of the issue
Risk score of any Incident
Date when the issue was resolved
Date when the issue was created
Date when the issue was last updated
Details about Snyk organizations
Unique identifier of the row
ID of the organization in Snyk
Name of the organization
Slug of the organization
Indicates if the organization is accessible via API
Date when the organization was created
Date when the organization was last updated
Details about Snyk projects
Unique identifier of the row
ID of the project in Snyk
Name of the project
Origin of the project
Status of the project
ID of the organization to which the project belongs
Date when the project was created
Indicates if the project is accessible via API
Date at project issues have been synced
Join table between SonarCloud issues and tags
Unique identifier of the row
ID of the issue to which the tag is associated
ID of the tag associated with the issue
Details about SonarCloud issues
Unique identifier of the row
Key of the issue in SonarCloud
Component related to the issue
Rule associated with the issue
Severity of the issue
ID of the project to which the issue belongs
Effort required to resolve the issue
Debt associated with the issue
Status of the issue
Type of the issue
Category of clean code attributes
Specific clean code attribute
Date when the issue was created
Date when the issue was last updated
Details about SonarCloud metrics
Unique identifier of the row
ID of the metric in SonarCloud
Key of the metric in SonarCloud
Type of the source for the metric
Name of the metric
Domain of the metric
Details about SonarCloud organizations
Unique identifier of the row
Name of the organization
Details about metrics associated with SonarCloud projects
Unique identifier of the row
ID of the project to which the metric is associated
ID of the metric associated with the project
Date when project metric imported
Value of the metric for the project
Details about SonarCloud projects
Unique identifier of the row
Key of the project in SonarCloud
ID of the organization to which the project belongs
Name of the project
Qualifier of the project
Visibility of the project
Date of the last analysis
Project is api accessible or not
Details about SonarCloud security hotspots
Unique identifier of the row
Key of the security hotspot in SonarCloud
Component related to the security hotspot
ID of the project to which the security hotspot belongs
Security category of the hotspot
Probability of the vulnerability occurring
Status of the security hotspot
Key of the rule associated with the security hotspot
Date when the security hotspot was created
Date when the security hotspot was last updated
Date marked as deleted if hotspot is no longer accessible via API
Details about SonarCloud tags
Unique identifier of the row
Name of the tag
Join table between SonarQube issues and tags
Unique identifier of the row
ID of the issue to which the tag is associated
ID of the tag associated with the issue
Details about SonarQube issues
Unique identifier of the row
Key of the issue in SonarQube
Component related to the issue
Rule associated with the issue
Severity of the issue
ID of the project to which the issue belongs
Effort required to resolve the issue
Debt associated with the issue
Status of the issue
Type of the issue
Category of clean code attributes
Specific clean code attribute
Date when the issue was created
Date when the issue was last updated
Details about SonarQube metrics
Unique identifier of the row
ID of the metric in SonarQube
Key of the metric in SonarQube
Type of the source for the metric
Name of the metric
Domain of the metric
Details about metrics associated with SonarQube projects
Unique identifier of the row
ID of the project to which the metric is associated
ID of the metric associated with the project
Date when project metric imported
Value of the metric for the project
Details about SonarQube projects
Unique identifier of the row
Key of the project in SonarQube
Name of the project
Qualifier of the project
Visibility of the project
Date of the last analysis
Project is api accessible or not
Details about SonarQube security hotspots
Unique identifier of the row
Key of the security hotspot in SonarQube
Component related to the security hotspot
ID of the project to which the security hotspot belongs
Security category of the hotspot
Probability of the vulnerability occurring
Status of the security hotspot
Key of the rule associated with the security hotspot
Date when the security hotspot was created
Date when the security hotspot was last updated
Date marked as deleted if hotspot is no longer accessible via API
Details about SonarQube tags
Unique identifier of the row
Name of the tag
Monitors continuously query data to monitor and send notifications when specific events occur.
Sumo Logic ID of the SLO.
The name of the SLO.
Description of the SLO.
ID of SLO to which the monitor belongs.
Status of the monitor.
SLIs represent quantifiable metrics used to measure the performance, reliability, or quality of a service against defined objectives.
Whether the SLI computation is complete / had an error / is in progress.
SLI percentage for the compliance period. (Available if status is Success)
Percentage of error budget remaining for the compliance period. (Available if status is Success)
Formatted string for the absolute error budget remaining. (Available if status is Success)
SLI computation progress.
ID of SLO to which the SLI value belongs.
SLOs are used to monitor and alert on KPIs for most important services or user experience.
Sumo Logic ID of the SLO.
The name of the SLO.
Description of the SLO.