Referência do conector do Azure DevOps

info

Beta

Esse recurso está em Beta. Para usá-lo, um administrador do workspace deve ativar o Lakeflow Connect para Azure DevOps na página Pré-visualizações . Consulte Gerenciar prévias do Databricks.

Esta página contém informações de referência para o conector do Azure DevOps gerenciado, incluindo tabelas de origem compatíveis e esquemas de tabelas de destino.

Tabelas de origem suportadas

O conector do Azure DevOps é compatível com as seguintes tabelas de origem, todas sob o esquema de origem default:

Tabela de origem	Chave primária	Descrição	Modo de sincronização	Campo de cursor
projects	id	Projetos na organização.	Apenas refresh completo
area_paths	project_id, identifier	Nós de classificação de caminho de área para cada projeto.	Apenas refresh completo
teams	id	Equipes da organização.	Apenas refresh completo
iterations	project_id, identifier	Nós de classificação de caminho de iteração para cada projeto.	Apenas refresh completo
git_repositories	id	repository do Git em cada projeto.	Apenas refresh completo
commits	commitId, repository_id	commit em cada repository Git.	Incremental	committedDate
build_definitions	id, project_id	Crie definições de pipeline em cada projeto.	Apenas refresh completo
groups	descriptor	Grupos de segurança na organização.	Apenas refresh completo
group_members	containerDescriptor, memberDescriptor	Membros diretos de cada grupo.	Apenas refresh completo
users	descriptor	Usuários na organização.	Apenas refresh completo
service_principals	descriptor	Service Principal na organização.	Apenas refresh completo
work_items	id, rev	Revisões de itens de trabalho em cada projeto, incluindo itens de trabalho excluídos.	Apenas refresh completo
builds	id, project_id	Criações em cada projeto, excluindo criações excluídas.	Apenas refresh completo
pull_requests	pullRequestId, repository_id	Pull requests em cada repository Git, em qualquer status.	Apenas refresh completo
releases	id, project_id	Versões clássicas em cada projeto, excluindo versões excluídas.	Apenas refresh completo
test_runs	id, project_id	Execuções de teste em cada projeto.	Apenas refresh completo
service_hooks_subscriptions	id	Inscrições de gancho de serviço na organização.	Apenas refresh completo

Tabela de origem	Chave primária	Descrição	Modo de sincronização	Campo de cursor
projects	id	Projetos na organização.	Apenas refresh completo
area_paths	project_id, identifier	Nós de classificação de caminho de área para cada projeto.	Apenas refresh completo
teams	id	Equipes da organização.	Apenas refresh completo
iterations	project_id, identifier	Nós de classificação de caminho de iteração para cada projeto.	Apenas refresh completo
git_repositories	id	repository do Git em cada projeto.	Apenas refresh completo
commits	commitId, repository_id	commit em cada repository Git.	Incremental	committedDate
build_definitions	id, project_id	Crie definições de pipeline em cada projeto.	Apenas refresh completo
groups	descriptor	Grupos de segurança na organização.	Apenas refresh completo
group_members	containerDescriptor, memberDescriptor	Membros diretos de cada grupo.	Apenas refresh completo
users	descriptor	Usuários na organização.	Apenas refresh completo
service_principals	descriptor	Service Principal na organização.	Apenas refresh completo
work_items	id, rev	Revisões de itens de trabalho em cada projeto, incluindo itens de trabalho excluídos.	Apenas refresh completo
builds	id, project_id	Criações em cada projeto, excluindo criações excluídas.	Apenas refresh completo
pull_requests	pullRequestId, repository_id	Pull requests em cada repository Git, em qualquer status.	Apenas refresh completo
releases	id, project_id	Versões clássicas em cada projeto, excluindo versões excluídas.	Apenas refresh completo
test_runs	id, project_id	Execuções de teste em cada projeto.	Apenas refresh completo
service_hooks_subscriptions	id	Inscrições de gancho de serviço na organização.	Apenas refresh completo

Opções de conector

Para ver o uso, consulte Exemplos.

Opção	Tipo	Escopo	Obrigatório	Aplica-se a	Descrição
start_datetime	String	Pipeline	Não	commits	Data de commit mais antiga para ingerir na primeira sincronização, em formato yyyy-MM-dd'T'HH:mm:ss'Z'. O default é 180 dias antes da sincronização.

Opção	Tipo	Escopo	Obrigatório	Aplica-se a	Descrição
start_datetime	String	Pipeline	Não	commits	Data de commit mais antiga para ingerir na primeira sincronização, em formato yyyy-MM-dd'T'HH:mm:ss'Z'. O default é 180 dias antes da sincronização.

Esquemas de tabela de destino

projects

Chave key: id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
id	STRING
name	STRING
abbreviation	STRING
description	STRING
url	STRING
state	STRING
revision	BIGINT
visibility	STRING
lastUpdateTime	TIMESTAMP
defaultTeamImageUrl	STRING

campo	Tipo de dados
id	STRING
name	STRING
abbreviation	STRING
description	STRING
url	STRING
state	STRING
revision	BIGINT
visibility	STRING
lastUpdateTime	TIMESTAMP
defaultTeamImageUrl	STRING

area_paths

Chave key: project_id, identifier Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
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>

campo	Tipo de dados
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>

nota

Esta tabela não suporta SCD tipo 2 porque possui colunas VARIANT.

teams

Chave key: id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
id	STRING
name	STRING
description	STRING
url	STRING
identityUrl	STRING
projectName	STRING
projectId	STRING
identity	VARIANT

campo	Tipo de dados
id	STRING
name	STRING
description	STRING
url	STRING
identityUrl	STRING
projectName	STRING
projectId	STRING
identity	VARIANT

nota

Esta tabela não suporta SCD tipo 2 porque possui colunas VARIANT.

iterations

Chave key: project_id, identifier Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
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>

campo	Tipo de dados
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>

nota

Esta tabela não suporta SCD tipo 2 porque possui colunas VARIANT.

git_repositories

Chave key: id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
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

campo	Tipo de dados
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

nota

Esta tabela não suporta SCD tipo 2 porque possui colunas VARIANT.

commits

Chave key: commitId, repository_id Campo de cursor: committedDate

campo	Tipo de dados
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>>

campo	Tipo de dados
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>>

nota

Esta tabela não suporta SCD tipo 2 porque possui colunas VARIANT.

build_definitions

Chave key: id, project_id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
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>>

campo	Tipo de dados
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>>

nota

Esta tabela não suporta SCD tipo 2 porque possui colunas VARIANT.

groups

Chave key: descriptor Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
descriptor	STRING
displayName	STRING
description	STRING
principalName	STRING
mailAddress	STRING
domain	STRING
subjectKind	STRING
origin	STRING
originId	STRING
url	STRING
_links	VARIANT
legacyDescriptor	STRING

campo	Tipo de dados
descriptor	STRING
displayName	STRING
description	STRING
principalName	STRING
mailAddress	STRING
domain	STRING
subjectKind	STRING
origin	STRING
originId	STRING
url	STRING
_links	VARIANT
legacyDescriptor	STRING

nota

Esta tabela não suporta SCD tipo 2 porque possui colunas VARIANT.

group_members

Chave key: containerDescriptor, memberDescriptor Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
containerDescriptor	STRING
memberDescriptor	STRING
_links	VARIANT
group_display_name	STRING

campo	Tipo de dados
containerDescriptor	STRING
memberDescriptor	STRING
_links	VARIANT
group_display_name	STRING

nota

Esta tabela não suporta SCD tipo 2 porque possui colunas VARIANT.

users

Chave key: descriptor Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
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

campo	Tipo de dados
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

nota

Esta tabela não suporta SCD tipo 2 porque possui colunas VARIANT.

service_principals

Chave key: descriptor Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
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

campo	Tipo de dados
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

nota

Esta tabela não suporta SCD tipo 2 porque possui colunas VARIANT.

work_items

Chave key: id, rev Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
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>>

campo	Tipo de dados
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>>

nota

Esta tabela não suporta SCD tipo 2 porque possui colunas VARIANT.

builds

Chave key: id, project_id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
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>>

campo	Tipo de dados
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>>

nota

Esta tabela não suporta SCD tipo 2 porque possui colunas VARIANT.

pull_requests

Chave key: pullRequestId, repository_id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
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

campo	Tipo de dados
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

nota

Esta tabela não suporta SCD tipo 2 porque possui colunas VARIANT.

releases

Chave key: id, project_id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
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>>

campo	Tipo de dados
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>>

nota

Esta tabela não suporta SCD tipo 2 porque possui colunas VARIANT.

test_runs

Chave key: id, project_id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
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>

campo	Tipo de dados
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>

nota

Esta tabela não suporta SCD tipo 2 porque possui colunas VARIANT.

service_hooks_subscriptions

Chave key: id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
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

campo	Tipo de dados
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

nota

Esta tabela não suporta SCD tipo 2 porque possui colunas VARIANT.