Azure DevOps コネクタのリファレンス

備考

ベータ版

この機能はプレビュー版です。使用するには、ワークスペース管理者は プレビュー ページから Azure DevOps向けLakeflow Connect を有効にする必要があります。Databricksのプレビューを管理するを参照してください。

このページには、サポートされているソーステーブルや宛先テーブルのスキーマなど、マネージドAzure DevOpsコネクターに関するリファレンス情報が記載されています。

サポートされているソーステーブル

Azure DevOpsコネクタは、default ソース スキーマの下にある以下のソース テーブルをサポートしています。

ソーステーブル	プライマリーキー	説明	同期モード	カーソルフィールド
projects	id	組織内のプロジェクト。	フル更新のみ
area_paths	project_id, identifier	プロジェクトごとのパス分類ノード。	フル更新のみ
teams	id	組織内のチーム。	フル更新のみ
iterations	project_id, identifier	各プロジェクトの反復パス分類ノード。	フル更新のみ
git_repositories	id	各プロジェクトのGitリポジトリ。	フル更新のみ
commits	commitId, repository_id	各Gitリポジトリのcommit。	インクリメンタル	committedDate
build_definitions	id, project_id	各プロジェクトでパイプライン定義を作成します。	フル更新のみ
groups	descriptor	組織内のセキュリティグループ。	フル更新のみ
group_members	containerDescriptor, memberDescriptor	各グループの直接メンバー。	フル更新のみ
users	descriptor	組織内のユーザー。	フル更新のみ
service_principals	descriptor	組織内のService Principal。	フル更新のみ
work_items	id, rev	削除された作業項目を含む、各プロジェクトの作業項目のリビジョン。	フル更新のみ
builds	id, project_id	削除されたビルドを除く、各プロジェクトでのビルド。	フル更新のみ
pull_requests	pullRequestId, repository_id	各 Git リポジトリのプルリクエスト（ステータスは問いません）。	フル更新のみ
releases	id, project_id	削除されたリリースを除く、各プロジェクトの従来のリリース。	フル更新のみ
test_runs	id, project_id	各プロジェクトのテストラン。	フル更新のみ
service_hooks_subscriptions	id	組織内のサービスフックサブスクリプション。	フル更新のみ

ソーステーブル	プライマリーキー	説明	同期モード	カーソルフィールド
projects	id	組織内のプロジェクト。	フル更新のみ
area_paths	project_id, identifier	プロジェクトごとのパス分類ノード。	フル更新のみ
teams	id	組織内のチーム。	フル更新のみ
iterations	project_id, identifier	各プロジェクトの反復パス分類ノード。	フル更新のみ
git_repositories	id	各プロジェクトのGitリポジトリ。	フル更新のみ
commits	commitId, repository_id	各Gitリポジトリのcommit。	インクリメンタル	committedDate
build_definitions	id, project_id	各プロジェクトでパイプライン定義を作成します。	フル更新のみ
groups	descriptor	組織内のセキュリティグループ。	フル更新のみ
group_members	containerDescriptor, memberDescriptor	各グループの直接メンバー。	フル更新のみ
users	descriptor	組織内のユーザー。	フル更新のみ
service_principals	descriptor	組織内のService Principal。	フル更新のみ
work_items	id, rev	削除された作業項目を含む、各プロジェクトの作業項目のリビジョン。	フル更新のみ
builds	id, project_id	削除されたビルドを除く、各プロジェクトでのビルド。	フル更新のみ
pull_requests	pullRequestId, repository_id	各 Git リポジトリのプルリクエスト（ステータスは問いません）。	フル更新のみ
releases	id, project_id	削除されたリリースを除く、各プロジェクトの従来のリリース。	フル更新のみ
test_runs	id, project_id	各プロジェクトのテストラン。	フル更新のみ
service_hooks_subscriptions	id	組織内のサービスフックサブスクリプション。	フル更新のみ

コネクタのオプション

使用方法については、例を参照してください。

オプション	Type	スコープ	必須	適用先	説明
start_datetime	String	パイプライン	No	commits	初回同期に取り込む最も早いcommitの日付（yyyy-MM-dd'T'HH:mm:ss'Z'形式）。defaultは同期の180日前です。

オプション	Type	スコープ	必須	適用先	説明
start_datetime	String	パイプライン	No	commits	初回同期に取り込む最も早いcommitの日付（yyyy-MM-dd'T'HH:mm:ss'Z'形式）。defaultは同期の180日前です。

送信先テーブルのスキーマ

projects

主キー: id 同期モード: 全更新のみ

フィールド	データ型
id	STRING
name	STRING
abbreviation	STRING
description	STRING
url	STRING
state	STRING
revision	BIGINT
visibility	STRING
lastUpdateTime	TIMESTAMP
defaultTeamImageUrl	STRING

フィールド	データ型
id	STRING
name	STRING
abbreviation	STRING
description	STRING
url	STRING
state	STRING
revision	BIGINT
visibility	STRING
lastUpdateTime	TIMESTAMP
defaultTeamImageUrl	STRING

area_paths

主キー: project_id, identifier 同期モード: 全更新のみ

フィールド	データ型
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>

フィールド	データ型
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>

注記

このテーブルにはVARIANT列があるため、SCDタイプ2はサポートされていません。

teams

主キー: id 同期モード: 全更新のみ

フィールド	データ型
id	STRING
name	STRING
description	STRING
url	STRING
identityUrl	STRING
projectName	STRING
projectId	STRING
identity	VARIANT

フィールド	データ型
id	STRING
name	STRING
description	STRING
url	STRING
identityUrl	STRING
projectName	STRING
projectId	STRING
identity	VARIANT

注記

このテーブルにはVARIANT列があるため、SCDタイプ2はサポートされていません。

iterations

主キー: project_id, identifier 同期モード: 全更新のみ

フィールド	データ型
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>

フィールド	データ型
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>

注記

このテーブルにはVARIANT列があるため、SCDタイプ2はサポートされていません。

git_repositories

主キー: id 同期モード: 全更新のみ

フィールド	データ型
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

フィールド	データ型
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

注記

このテーブルにはVARIANT列があるため、SCDタイプ2はサポートされていません。

commits

主キー： commitId, repository_id カーソルフィールド： committedDate

フィールド	データ型
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>>

フィールド	データ型
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>>

注記

このテーブルにはVARIANT列があるため、SCDタイプ2はサポートされていません。

build_definitions

主キー: id, project_id 同期モード: 全更新のみ

フィールド	データ型
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>>

フィールド	データ型
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>>

注記

このテーブルにはVARIANT列があるため、SCDタイプ2はサポートされていません。

groups

主キー: descriptor 同期モード: 全更新のみ

フィールド	データ型
descriptor	STRING
displayName	STRING
description	STRING
principalName	STRING
mailAddress	STRING
domain	STRING
subjectKind	STRING
origin	STRING
originId	STRING
url	STRING
_links	VARIANT
legacyDescriptor	STRING

フィールド	データ型
descriptor	STRING
displayName	STRING
description	STRING
principalName	STRING
mailAddress	STRING
domain	STRING
subjectKind	STRING
origin	STRING
originId	STRING
url	STRING
_links	VARIANT
legacyDescriptor	STRING

注記

このテーブルにはVARIANT列があるため、SCDタイプ2はサポートされていません。

group_members

主キー: containerDescriptor, memberDescriptor 同期モード: 全更新のみ

フィールド	データ型
containerDescriptor	STRING
memberDescriptor	STRING
_links	VARIANT
group_display_name	STRING

フィールド	データ型
containerDescriptor	STRING
memberDescriptor	STRING
_links	VARIANT
group_display_name	STRING

注記

このテーブルにはVARIANT列があるため、SCDタイプ2はサポートされていません。

users

主キー: descriptor 同期モード: 全更新のみ

フィールド	データ型
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

フィールド	データ型
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

注記

このテーブルにはVARIANT列があるため、SCDタイプ2はサポートされていません。

service_principals

主キー: descriptor 同期モード: 全更新のみ

フィールド	データ型
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

フィールド	データ型
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

注記

このテーブルにはVARIANT列があるため、SCDタイプ2はサポートされていません。

work_items

主キー: id, rev 同期モード: 全更新のみ

フィールド	データ型
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>>

フィールド	データ型
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>>

注記

このテーブルにはVARIANT列があるため、SCDタイプ2はサポートされていません。

builds

主キー: id, project_id 同期モード: 全更新のみ

フィールド	データ型
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>>

フィールド	データ型
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>>

注記

このテーブルにはVARIANT列があるため、SCDタイプ2はサポートされていません。

pull_requests

主キー: pullRequestId, repository_id 同期モード: 全更新のみ

フィールド	データ型
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

フィールド	データ型
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

注記

このテーブルにはVARIANT列があるため、SCDタイプ2はサポートされていません。

releases

主キー: id, project_id 同期モード: 全更新のみ

フィールド	データ型
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>>

フィールド	データ型
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>>

注記

このテーブルにはVARIANT列があるため、SCDタイプ2はサポートされていません。

test_runs

主キー: id, project_id 同期モード: 全更新のみ

フィールド	データ型
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>

フィールド	データ型
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>

注記

このテーブルにはVARIANT列があるため、SCDタイプ2はサポートされていません。

service_hooks_subscriptions

主キー: id 同期モード: 全更新のみ

フィールド	データ型
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

フィールド	データ型
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

注記

このテーブルにはVARIANT列があるため、SCDタイプ2はサポートされていません。