Référence du connecteur Azure DevOps

info

Bêta

Cette fonctionnalité est en version bêta. Pour l’utiliser, un administrateur de workspace doit activer Lakeflow Connect for Azure DevOps à partir de la page Previews . Consultez Gérer les aperçus Databricks.

Cette page contient des informations de référence sur le connecteur Azure DevOps managé, notamment les tables sources prises en charge et les schémas de table de destination.

Tables sources prises en charge

Le connecteur Azure DevOps prend en charge les tables sources suivantes, toutes sous le schéma source default :

Table source	Clé primaire	Description	Mode de synchronisation	Champ de curseur
projects	id	Projets dans l’organisation.	refresh complète uniquement
area_paths	project_id, identifier	Nœuds de classification des chemins de zone pour chaque projet.	refresh complète uniquement
teams	id	Équipes de l’organisation.	refresh complète uniquement
iterations	project_id, identifier	Nœuds de classification de chemin d'itération pour chaque projet.	refresh complète uniquement
git_repositories	id	repository Git dans chaque projet.	refresh complète uniquement
commits	commitId, repository_id	Commits dans chaque repository Git.	Incrémentiel	committedDate
build_definitions	id, project_id	Créez des définitions de pipeline dans chaque projet.	refresh complète uniquement
groups	descriptor	Groupes de sécurité dans l'organisation.	refresh complète uniquement
group_members	containerDescriptor, memberDescriptor	Membres directs de chaque groupe.	refresh complète uniquement
users	descriptor	Utilisateurs de l'organisation.	refresh complète uniquement
service_principals	descriptor	Service Principal dans l’organisation.	refresh complète uniquement
work_items	id, rev	Révisions d'élément de travail dans chaque projet, y compris les éléments de travail supprimés.	refresh complète uniquement
builds	id, project_id	Builds de chaque projet, à l'exclusion des builds supprimés.	refresh complète uniquement
pull_requests	pullRequestId, repository_id	Demandes de tirage (pull requests) dans chaque repository Git, dans n’importe quel état.	refresh complète uniquement
releases	id, project_id	Versions classiques dans chaque projet, à l’exclusion des versions supprimées.	refresh complète uniquement
test_runs	id, project_id	Exécutions de tests dans chaque projet.	refresh complète uniquement
service_hooks_subscriptions	id	Abonnements aux hooks de service dans l’organisation.	refresh complète uniquement

Table source	Clé primaire	Description	Mode de synchronisation	Champ de curseur
projects	id	Projets dans l’organisation.	refresh complète uniquement
area_paths	project_id, identifier	Nœuds de classification des chemins de zone pour chaque projet.	refresh complète uniquement
teams	id	Équipes de l’organisation.	refresh complète uniquement
iterations	project_id, identifier	Nœuds de classification de chemin d'itération pour chaque projet.	refresh complète uniquement
git_repositories	id	repository Git dans chaque projet.	refresh complète uniquement
commits	commitId, repository_id	Commits dans chaque repository Git.	Incrémentiel	committedDate
build_definitions	id, project_id	Créez des définitions de pipeline dans chaque projet.	refresh complète uniquement
groups	descriptor	Groupes de sécurité dans l'organisation.	refresh complète uniquement
group_members	containerDescriptor, memberDescriptor	Membres directs de chaque groupe.	refresh complète uniquement
users	descriptor	Utilisateurs de l'organisation.	refresh complète uniquement
service_principals	descriptor	Service Principal dans l’organisation.	refresh complète uniquement
work_items	id, rev	Révisions d'élément de travail dans chaque projet, y compris les éléments de travail supprimés.	refresh complète uniquement
builds	id, project_id	Builds de chaque projet, à l'exclusion des builds supprimés.	refresh complète uniquement
pull_requests	pullRequestId, repository_id	Demandes de tirage (pull requests) dans chaque repository Git, dans n’importe quel état.	refresh complète uniquement
releases	id, project_id	Versions classiques dans chaque projet, à l’exclusion des versions supprimées.	refresh complète uniquement
test_runs	id, project_id	Exécutions de tests dans chaque projet.	refresh complète uniquement
service_hooks_subscriptions	id	Abonnements aux hooks de service dans l’organisation.	refresh complète uniquement

Options de connecteur

Pour l’utilisation, voir Exemples.

Option	Type	Portée	Obligatoire	S’applique à	Description
start_datetime	Chaîne	Pipeline	Non	commits	Date de commit la plus ancienne à importer lors de la première synchronisation, au format yyyy-MM-dd'T'HH:mm:ss'Z'. default, 180 jours avant la synchronisation.

Option	Type	Portée	Obligatoire	S’applique à	Description
start_datetime	Chaîne	Pipeline	Non	commits	Date de commit la plus ancienne à importer lors de la première synchronisation, au format yyyy-MM-dd'T'HH:mm:ss'Z'. default, 180 jours avant la synchronisation.

Schémas des tables de destination

projects

Clé principale : id Mode de synchronisation : refresh complète uniquement

Champ	Type de données
id	STRING
name	STRING
abbreviation	STRING
description	STRING
url	STRING
state	STRING
revision	BIGINT
visibility	STRING
lastUpdateTime	TIMESTAMP
defaultTeamImageUrl	STRING

Champ	Type de données
id	STRING
name	STRING
abbreviation	STRING
description	STRING
url	STRING
state	STRING
revision	BIGINT
visibility	STRING
lastUpdateTime	TIMESTAMP
defaultTeamImageUrl	STRING

area_paths

Clé principale : project_id, identifier Mode de synchronisation : refresh complète uniquement

Champ	Type de données
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>

Champ	Type de données
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>

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

teams

Clé principale : id Mode de synchronisation : refresh complète uniquement

Champ	Type de données
id	STRING
name	STRING
description	STRING
url	STRING
identityUrl	STRING
projectName	STRING
projectId	STRING
identity	VARIANT

Champ	Type de données
id	STRING
name	STRING
description	STRING
url	STRING
identityUrl	STRING
projectName	STRING
projectId	STRING
identity	VARIANT

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

iterations

Clé principale : project_id, identifier Mode de synchronisation : refresh complète uniquement

Champ	Type de données
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>

Champ	Type de données
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>

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

git_repositories

Clé principale : id Mode de synchronisation : refresh complète uniquement

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

commits

Clé principale : commitId, repository_id Champ de curseur : committedDate

Champ	Type de données
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>>

Champ	Type de données
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>>

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

build_definitions

Clé principale : id, project_id Mode de synchronisation : refresh complète uniquement

Champ	Type de données
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>>

Champ	Type de données
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>>

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

groups

Clé principale : descriptor Mode de synchronisation : refresh complète uniquement

Champ	Type de données
descriptor	STRING
displayName	STRING
description	STRING
principalName	STRING
mailAddress	STRING
domain	STRING
subjectKind	STRING
origin	STRING
originId	STRING
url	STRING
_links	VARIANT
legacyDescriptor	STRING

Champ	Type de données
descriptor	STRING
displayName	STRING
description	STRING
principalName	STRING
mailAddress	STRING
domain	STRING
subjectKind	STRING
origin	STRING
originId	STRING
url	STRING
_links	VARIANT
legacyDescriptor	STRING

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

group_members

Clé principale : containerDescriptor, memberDescriptor Mode de synchronisation : refresh complète uniquement

Champ	Type de données
containerDescriptor	STRING
memberDescriptor	STRING
_links	VARIANT
group_display_name	STRING

Champ	Type de données
containerDescriptor	STRING
memberDescriptor	STRING
_links	VARIANT
group_display_name	STRING

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

users

Clé principale : descriptor Mode de synchronisation : refresh complète uniquement

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

service_principals

Clé principale : descriptor Mode de synchronisation : refresh complète uniquement

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

work_items

Clé principale : id, rev Mode de synchronisation : refresh complète uniquement

Champ	Type de données
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>>

Champ	Type de données
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>>

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

builds

Clé principale : id, project_id Mode de synchronisation : refresh complète uniquement

Champ	Type de données
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>>

Champ	Type de données
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>>

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

pull_requests

Clé principale : pullRequestId, repository_id Mode de synchronisation : refresh complète uniquement

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

releases

Clé principale : id, project_id Mode de synchronisation : refresh complète uniquement

Champ	Type de données
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>>

Champ	Type de données
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>>

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

test_runs

Clé principale : id, project_id Mode de synchronisation : refresh complète uniquement

Champ	Type de données
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>

Champ	Type de données
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>

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.

service_hooks_subscriptions

Clé principale : id Mode de synchronisation : refresh complète uniquement

Champ	Type de données
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

Champ	Type de données
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

remarque

Cette table ne prend pas en charge le SCD de type 2 car elle contient des colonnes VARIANT.