Azure DevOps connector reference

Important

This feature is in Beta. To use it, a workspace admin must turn on Lakeflow Connect for Azure DevOps from the Previews page. See Manage Azure Databricks previews.

This page has reference information for the managed Azure DevOps connector, including supported source tables and destination table schemas.

Supported source tables

The Azure DevOps connector supports the following source tables, all under the default source schema:

Source table	Primary key	Description	Sync mode	Cursor field
projects	id	Projects in the organization.	Full refresh only
area_paths	project_id, identifier	Area path classification nodes for each project.	Full refresh only
teams	id	Teams in the organization.	Full refresh only
iterations	project_id, identifier	Iteration path classification nodes for each project.	Full refresh only
git_repositories	id	Git repositories in each project.	Full refresh only
commits	commitId, repository_id	Commits in each Git repository.	Incremental	committedDate
build_definitions	id, project_id	Build pipeline definitions in each project.	Full refresh only
groups	descriptor	Security groups in the organization.	Full refresh only
group_members	containerDescriptor, memberDescriptor	Direct members of each group.	Full refresh only
users	descriptor	Users in the organization.	Full refresh only
service_principals	descriptor	Service principals in the organization.	Full refresh only
work_items	id, rev	Work item revisions in each project, including deleted work items.	Full refresh only
builds	id, project_id	Builds in each project, excluding deleted builds.	Full refresh only
pull_requests	pullRequestId, repository_id	Pull requests in each Git repository, in any status.	Full refresh only
releases	id, project_id	Classic releases in each project, excluding deleted releases.	Full refresh only
test_runs	id, project_id	Test runs in each project.	Full refresh only
service_hooks_subscriptions	id	Service hook subscriptions in the organization.	Full refresh only

Connector options

For usage, see Examples.

Option	Type	Scope	Required	Applies to	Description
start_datetime	String	Pipeline	No	commits	Earliest commit date to ingest on the first sync, in yyyy-MM-dd'T'HH:mm:ss'Z' format. Defaults to 180 days before the sync.

Destination table schemas

projects

Primary key: id Sync mode: Full refresh only

Field	Data type
id	STRING
name	STRING
abbreviation	STRING
description	STRING
url	STRING
state	STRING
revision	BIGINT
visibility	STRING
lastUpdateTime	TIMESTAMP
defaultTeamImageUrl	STRING

area_paths

Primary key: project_id, identifier Sync mode: Full refresh only

Field	Data type
id	BIGINT
identifier	STRING
name	STRING
structureType	STRING
hasChildren	BOOLEAN
path	STRING
url	STRING
children	VARIANT
project_id	STRING
project_name	STRING
_links	VARIANT
attributes	MAP<STRING,VARIANT>

Note

This table does not support SCD type 2 because it has VARIANT columns.

teams

Primary key: id Sync mode: Full refresh only

Field	Data type
id	STRING
name	STRING
description	STRING
url	STRING
identityUrl	STRING
projectName	STRING
projectId	STRING
identity	VARIANT

Note

This table does not support SCD type 2 because it has VARIANT columns.

iterations

Primary key: project_id, identifier Sync mode: Full refresh only

Field	Data type
id	BIGINT
identifier	STRING
name	STRING
structureType	STRING
hasChildren	BOOLEAN
path	STRING
url	STRING
children	VARIANT
project_id	STRING
project_name	STRING
_links	VARIANT
attributes	MAP<STRING,VARIANT>

Note

This table does not support SCD type 2 because it has VARIANT columns.

git_repositories

Primary key: id Sync mode: Full refresh only

Field	Data type
id	STRING
name	STRING
url	STRING
defaultBranch	STRING
remoteUrl	STRING
sshUrl	STRING
webUrl	STRING
size	BIGINT
isDisabled	BOOLEAN
isFork	BOOLEAN
isInMaintenance	BOOLEAN
validRemoteUrls	ARRAY<STRING>
project	STRUCT<abbreviation: STRING, defaultTeamImageUrl: STRING, description: STRING, id: STRING, lastUpdateTime: TIMESTAMP, name: STRING, revision: BIGINT, state: STRING, url: STRING, visibility: STRING>
parentRepository	STRUCT<collection: STRUCT<avatarUrl: STRING, id: STRING, name: STRING, url: STRING>, id: STRING, isFork: BOOLEAN, name: STRING, project: STRUCT<abbreviation: STRING, defaultTeamImageUrl: STRING, description: STRING, id: STRING, lastUpdateTime: TIMESTAMP, name: STRING, revision: BIGINT, state: STRING, url: STRING, visibility: STRING>, remoteUrl: STRING, sshUrl: STRING, url: STRING>
project_id	STRING
project_name	STRING
_links	VARIANT

Note

This table does not support SCD type 2 because it has VARIANT columns.

commits

Primary key: commitId, repository_id Cursor field: committedDate

Field	Data type
commitId	STRING
comment	STRING
commentTruncated	BOOLEAN
commitTooManyChanges	BOOLEAN
remoteUrl	STRING
url	STRING
author	STRUCT<name: STRING, email: STRING, date: TIMESTAMP, imageUrl: STRING>
committer	STRUCT<name: STRING, email: STRING, date: TIMESTAMP, imageUrl: STRING>
changeCounts	MAP<STRING,BIGINT>
parents	ARRAY<STRING>
workItems	ARRAY<STRUCT<id: STRING, url: STRING>>
push	STRUCT<_links: VARIANT, date: TIMESTAMP, pushId: BIGINT, pushedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, url: STRING>
committedDate	TIMESTAMP
repository_id	STRING
repository_name	STRING
project_id	STRING
_links	VARIANT
changes	ARRAY<STRUCT<changeId: BIGINT, changeType: STRING, item: VARIANT, newContent: STRUCT<content: STRING, contentType: STRING>, newContentTemplate: STRUCT<name: STRING, type: STRING>, originalPath: STRING, sourceServerItem: STRING, url: STRING>>
statuses	ARRAY<STRUCT<_links: VARIANT, context: STRUCT<genre: STRING, name: STRING>, createdBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, creationDate: TIMESTAMP, description: STRING, id: BIGINT, state: STRING, targetUrl: STRING, updatedDate: TIMESTAMP>>

Note

This table does not support SCD type 2 because it has VARIANT columns.

build_definitions

Primary key: id, project_id Sync mode: Full refresh only

Field	Data type
id	BIGINT
name	STRING
path	STRING
revision	INT
queueStatus	STRING
type	STRING
url	STRING
uri	STRING
quality	STRING
authoredBy	STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>
queue	STRUCT<_links: VARIANT, id: BIGINT, name: STRING, pool: STRUCT<id: BIGINT, isHosted: BOOLEAN, name: STRING>, url: STRING>
project	STRUCT<abbreviation: STRING, defaultTeamImageUrl: STRING, description: STRING, id: STRING, lastUpdateTime: TIMESTAMP, name: STRING, revision: BIGINT, state: STRING, url: STRING, visibility: STRING>
createdDate	TIMESTAMP
project_id	STRING
project_name	STRING
_links	VARIANT
draftOf	STRUCT<createdDate: TIMESTAMP, id: BIGINT, name: STRING, path: STRING, project: STRUCT<abbreviation: STRING, defaultTeamImageUrl: STRING, description: STRING, id: STRING, lastUpdateTime: TIMESTAMP, name: STRING, revision: BIGINT, state: STRING, url: STRING, visibility: STRING>, queueStatus: STRING, revision: BIGINT, type: STRING, uri: STRING, url: STRING>
drafts	ARRAY<STRUCT<createdDate: TIMESTAMP, id: BIGINT, name: STRING, path: STRING, project: STRUCT<abbreviation: STRING, defaultTeamImageUrl: STRING, description: STRING, id: STRING, lastUpdateTime: TIMESTAMP, name: STRING, revision: BIGINT, state: STRING, url: STRING, visibility: STRING>, queueStatus: STRING, revision: BIGINT, type: STRING, uri: STRING, url: STRING>>
latestBuild	STRUCT<_links: VARIANT, agentSpecification: STRUCT<identifier: STRING>, appendCommitMessageToRunName: BOOLEAN, buildNumber: STRING, buildNumberRevision: BIGINT, controller: STRUCT<_links: VARIANT, createdDate: TIMESTAMP, description: STRING, enabled: BOOLEAN, id: BIGINT, name: STRING, status: STRING, updatedDate: TIMESTAMP, uri: STRING, url: STRING>, definition: STRUCT<createdDate: TIMESTAMP, drafts: ARRAY<VARIANT>, id: BIGINT, name: STRING, path: STRING, project: VARIANT, queueStatus: STRING, revision: BIGINT, type: STRING, uri: STRING, url: STRING>, deleted: BOOLEAN, deletedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, deletedDate: TIMESTAMP, deletedReason: STRING, demands: ARRAY<STRUCT<name: STRING, value: STRING>>, finishTime: TIMESTAMP, id: BIGINT, lastChangedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, lastChangedDate: TIMESTAMP, logs: STRUCT<id: BIGINT, type: STRING, url: STRING>, orchestrationPlan: STRUCT<orchestrationType: BIGINT, planId: STRING>, parameters: STRING, plans: ARRAY<STRUCT<orchestrationType: BIGINT, planId: STRING>>, priority: STRING, project: STRUCT<abbreviation: STRING, defaultTeamImageUrl: STRING, description: STRING, id: STRING, lastUpdateTime: TIMESTAMP, name: STRING, revision: BIGINT, state: STRING, url: STRING, visibility: STRING>, properties: MAP<STRING,VARIANT>, quality: STRING, queue: STRUCT<_links: VARIANT, id: BIGINT, name: STRING, pool: STRUCT<id: BIGINT, isHosted: BOOLEAN, name: STRING>, url: STRING>, queueOptions: STRING, queuePosition: BIGINT, queueTime: TIMESTAMP, reason: STRING, repository: STRUCT<checkoutSubmodules: BOOLEAN, clean: STRING, defaultBranch: STRING, id: STRING, name: STRING, properties: MAP<STRING,STRING>, rootFolder: STRING, type: STRING, url: STRING>, requestedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, requestedFor: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, result: STRING, retainedByRelease: BOOLEAN, sourceBranch: STRING, sourceVersion: STRING, startTime: TIMESTAMP, status: STRING, tags: ARRAY<STRING>, templateParameters: MAP<STRING,STRING>, triggerInfo: MAP<STRING,STRING>, triggeredByBuild: VARIANT, uri: STRING, url: STRING, validationResults: ARRAY<STRUCT<message: STRING, result: STRING>>>
latestCompletedBuild	STRUCT<_links: VARIANT, agentSpecification: STRUCT<identifier: STRING>, appendCommitMessageToRunName: BOOLEAN, buildNumber: STRING, buildNumberRevision: BIGINT, controller: STRUCT<_links: VARIANT, createdDate: TIMESTAMP, description: STRING, enabled: BOOLEAN, id: BIGINT, name: STRING, status: STRING, updatedDate: TIMESTAMP, uri: STRING, url: STRING>, definition: STRUCT<createdDate: TIMESTAMP, drafts: ARRAY<VARIANT>, id: BIGINT, name: STRING, path: STRING, project: VARIANT, queueStatus: STRING, revision: BIGINT, type: STRING, uri: STRING, url: STRING>, deleted: BOOLEAN, deletedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, deletedDate: TIMESTAMP, deletedReason: STRING, demands: ARRAY<STRUCT<name: STRING, value: STRING>>, finishTime: TIMESTAMP, id: BIGINT, lastChangedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, lastChangedDate: TIMESTAMP, logs: STRUCT<id: BIGINT, type: STRING, url: STRING>, orchestrationPlan: STRUCT<orchestrationType: BIGINT, planId: STRING>, parameters: STRING, plans: ARRAY<STRUCT<orchestrationType: BIGINT, planId: STRING>>, priority: STRING, project: STRUCT<abbreviation: STRING, defaultTeamImageUrl: STRING, description: STRING, id: STRING, lastUpdateTime: TIMESTAMP, name: STRING, revision: BIGINT, state: STRING, url: STRING, visibility: STRING>, properties: MAP<STRING,VARIANT>, quality: STRING, queue: STRUCT<_links: VARIANT, id: BIGINT, name: STRING, pool: STRUCT<id: BIGINT, isHosted: BOOLEAN, name: STRING>, url: STRING>, queueOptions: STRING, queuePosition: BIGINT, queueTime: TIMESTAMP, reason: STRING, repository: STRUCT<checkoutSubmodules: BOOLEAN, clean: STRING, defaultBranch: STRING, id: STRING, name: STRING, properties: MAP<STRING,STRING>, rootFolder: STRING, type: STRING, url: STRING>, requestedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, requestedFor: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, result: STRING, retainedByRelease: BOOLEAN, sourceBranch: STRING, sourceVersion: STRING, startTime: TIMESTAMP, status: STRING, tags: ARRAY<STRING>, templateParameters: MAP<STRING,STRING>, triggerInfo: MAP<STRING,STRING>, triggeredByBuild: VARIANT, uri: STRING, url: STRING, validationResults: ARRAY<STRUCT<message: STRING, result: STRING>>>
metrics	ARRAY<STRUCT<date: TIMESTAMP, intValue: BIGINT, name: STRING, scope: STRING>>

Note

This table does not support SCD type 2 because it has VARIANT columns.

groups

Primary key: descriptor Sync mode: Full refresh only

Field	Data type
descriptor	STRING
displayName	STRING
description	STRING
principalName	STRING
mailAddress	STRING
domain	STRING
subjectKind	STRING
origin	STRING
originId	STRING
url	STRING
_links	VARIANT
legacyDescriptor	STRING

Note

This table does not support SCD type 2 because it has VARIANT columns.

group_members

Primary key: containerDescriptor, memberDescriptor Sync mode: Full refresh only

Field	Data type
containerDescriptor	STRING
memberDescriptor	STRING
_links	VARIANT
group_display_name	STRING

Note

This table does not support SCD type 2 because it has VARIANT columns.

users

Primary key: descriptor Sync mode: Full refresh only

Field	Data type
descriptor	STRING
principalName	STRING
displayName	STRING
mailAddress	STRING
domain	STRING
directoryAlias	STRING
metaType	STRING
isDeletedInOrigin	BOOLEAN
origin	STRING
originId	STRING
subjectKind	STRING
url	STRING
_links	VARIANT
legacyDescriptor	STRING

Note

This table does not support SCD type 2 because it has VARIANT columns.

service_principals

Primary key: descriptor Sync mode: Full refresh only

Field	Data type
descriptor	STRING
applicationId	STRING
principalName	STRING
displayName	STRING
mailAddress	STRING
domain	STRING
directoryAlias	STRING
metaType	STRING
isDeletedInOrigin	BOOLEAN
origin	STRING
originId	STRING
subjectKind	STRING
url	STRING
_links	VARIANT
legacyDescriptor	STRING

Note

This table does not support SCD type 2 because it has VARIANT columns.

work_items

Primary key: id, rev Sync mode: Full refresh only

Field	Data type
id	BIGINT
rev	INT
url	STRING
changedDate	TIMESTAMP
state	STRING
workItemType	STRING
title	STRING
deleted	BOOLEAN
deletedDate	TIMESTAMP
fields	VARIANT
project_id	STRING
project_name	STRING
_links	VARIANT
commentVersionRef	STRUCT<commentId: BIGINT, createdInRevision: BIGINT, isDeleted: BOOLEAN, text: STRING, url: STRING, version: BIGINT>
relations	ARRAY<STRUCT<attributes: MAP<STRING,VARIANT>, rel: STRING, url: STRING>>

Note

This table does not support SCD type 2 because it has VARIANT columns.

builds

Primary key: id, project_id Sync mode: Full refresh only

Field	Data type
id	BIGINT
buildNumber	STRING
status	STRING
result	STRING
reason	STRING
priority	STRING
deleted	BOOLEAN
queueTime	TIMESTAMP
startTime	TIMESTAMP
finishTime	TIMESTAMP
sourceBranch	STRING
sourceVersion	STRING
url	STRING
uri	STRING
tags	ARRAY<STRING>
definition	STRUCT<createdDate: TIMESTAMP, id: BIGINT, name: STRING, path: STRING, project: STRUCT<abbreviation: STRING, defaultTeamImageUrl: STRING, description: STRING, id: STRING, lastUpdateTime: TIMESTAMP, name: STRING, revision: BIGINT, state: STRING, url: STRING, visibility: STRING>, queueStatus: STRING, revision: BIGINT, type: STRING, uri: STRING, url: STRING>
repository	STRUCT<checkoutSubmodules: BOOLEAN, clean: STRING, defaultBranch: STRING, id: STRING, name: STRING, properties: MAP<STRING,STRING>, rootFolder: STRING, type: STRING, url: STRING>
requestedBy	STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>
requestedFor	STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>
buildNumberRevision	INT
retainedByRelease	BOOLEAN
lastChangedDate	TIMESTAMP
lastChangedBy	STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>
deletedDate	TIMESTAMP
deletedReason	STRING
deletedBy	STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>
project	STRUCT<abbreviation: STRING, defaultTeamImageUrl: STRING, description: STRING, id: STRING, lastUpdateTime: TIMESTAMP, name: STRING, revision: BIGINT, state: STRING, url: STRING, visibility: STRING>
triggerInfo	MAP<STRING,STRING>
parameters	STRING
templateParameters	MAP<STRING,STRING>
project_id	STRING
project_name	STRING
_links	VARIANT
agentSpecification	STRUCT<identifier: STRING>
appendCommitMessageToRunName	BOOLEAN
controller	STRUCT<_links: VARIANT, createdDate: TIMESTAMP, description: STRING, enabled: BOOLEAN, id: BIGINT, name: STRING, status: STRING, updatedDate: TIMESTAMP, uri: STRING, url: STRING>
demands	ARRAY<STRUCT<name: STRING, value: STRING>>
logs	STRUCT<id: BIGINT, type: STRING, url: STRING>
orchestrationPlan	STRUCT<orchestrationType: BIGINT, planId: STRING>
plans	ARRAY<STRUCT<orchestrationType: BIGINT, planId: STRING>>
properties	MAP<STRING,VARIANT>
quality	STRING
queue	STRUCT<_links: VARIANT, id: BIGINT, name: STRING, pool: STRUCT<id: BIGINT, isHosted: BOOLEAN, name: STRING>, url: STRING>
queueOptions	STRING
queuePosition	INT
triggeredByBuild	STRUCT<_links: VARIANT, agentSpecification: STRUCT<identifier: STRING>, appendCommitMessageToRunName: BOOLEAN, buildNumber: STRING, buildNumberRevision: BIGINT, controller: STRUCT<_links: VARIANT, createdDate: TIMESTAMP, description: STRING, enabled: BOOLEAN, id: BIGINT, name: STRING, status: STRING, updatedDate: TIMESTAMP, uri: STRING, url: STRING>, definition: STRUCT<createdDate: TIMESTAMP, id: BIGINT, name: STRING, path: STRING, project: VARIANT, queueStatus: STRING, revision: BIGINT, type: STRING, uri: STRING, url: STRING>, deleted: BOOLEAN, deletedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, deletedDate: TIMESTAMP, deletedReason: STRING, demands: ARRAY<STRUCT<name: STRING, value: STRING>>, finishTime: TIMESTAMP, id: BIGINT, lastChangedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, lastChangedDate: TIMESTAMP, logs: STRUCT<id: BIGINT, type: STRING, url: STRING>, orchestrationPlan: STRUCT<orchestrationType: BIGINT, planId: STRING>, parameters: STRING, plans: ARRAY<STRUCT<orchestrationType: BIGINT, planId: STRING>>, priority: STRING, project: STRUCT<abbreviation: STRING, defaultTeamImageUrl: STRING, description: STRING, id: STRING, lastUpdateTime: TIMESTAMP, name: STRING, revision: BIGINT, state: STRING, url: STRING, visibility: STRING>, properties: MAP<STRING,VARIANT>, quality: STRING, queue: STRUCT<_links: VARIANT, id: BIGINT, name: STRING, pool: STRUCT<id: BIGINT, isHosted: BOOLEAN, name: STRING>, url: STRING>, queueOptions: STRING, queuePosition: BIGINT, queueTime: TIMESTAMP, reason: STRING, repository: STRUCT<checkoutSubmodules: BOOLEAN, clean: STRING, defaultBranch: STRING, id: STRING, name: STRING, properties: MAP<STRING,STRING>, rootFolder: STRING, type: STRING, url: STRING>, requestedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, requestedFor: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, result: STRING, retainedByRelease: BOOLEAN, sourceBranch: STRING, sourceVersion: STRING, startTime: TIMESTAMP, status: STRING, tags: ARRAY<STRING>, templateParameters: MAP<STRING,STRING>, triggerInfo: MAP<STRING,STRING>, triggeredByBuild: VARIANT, uri: STRING, url: STRING, validationResults: ARRAY<STRUCT<message: STRING, result: STRING>>>
validationResults	ARRAY<STRUCT<message: STRING, result: STRING>>

Note

This table does not support SCD type 2 because it has VARIANT columns.

pull_requests

Primary key: pullRequestId, repository_id Sync mode: Full refresh only

Field	Data type
pullRequestId	BIGINT
codeReviewId	BIGINT
status	STRING
title	STRING
description	STRING
isDraft	BOOLEAN
supportsIterations	BOOLEAN
artifactId	STRING
mergeId	STRING
mergeStatus	STRING
creationDate	TIMESTAMP
closedDate	TIMESTAMP
completionQueueTime	TIMESTAMP
sourceRefName	STRING
targetRefName	STRING
createdBy	STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>
closedBy	STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>
reviewers	ARRAY<STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, hasDeclined: BOOLEAN, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, isFlagged: BOOLEAN, isReapprove: BOOLEAN, isRequired: BOOLEAN, profileUrl: STRING, reviewerUrl: STRING, uniqueName: STRING, url: STRING, vote: BIGINT, votedFor: ARRAY<VARIANT>>>
labels	ARRAY<STRUCT<active: BOOLEAN, id: STRING, name: STRING, url: STRING>>
workItemRefs	ARRAY<STRUCT<id: STRING, url: STRING>>
lastMergeCommit	STRUCT<_links: VARIANT, author: STRUCT<date: TIMESTAMP, email: STRING, imageUrl: STRING, name: STRING>, changeCounts: MAP<STRING,BIGINT>, changes: ARRAY<STRUCT<changeId: BIGINT, changeType: STRING, item: VARIANT, newContent: STRUCT<content: STRING, contentType: STRING>, newContentTemplate: STRUCT<name: STRING, type: STRING>, originalPath: STRING, sourceServerItem: STRING, url: STRING>>, comment: STRING, commentTruncated: BOOLEAN, commitId: STRING, commitTooManyChanges: BOOLEAN, committer: STRUCT<date: TIMESTAMP, email: STRING, imageUrl: STRING, name: STRING>, parents: ARRAY<STRING>, push: STRUCT<_links: VARIANT, date: TIMESTAMP, pushId: BIGINT, pushedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, url: STRING>, remoteUrl: STRING, statuses: ARRAY<STRUCT<_links: VARIANT, context: STRUCT<genre: STRING, name: STRING>, createdBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, creationDate: TIMESTAMP, description: STRING, id: BIGINT, state: STRING, targetUrl: STRING, updatedDate: TIMESTAMP>>, url: STRING, workItems: ARRAY<STRUCT<id: STRING, url: STRING>>>
lastMergeSourceCommit	STRUCT<_links: VARIANT, author: STRUCT<date: TIMESTAMP, email: STRING, imageUrl: STRING, name: STRING>, changeCounts: MAP<STRING,BIGINT>, changes: ARRAY<STRUCT<changeId: BIGINT, changeType: STRING, item: VARIANT, newContent: STRUCT<content: STRING, contentType: STRING>, newContentTemplate: STRUCT<name: STRING, type: STRING>, originalPath: STRING, sourceServerItem: STRING, url: STRING>>, comment: STRING, commentTruncated: BOOLEAN, commitId: STRING, commitTooManyChanges: BOOLEAN, committer: STRUCT<date: TIMESTAMP, email: STRING, imageUrl: STRING, name: STRING>, parents: ARRAY<STRING>, push: STRUCT<_links: VARIANT, date: TIMESTAMP, pushId: BIGINT, pushedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, url: STRING>, remoteUrl: STRING, statuses: ARRAY<STRUCT<_links: VARIANT, context: STRUCT<genre: STRING, name: STRING>, createdBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, creationDate: TIMESTAMP, description: STRING, id: BIGINT, state: STRING, targetUrl: STRING, updatedDate: TIMESTAMP>>, url: STRING, workItems: ARRAY<STRUCT<id: STRING, url: STRING>>>
lastMergeTargetCommit	STRUCT<_links: VARIANT, author: STRUCT<date: TIMESTAMP, email: STRING, imageUrl: STRING, name: STRING>, changeCounts: MAP<STRING,BIGINT>, changes: ARRAY<STRUCT<changeId: BIGINT, changeType: STRING, item: VARIANT, newContent: STRUCT<content: STRING, contentType: STRING>, newContentTemplate: STRUCT<name: STRING, type: STRING>, originalPath: STRING, sourceServerItem: STRING, url: STRING>>, comment: STRING, commentTruncated: BOOLEAN, commitId: STRING, commitTooManyChanges: BOOLEAN, committer: STRUCT<date: TIMESTAMP, email: STRING, imageUrl: STRING, name: STRING>, parents: ARRAY<STRING>, push: STRUCT<_links: VARIANT, date: TIMESTAMP, pushId: BIGINT, pushedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, url: STRING>, remoteUrl: STRING, statuses: ARRAY<STRUCT<_links: VARIANT, context: STRUCT<genre: STRING, name: STRING>, createdBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, creationDate: TIMESTAMP, description: STRING, id: BIGINT, state: STRING, targetUrl: STRING, updatedDate: TIMESTAMP>>, url: STRING, workItems: ARRAY<STRUCT<id: STRING, url: STRING>>>
mergeFailureType	STRING
mergeFailureMessage	STRING
hasMultipleMergeBases	BOOLEAN
autoCompleteSetBy	STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>
completionOptions	STRUCT<autoCompleteIgnoreConfigIds: ARRAY<BIGINT>, bypassPolicy: BOOLEAN, bypassReason: STRING, deleteSourceBranch: BOOLEAN, mergeCommitMessage: STRING, mergeStrategy: STRING, squashMerge: BOOLEAN, transitionWorkItems: BOOLEAN, triggeredByAutoComplete: BOOLEAN>
url	STRING
repository	STRUCT<_links: VARIANT, defaultBranch: STRING, id: STRING, isDisabled: BOOLEAN, isFork: BOOLEAN, isInMaintenance: BOOLEAN, name: STRING, parentRepository: STRUCT<collection: STRUCT<avatarUrl: STRING, id: STRING, name: STRING, url: STRING>, id: STRING, isFork: BOOLEAN, name: STRING, project: STRUCT<abbreviation: STRING, defaultTeamImageUrl: STRING, description: STRING, id: STRING, lastUpdateTime: TIMESTAMP, name: STRING, revision: BIGINT, state: STRING, url: STRING, visibility: STRING>, remoteUrl: STRING, sshUrl: STRING, url: STRING>, project: STRUCT<abbreviation: STRING, defaultTeamImageUrl: STRING, description: STRING, id: STRING, lastUpdateTime: TIMESTAMP, name: STRING, revision: BIGINT, state: STRING, url: STRING, visibility: STRING>, remoteUrl: STRING, size: BIGINT, sshUrl: STRING, url: STRING, validRemoteUrls: ARRAY<STRING>, webUrl: STRING>
repository_id	STRING
repository_name	STRING
project_id	STRING
_links	VARIANT
commits	ARRAY<STRUCT<_links: VARIANT, author: STRUCT<date: TIMESTAMP, email: STRING, imageUrl: STRING, name: STRING>, changeCounts: MAP<STRING,BIGINT>, changes: ARRAY<STRUCT<changeId: BIGINT, changeType: STRING, item: VARIANT, newContent: STRUCT<content: STRING, contentType: STRING>, newContentTemplate: STRUCT<name: STRING, type: STRING>, originalPath: STRING, sourceServerItem: STRING, url: STRING>>, comment: STRING, commentTruncated: BOOLEAN, commitId: STRING, commitTooManyChanges: BOOLEAN, committer: STRUCT<date: TIMESTAMP, email: STRING, imageUrl: STRING, name: STRING>, parents: ARRAY<STRING>, push: STRUCT<_links: VARIANT, date: TIMESTAMP, pushId: BIGINT, pushedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, url: STRING>, remoteUrl: STRING, statuses: ARRAY<STRUCT<_links: VARIANT, context: STRUCT<genre: STRING, name: STRING>, createdBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, creationDate: TIMESTAMP, description: STRING, id: BIGINT, state: STRING, targetUrl: STRING, updatedDate: TIMESTAMP>>, url: STRING, workItems: ARRAY<STRUCT<id: STRING, url: STRING>>>>
forkSource	STRUCT<_links: VARIANT, creator: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, isLocked: BOOLEAN, isLockedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, name: STRING, objectId: STRING, peeledObjectId: STRING, repository: VARIANT, statuses: ARRAY<STRUCT<_links: VARIANT, context: STRUCT<genre: STRING, name: STRING>, createdBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, creationDate: TIMESTAMP, description: STRING, id: BIGINT, state: STRING, targetUrl: STRING, updatedDate: TIMESTAMP>>, url: STRING>
mergeOptions	STRUCT<conflictAuthorshipCommits: BOOLEAN, detectRenameFalsePositives: BOOLEAN, disableRenames: BOOLEAN>
remoteUrl	STRING

Note

This table does not support SCD type 2 because it has VARIANT columns.

releases

Primary key: id, project_id Sync mode: Full refresh only

Field	Data type
id	BIGINT
name	STRING
status	STRING
reason	STRING
description	STRING
logsContainerUrl	STRING
keepForever	BOOLEAN
tags	ARRAY<STRING>
comment	STRING
releaseNameFormat	STRING
definitionSnapshotRevision	INT
releaseDefinitionRevision	INT
poolName	STRING
triggeringArtifactAlias	STRING
createdOn	TIMESTAMP
modifiedOn	TIMESTAMP
createdBy	STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>
createdFor	STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>
modifiedBy	STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>
releaseDefinition	STRUCT<_links: VARIANT, id: BIGINT, name: STRING, path: STRING, projectReference: STRUCT<id: STRING, name: STRING>, url: STRING>
projectReference	STRUCT<id: STRING, name: STRING>
project_id	STRING
project_name	STRING
_links	VARIANT
artifacts	ARRAY<STRUCT<alias: STRING, definitionReference: MAP<STRING,STRUCT<id: STRING, name: STRING>>, isPrimary: BOOLEAN, isRetained: BOOLEAN, type: STRING>>
environments	ARRAY<STRUCT<conditions: ARRAY<STRUCT<conditionType: STRING, name: STRING, result: BOOLEAN, value: STRING>>, createdOn: TIMESTAMP, definitionEnvironmentId: BIGINT, deployPhasesSnapshot: ARRAY<VARIANT>, deploySteps: ARRAY<STRUCT<attempt: BIGINT, deploymentId: BIGINT, hasStarted: BOOLEAN, id: BIGINT, issues: ARRAY<VARIANT>, lastModifiedBy: VARIANT, lastModifiedOn: TIMESTAMP, operationStatus: STRING, postDeploymentGates: VARIANT, preDeploymentGates: VARIANT, queuedOn: TIMESTAMP, reason: STRING, releaseDeployPhases: ARRAY<VARIANT>, requestedBy: VARIANT, requestedFor: VARIANT, status: STRING>>, environmentOptions: STRUCT<autoLinkWorkItems: BOOLEAN, badgeEnabled: BOOLEAN, publishDeploymentStatus: BOOLEAN, pullRequestDeploymentEnabled: BOOLEAN>, id: BIGINT, modifiedOn: TIMESTAMP, name: STRING, nextScheduledUtcTime: TIMESTAMP, owner: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, postApprovalsSnapshot: STRUCT<approvalOptions: VARIANT, approvals: ARRAY<VARIANT>>, postDeployApprovals: ARRAY<STRUCT<approvalType: STRING, approvedBy: VARIANT, approver: VARIANT, attempt: BIGINT, comments: STRING, createdOn: TIMESTAMP, history: ARRAY<VARIANT>, id: BIGINT, isAutomated: BOOLEAN, modifiedOn: TIMESTAMP, rank: BIGINT, release: VARIANT, releaseDefinition: VARIANT, releaseEnvironment: VARIANT, revision: BIGINT, status: STRING, url: STRING>>, postDeploymentGatesSnapshot: STRUCT<gates: ARRAY<VARIANT>, gatesOptions: VARIANT, id: BIGINT>, preApprovalsSnapshot: STRUCT<approvalOptions: VARIANT, approvals: ARRAY<VARIANT>>, preDeployApprovals: ARRAY<STRUCT<approvalType: STRING, approvedBy: VARIANT, approver: VARIANT, attempt: BIGINT, comments: STRING, createdOn: TIMESTAMP, history: ARRAY<VARIANT>, id: BIGINT, isAutomated: BOOLEAN, modifiedOn: TIMESTAMP, rank: BIGINT, release: VARIANT, releaseDefinition: VARIANT, releaseEnvironment: VARIANT, revision: BIGINT, status: STRING, url: STRING>>, preDeploymentGatesSnapshot: STRUCT<gates: ARRAY<VARIANT>, gatesOptions: VARIANT, id: BIGINT>, processParameters: STRUCT<dataSourceBindings: ARRAY<VARIANT>, inputs: ARRAY<VARIANT>, sourceDefinitions: ARRAY<VARIANT>>, rank: BIGINT, release: STRUCT<_links: VARIANT, id: BIGINT, name: STRING, url: STRING>, releaseCreatedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, releaseDefinition: STRUCT<_links: VARIANT, id: BIGINT, name: STRING, path: STRING, projectReference: STRUCT<id: STRING, name: STRING>, url: STRING>, releaseId: BIGINT, scheduledDeploymentTime: TIMESTAMP, schedules: ARRAY<STRUCT<daysToRelease: STRING, jobId: STRING, scheduleOnlyWithChanges: BOOLEAN, startHours: BIGINT, startMinutes: BIGINT, timeZoneId: STRING>>, status: STRING, timeToDeploy: DOUBLE, triggerReason: STRING, variableGroups: ARRAY<STRUCT<createdBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, createdOn: TIMESTAMP, description: STRING, id: BIGINT, isShared: BOOLEAN, modifiedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, modifiedOn: TIMESTAMP, name: STRING, providerData: VARIANT, type: STRING, variableGroupProjectReferences: ARRAY<STRUCT<description: STRING, name: STRING, projectReference: VARIANT>>, variables: MAP<STRING,STRUCT<isReadOnly: BOOLEAN, isSecret: BOOLEAN, value: STRING>>>>, variables: MAP<STRING,STRUCT<value: STRING, isSecret: BOOLEAN, allowOverride: BOOLEAN>>>>
properties	MAP<STRING,VARIANT>
variableGroups	ARRAY<STRUCT<createdBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, createdOn: TIMESTAMP, description: STRING, id: BIGINT, isShared: BOOLEAN, modifiedBy: STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>, modifiedOn: TIMESTAMP, name: STRING, providerData: VARIANT, type: STRING, variableGroupProjectReferences: ARRAY<STRUCT<description: STRING, name: STRING, projectReference: VARIANT>>, variables: MAP<STRING,STRUCT<isReadOnly: BOOLEAN, isSecret: BOOLEAN, value: STRING>>>>
variables	MAP<STRING,STRUCT<value: STRING, isSecret: BOOLEAN, allowOverride: BOOLEAN>>

Note

This table does not support SCD type 2 because it has VARIANT columns.

test_runs

Primary key: id, project_id Sync mode: Full refresh only

Field	Data type
id	BIGINT
name	STRING
url	STRING
webAccessUrl	STRING
isAutomated	BOOLEAN
state	STRING
phase	STRING
substate	STRING
comment	STRING
iteration	STRING
controller	STRING
tags	ARRAY<STRUCT<name: STRING>>
owner	STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>
lastUpdatedBy	STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>
build	STRUCT<id: STRING, name: STRING, url: STRING>
plan	STRUCT<id: STRING, name: STRING, url: STRING>
release	STRUCT<attempt: BIGINT, creationDate: TIMESTAMP, definitionId: BIGINT, environmentCreationDate: TIMESTAMP, environmentDefinitionId: BIGINT, environmentDefinitionName: STRING, environmentId: BIGINT, environmentName: STRING, id: BIGINT, name: STRING>
pipelineReference	STRUCT<pipelineId: BIGINT, stageReference: STRUCT<stageName: STRING, attempt: INT>, phaseReference: STRUCT<phaseName: STRING, attempt: INT>, jobReference: STRUCT<jobName: STRING, attempt: INT>>
runStatistics	ARRAY<STRUCT<count: BIGINT, outcome: STRING, resolutionState: STRUCT<id: BIGINT, name: STRING, project: VARIANT>, resultMetadata: STRING, state: STRING>>
errorMessage	STRING
dropLocation	STRING
postProcessState	STRING
releaseUri	STRING
releaseEnvironmentUri	STRING
testMessageLogId	INT
project	STRUCT<id: STRING, name: STRING, url: STRING>
buildConfiguration	STRUCT<branchName: STRING, buildDefinitionId: BIGINT, buildSystem: STRING, creationDate: TIMESTAMP, flavor: STRING, id: BIGINT, number: STRING, platform: STRING, project: STRUCT<id: STRING, name: STRING, url: STRING>, repositoryGuid: STRING, repositoryType: STRING, sourceVersion: STRING, targetBranchName: STRING, uri: STRING>
customFields	ARRAY<STRUCT<fieldName: STRING, value: VARIANT>>
filter	STRUCT<sourceFilter: STRING, testCaseFilter: STRING>
totalTests	INT
incompleteTests	INT
notApplicableTests	INT
passedTests	INT
unanalyzedTests	INT
revision	INT
project_id	STRING
project_name	STRING
completedDate	TIMESTAMP
createdDate	TIMESTAMP
dtlAutEnvironment	STRUCT<id: STRING, name: STRING, url: STRING>
dtlEnvironment	STRUCT<id: STRING, name: STRING, url: STRING>
dtlEnvironmentCreationDetails	STRUCT<csmContent: STRING, csmParameters: STRING, subscriptionName: STRING>
dueDate	TIMESTAMP
lastUpdatedDate	TIMESTAMP
startedDate	TIMESTAMP
testEnvironment	STRUCT<environmentId: STRING, environmentName: STRING>
testSettings	STRUCT<id: STRING, name: STRING, url: STRING>

Note

This table does not support SCD type 2 because it has VARIANT columns.

service_hooks_subscriptions

Primary key: id Sync mode: Full refresh only

Field	Data type
id	STRING
url	STRING
publisherId	STRING
eventType	STRING
eventDescription	STRING
consumerId	STRING
consumerActionId	STRING
actionDescription	STRING
status	STRING
resourceVersion	STRING
probationRetries	STRING
lastProbationRetryDate	TIMESTAMP
publisherInputs	MAP<STRING,STRING>
consumerInputs	MAP<STRING,STRING>
createdBy	STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>
modifiedBy	STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>
subscriber	STRUCT<_links: VARIANT, descriptor: STRING, directoryAlias: STRING, displayName: STRING, id: STRING, imageUrl: STRING, inactive: BOOLEAN, isAadIdentity: BOOLEAN, isContainer: BOOLEAN, isDeletedInOrigin: BOOLEAN, profileUrl: STRING, uniqueName: STRING, url: STRING>
createdDate	TIMESTAMP
modifiedDate	TIMESTAMP
_links	VARIANT

Note

This table does not support SCD type 2 because it has VARIANT columns.