Referência do conector do GitLab

info

Beta

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

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

Tabelas de origem compatíveis

O conector do GitLab oferece suporte às seguintes tabelas de origem, todas sob o esquema de origem default:

Tabela de origem	Chave primária	Descrição	Modo de sincronização	Campo de cursor
groups	id	Grupos do GitLab dos quais o usuário autenticado é membro.	Apenas refresh completo
projects	id	Projetos do GitLab dos quais o usuário autenticado é membro.	Apenas refresh completo
issues	id	Problemas em todos os projetos de membros.	Incremental	updated_at
merge_requests	id	Merge requests nos projetos de membros.	Incremental	updated_at
commits	id	commit de repository para cada projeto de membro.	Incremental	created_at
pipelines	id	Pipelines de CI/CD para cada projeto.	Incremental	updated_at
project_members	project_id, id	Membros de cada projeto.	Apenas refresh completo
branches	project_id, name	Branch de repository para cada projeto.	Apenas refresh completo
tags	project_id, name	Tags de repository para cada projeto.	Apenas refresh completo
releases	project_id, tag_name	Versões para cada projeto.	Apenas refresh completo
deployments	id	Implantações para cada projeto.	Incremental	updated_at
jobs	id	Jobs de CI/CD para cada pipeline.	Apenas refresh completo
project_labels	project_id, id	Rótulos definidos em cada projeto.	Apenas refresh completo
project_milestones	id	Marcos para cada projeto.	Incremental	updated_at
users	project_id, id	Usuários com acesso a cada projeto.	Apenas refresh completo
group_labels	group_id, id	Rótulos definidos em cada grupo.	Apenas refresh completo
group_milestones	id	Marcos para cada grupo.	Incremental	updated_at
group_members	group_id, id	Membros de cada grupo.	Apenas refresh completo
group_issue_boards	group_id, id	Quadros de itens para cada grupo.	Apenas refresh completo
epics	id	Épicos para cada grupo. Requer um grupo GitLab Premium ou Ultimate.	Incremental	updated_at
merge_request_commits	project_id, merge_request_iid, id	commit em cada solicitação de merge.	Apenas refresh completo
epic_issues	group_id, epic_iid, epic_issue_id	Problemas vinculados a cada épico. Requer um grupo do GitLab Premium ou Ultimate.	Apenas refresh completo
pipelines_extended	project_id, id	Detalhes estendidos de cada pipeline.	Apenas refresh completo
group_iterations	group_id, id	Iterações para cada grupo. Requer um grupo GitLab Premium ou Ultimate.	Incremental	updated_at
epic_boards	group_id, id	Quadros de épicos para cada grupo. Requer um grupo GitLab Premium ou Ultimate.	Apenas refresh completo
merge_request_discussions	project_id, merge_request_iid, id	Threads de discussão em cada merge request.	Apenas refresh completo
vulnerabilities	project_id, id	Vulnerabilidades de segurança para cada projeto. Requer um projeto do GitLab Ultimate.	Apenas refresh completo
compliance_frameworks	group_id, id	Estruturas de compliance para cada grupo. Requer um grupo do GitLab Ultimate.	Apenas refresh completo

Tabela de origem	Chave primária	Descrição	Modo de sincronização	Campo de cursor
groups	id	Grupos do GitLab dos quais o usuário autenticado é membro.	Apenas refresh completo
projects	id	Projetos do GitLab dos quais o usuário autenticado é membro.	Apenas refresh completo
issues	id	Problemas em todos os projetos de membros.	Incremental	updated_at
merge_requests	id	Merge requests nos projetos de membros.	Incremental	updated_at
commits	id	commit de repository para cada projeto de membro.	Incremental	created_at
pipelines	id	Pipelines de CI/CD para cada projeto.	Incremental	updated_at
project_members	project_id, id	Membros de cada projeto.	Apenas refresh completo
branches	project_id, name	Branch de repository para cada projeto.	Apenas refresh completo
tags	project_id, name	Tags de repository para cada projeto.	Apenas refresh completo
releases	project_id, tag_name	Versões para cada projeto.	Apenas refresh completo
deployments	id	Implantações para cada projeto.	Incremental	updated_at
jobs	id	Jobs de CI/CD para cada pipeline.	Apenas refresh completo
project_labels	project_id, id	Rótulos definidos em cada projeto.	Apenas refresh completo
project_milestones	id	Marcos para cada projeto.	Incremental	updated_at
users	project_id, id	Usuários com acesso a cada projeto.	Apenas refresh completo
group_labels	group_id, id	Rótulos definidos em cada grupo.	Apenas refresh completo
group_milestones	id	Marcos para cada grupo.	Incremental	updated_at
group_members	group_id, id	Membros de cada grupo.	Apenas refresh completo
group_issue_boards	group_id, id	Quadros de itens para cada grupo.	Apenas refresh completo
epics	id	Épicos para cada grupo. Requer um grupo GitLab Premium ou Ultimate.	Incremental	updated_at
merge_request_commits	project_id, merge_request_iid, id	commit em cada solicitação de merge.	Apenas refresh completo
epic_issues	group_id, epic_iid, epic_issue_id	Problemas vinculados a cada épico. Requer um grupo do GitLab Premium ou Ultimate.	Apenas refresh completo
pipelines_extended	project_id, id	Detalhes estendidos de cada pipeline.	Apenas refresh completo
group_iterations	group_id, id	Iterações para cada grupo. Requer um grupo GitLab Premium ou Ultimate.	Incremental	updated_at
epic_boards	group_id, id	Quadros de épicos para cada grupo. Requer um grupo GitLab Premium ou Ultimate.	Apenas refresh completo
merge_request_discussions	project_id, merge_request_iid, id	Threads de discussão em cada merge request.	Apenas refresh completo
vulnerabilities	project_id, id	Vulnerabilidades de segurança para cada projeto. Requer um projeto do GitLab Ultimate.	Apenas refresh completo
compliance_frameworks	group_id, id	Estruturas de compliance para cada grupo. Requer um grupo do GitLab Ultimate.	Apenas refresh completo

Opções do conector

Para ver o uso, consulte Exemplos.

Opção	Tipo	Escopo	Obrigatório	Aplica-se a	Descrição
start_datetime	string	Pipeline	Não	Todas as tabelas incrementais	O timestamp do registro mais antigo a ser ingerido na primeira sincronização, no formato yyyy-MM-dd'T'HH:mm:ss.SSS'Z'. default é 2018-01-01T00:00:00.000Z.

Opção	Tipo	Escopo	Obrigatório	Aplica-se a	Descrição
start_datetime	string	Pipeline	Não	Todas as tabelas incrementais	O timestamp do registro mais antigo a ser ingerido na primeira sincronização, no formato yyyy-MM-dd'T'HH:mm:ss.SSS'Z'. default é 2018-01-01T00:00:00.000Z.

Esquemas de tabela de destino

groups

Chave primária: id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
id	BIGINT
name	STRING
path	STRING
full_path	STRING
full_name	STRING
description	STRING
visibility	STRING
web_url	STRING
parent_id	BIGINT
created_at	TIMESTAMP

campo	Tipo de dados
id	BIGINT
name	STRING
path	STRING
full_path	STRING
full_name	STRING
description	STRING
visibility	STRING
web_url	STRING
parent_id	BIGINT
created_at	TIMESTAMP

projects

Chave primária: id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
id	BIGINT
name	STRING
name_with_namespace	STRING
path_with_namespace	STRING
description	STRING
visibility	STRING
web_url	STRING
default_branch	STRING
archived	BOOLEAN
topics	ARRAY<STRING>
namespace	STRUCT<id: BIGINT, name: STRING, path: STRING, kind: STRING, full_path: STRING, parent_id: BIGINT, avatar_url: STRING, web_url: STRING>
created_at	TIMESTAMP
updated_at	TIMESTAMP
last_activity_at	TIMESTAMP

campo	Tipo de dados
id	BIGINT
name	STRING
name_with_namespace	STRING
path_with_namespace	STRING
description	STRING
visibility	STRING
web_url	STRING
default_branch	STRING
archived	BOOLEAN
topics	ARRAY<STRING>
namespace	STRUCT<id: BIGINT, name: STRING, path: STRING, kind: STRING, full_path: STRING, parent_id: BIGINT, avatar_url: STRING, web_url: STRING>
created_at	TIMESTAMP
updated_at	TIMESTAMP
last_activity_at	TIMESTAMP

issues

Chave key: id Campo de cursor: updated_at

campo	Tipo de dados
id	BIGINT
iid	BIGINT
project_id	BIGINT
title	STRING
description	STRING
state	STRING
author	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
assignees	ARRAY<STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>>
labels	ARRAY<STRING>
milestone	STRUCT<id: BIGINT, iid: BIGINT, project_id: BIGINT, group_id: BIGINT, title: STRING, description: STRING, state: STRING, created_at: TIMESTAMP, updated_at: TIMESTAMP, due_date: DATE, start_date: DATE, expired: BOOLEAN, web_url: STRING>
web_url	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
closed_at	TIMESTAMP

campo	Tipo de dados
id	BIGINT
iid	BIGINT
project_id	BIGINT
title	STRING
description	STRING
state	STRING
author	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
assignees	ARRAY<STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>>
labels	ARRAY<STRING>
milestone	STRUCT<id: BIGINT, iid: BIGINT, project_id: BIGINT, group_id: BIGINT, title: STRING, description: STRING, state: STRING, created_at: TIMESTAMP, updated_at: TIMESTAMP, due_date: DATE, start_date: DATE, expired: BOOLEAN, web_url: STRING>
web_url	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
closed_at	TIMESTAMP

merge_requests

Chave key: id Campo de cursor: updated_at

campo	Tipo de dados
id	BIGINT
iid	BIGINT
project_id	BIGINT
title	STRING
description	STRING
state	STRING
merge_status	STRING
detailed_merge_status	STRING
author	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
assignees	ARRAY<STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>>
reviewers	ARRAY<STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>>
source_branch	STRING
target_branch	STRING
sha	STRING
merge_commit_sha	STRING
labels	ARRAY<STRING>
web_url	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
merged_at	TIMESTAMP
closed_at	TIMESTAMP

campo	Tipo de dados
id	BIGINT
iid	BIGINT
project_id	BIGINT
title	STRING
description	STRING
state	STRING
merge_status	STRING
detailed_merge_status	STRING
author	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
assignees	ARRAY<STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>>
reviewers	ARRAY<STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>>
source_branch	STRING
target_branch	STRING
sha	STRING
merge_commit_sha	STRING
labels	ARRAY<STRING>
web_url	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
merged_at	TIMESTAMP
closed_at	TIMESTAMP

commits

Chave key: id Campo de cursor: created_at

campo	Tipo de dados
id	STRING
short_id	STRING
project_id	BIGINT
title	STRING
message	STRING
author_name	STRING
author_email	STRING
authored_date	TIMESTAMP
committer_name	STRING
committer_email	STRING
committed_date	TIMESTAMP
created_at	TIMESTAMP
web_url	STRING
parent_ids	ARRAY<STRING>
stats	STRUCT<additions: BIGINT, deletions: BIGINT, total: BIGINT>
trailers	VARIANT
extended_trailers	VARIANT

campo	Tipo de dados
id	STRING
short_id	STRING
project_id	BIGINT
title	STRING
message	STRING
author_name	STRING
author_email	STRING
authored_date	TIMESTAMP
committer_name	STRING
committer_email	STRING
committed_date	TIMESTAMP
created_at	TIMESTAMP
web_url	STRING
parent_ids	ARRAY<STRING>
stats	STRUCT<additions: BIGINT, deletions: BIGINT, total: BIGINT>
trailers	VARIANT
extended_trailers	VARIANT

nota

Esta tabela não é compatível com o SCD tipo 2 porque possui colunas VARIANT.

pipelines

Chave key: id Campo de cursor: updated_at

campo	Tipo de dados
id	BIGINT
iid	BIGINT
project_id	BIGINT
sha	STRING
ref	STRING
status	STRING
source	STRING
name	STRING
web_url	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP

campo	Tipo de dados
id	BIGINT
iid	BIGINT
project_id	BIGINT
sha	STRING
ref	STRING
status	STRING
source	STRING
name	STRING
web_url	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP

project_members

Chave primária: project_id, id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
id	BIGINT
project_id	BIGINT
username	STRING
name	STRING
state	STRING
access_level	BIGINT
avatar_url	STRING
web_url	STRING
created_by	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
expires_at	STRING
created_at	TIMESTAMP

campo	Tipo de dados
id	BIGINT
project_id	BIGINT
username	STRING
name	STRING
state	STRING
access_level	BIGINT
avatar_url	STRING
web_url	STRING
created_by	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
expires_at	STRING
created_at	TIMESTAMP

branches

Chave primária: project_id, name Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
project_id	BIGINT
name	STRING
merged	BOOLEAN
protected	BOOLEAN
developers_can_push	BOOLEAN
developers_can_merge	BOOLEAN
can_push	BOOLEAN
default	BOOLEAN
commit	STRUCT<id: STRING, short_id: STRING, created_at: TIMESTAMP, parent_ids: ARRAY<STRING>, title: STRING, message: STRING, author_name: STRING, author_email: STRING, authored_date: TIMESTAMP, committer_name: STRING, committer_email: STRING, committed_date: TIMESTAMP, web_url: STRING>

campo	Tipo de dados
project_id	BIGINT
name	STRING
merged	BOOLEAN
protected	BOOLEAN
developers_can_push	BOOLEAN
developers_can_merge	BOOLEAN
can_push	BOOLEAN
default	BOOLEAN
commit	STRUCT<id: STRING, short_id: STRING, created_at: TIMESTAMP, parent_ids: ARRAY<STRING>, title: STRING, message: STRING, author_name: STRING, author_email: STRING, authored_date: TIMESTAMP, committer_name: STRING, committer_email: STRING, committed_date: TIMESTAMP, web_url: STRING>

tags

Chave primária: project_id, name Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
project_id	BIGINT
name	STRING
message	STRING
target	STRING
protected	BOOLEAN
release	STRUCT<tag_name: STRING, description: STRING>
commit	STRUCT<id: STRING, short_id: STRING, created_at: TIMESTAMP, parent_ids: ARRAY<STRING>, title: STRING, message: STRING, author_name: STRING, author_email: STRING, authored_date: TIMESTAMP, committer_name: STRING, committer_email: STRING, committed_date: TIMESTAMP, web_url: STRING>
created_at	TIMESTAMP

campo	Tipo de dados
project_id	BIGINT
name	STRING
message	STRING
target	STRING
protected	BOOLEAN
release	STRUCT<tag_name: STRING, description: STRING>
commit	STRUCT<id: STRING, short_id: STRING, created_at: TIMESTAMP, parent_ids: ARRAY<STRING>, title: STRING, message: STRING, author_name: STRING, author_email: STRING, authored_date: TIMESTAMP, committer_name: STRING, committer_email: STRING, committed_date: TIMESTAMP, web_url: STRING>
created_at	TIMESTAMP

releases

Chave primária: project_id, tag_name Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
project_id	BIGINT
name	STRING
tag_name	STRING
description	STRING
created_at	TIMESTAMP
released_at	TIMESTAMP
author	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
commit	STRUCT<id: STRING, short_id: STRING, created_at: TIMESTAMP, parent_ids: ARRAY<STRING>, title: STRING, message: STRING, author_name: STRING, author_email: STRING, authored_date: TIMESTAMP, committer_name: STRING, committer_email: STRING, committed_date: TIMESTAMP, web_url: STRING>
assets	STRUCT<count: BIGINT, sources: ARRAY<STRUCT<format: STRING, url: STRING>>, links: ARRAY<STRUCT<id: BIGINT, name: STRING, url: STRING, direct_asset_url: STRING, link_type: STRING>>>
_links	VARIANT

campo	Tipo de dados
project_id	BIGINT
name	STRING
tag_name	STRING
description	STRING
created_at	TIMESTAMP
released_at	TIMESTAMP
author	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
commit	STRUCT<id: STRING, short_id: STRING, created_at: TIMESTAMP, parent_ids: ARRAY<STRING>, title: STRING, message: STRING, author_name: STRING, author_email: STRING, authored_date: TIMESTAMP, committer_name: STRING, committer_email: STRING, committed_date: TIMESTAMP, web_url: STRING>
assets	STRUCT<count: BIGINT, sources: ARRAY<STRUCT<format: STRING, url: STRING>>, links: ARRAY<STRUCT<id: BIGINT, name: STRING, url: STRING, direct_asset_url: STRING, link_type: STRING>>>
_links	VARIANT

nota

Esta tabela não é compatível com o SCD tipo 2 porque possui colunas VARIANT.

deployments

Chave key: id Campo de cursor: updated_at

campo	Tipo de dados
id	BIGINT
iid	BIGINT
project_id	BIGINT
status	STRING
ref	STRING
sha	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
user	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
environment	STRUCT<id: BIGINT, name: STRING, slug: STRING, external_url: STRING, created_at: TIMESTAMP, updated_at: TIMESTAMP>
deployable	VARIANT

campo	Tipo de dados
id	BIGINT
iid	BIGINT
project_id	BIGINT
status	STRING
ref	STRING
sha	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
user	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
environment	STRUCT<id: BIGINT, name: STRING, slug: STRING, external_url: STRING, created_at: TIMESTAMP, updated_at: TIMESTAMP>
deployable	VARIANT

nota

Esta tabela não é compatível com o SCD tipo 2 porque possui colunas VARIANT.

jobs

Chave primária: id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
id	BIGINT
project_id	BIGINT
pipeline_id	BIGINT
status	STRING
stage	STRING
name	STRING
ref	STRING
failure_reason	STRING
created_at	TIMESTAMP
started_at	TIMESTAMP
finished_at	TIMESTAMP
duration	DOUBLE
queued_duration	DOUBLE
user	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
commit	STRUCT<id: STRING, short_id: STRING, created_at: TIMESTAMP, parent_ids: ARRAY<STRING>, title: STRING, message: STRING, author_name: STRING, author_email: STRING, authored_date: TIMESTAMP, committer_name: STRING, committer_email: STRING, committed_date: TIMESTAMP, web_url: STRING>

campo	Tipo de dados
id	BIGINT
project_id	BIGINT
pipeline_id	BIGINT
status	STRING
stage	STRING
name	STRING
ref	STRING
failure_reason	STRING
created_at	TIMESTAMP
started_at	TIMESTAMP
finished_at	TIMESTAMP
duration	DOUBLE
queued_duration	DOUBLE
user	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
commit	STRUCT<id: STRING, short_id: STRING, created_at: TIMESTAMP, parent_ids: ARRAY<STRING>, title: STRING, message: STRING, author_name: STRING, author_email: STRING, authored_date: TIMESTAMP, committer_name: STRING, committer_email: STRING, committed_date: TIMESTAMP, web_url: STRING>

project_labels

Chave primária: project_id, id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
project_id	BIGINT
id	BIGINT
name	STRING
color	STRING
description	STRING
description_html	STRING
text_color	STRING
subscribed	BOOLEAN
archived	BOOLEAN
priority	BIGINT
is_project_label	BOOLEAN
open_issues_count	BIGINT
closed_issues_count	BIGINT
open_merge_requests_count	BIGINT

campo	Tipo de dados
project_id	BIGINT
id	BIGINT
name	STRING
color	STRING
description	STRING
description_html	STRING
text_color	STRING
subscribed	BOOLEAN
archived	BOOLEAN
priority	BIGINT
is_project_label	BOOLEAN
open_issues_count	BIGINT
closed_issues_count	BIGINT
open_merge_requests_count	BIGINT

project_milestones

Chave key: id Campo de cursor: updated_at

campo	Tipo de dados
id	BIGINT
iid	BIGINT
project_id	BIGINT
title	STRING
description	STRING
state	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
due_date	DATE
start_date	DATE
expired	BOOLEAN

campo	Tipo de dados
id	BIGINT
iid	BIGINT
project_id	BIGINT
title	STRING
description	STRING
state	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
due_date	DATE
start_date	DATE
expired	BOOLEAN

users

Chave primária: project_id, id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
project_id	BIGINT
id	BIGINT
name	STRING
username	STRING
state	STRING
avatar_url	STRING
web_url	STRING
locked	BOOLEAN

campo	Tipo de dados
project_id	BIGINT
id	BIGINT
name	STRING
username	STRING
state	STRING
avatar_url	STRING
web_url	STRING
locked	BOOLEAN

group_labels

Chave primária: group_id, id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
group_id	BIGINT
id	BIGINT
name	STRING
color	STRING
description	STRING
description_html	STRING
text_color	STRING
subscribed	BOOLEAN
archived	BOOLEAN
open_issues_count	BIGINT
closed_issues_count	BIGINT
open_merge_requests_count	BIGINT

campo	Tipo de dados
group_id	BIGINT
id	BIGINT
name	STRING
color	STRING
description	STRING
description_html	STRING
text_color	STRING
subscribed	BOOLEAN
archived	BOOLEAN
open_issues_count	BIGINT
closed_issues_count	BIGINT
open_merge_requests_count	BIGINT

group_milestones

Chave key: id Campo de cursor: updated_at

campo	Tipo de dados
id	BIGINT
iid	BIGINT
group_id	BIGINT
title	STRING
description	STRING
state	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
due_date	DATE
start_date	DATE
expired	BOOLEAN

campo	Tipo de dados
id	BIGINT
iid	BIGINT
group_id	BIGINT
title	STRING
description	STRING
state	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
due_date	DATE
start_date	DATE
expired	BOOLEAN

group_members

Chave primária: group_id, id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
group_id	BIGINT
id	BIGINT
name	STRING
username	STRING
state	STRING
avatar_url	STRING
web_url	STRING
access_level	BIGINT
created_by	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
created_at	TIMESTAMP
expires_at	STRING
locked	BOOLEAN

campo	Tipo de dados
group_id	BIGINT
id	BIGINT
name	STRING
username	STRING
state	STRING
avatar_url	STRING
web_url	STRING
access_level	BIGINT
created_by	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
created_at	TIMESTAMP
expires_at	STRING
locked	BOOLEAN

group_issue_boards

Chave primária: group_id, id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
id	BIGINT
group_id	BIGINT
name	STRING
hide_backlog_list	BOOLEAN
hide_closed_list	BOOLEAN
project	BIGINT
group	STRUCT<id: BIGINT, name: STRING, web_url: STRING>
lists	ARRAY<STRUCT<id: BIGINT, label: STRUCT<id: BIGINT, name: STRING, color: STRING, description: STRING, text_color: STRING>, position: BIGINT, max_issue_count: BIGINT, max_issue_weight: BIGINT, limit_metric: STRING>>

campo	Tipo de dados
id	BIGINT
group_id	BIGINT
name	STRING
hide_backlog_list	BOOLEAN
hide_closed_list	BOOLEAN
project	BIGINT
group	STRUCT<id: BIGINT, name: STRING, web_url: STRING>
lists	ARRAY<STRUCT<id: BIGINT, label: STRUCT<id: BIGINT, name: STRING, color: STRING, description: STRING, text_color: STRING>, position: BIGINT, max_issue_count: BIGINT, max_issue_weight: BIGINT, limit_metric: STRING>>

epics

Chave key: id Campo de cursor: updated_at

campo	Tipo de dados
id	BIGINT
work_item_id	BIGINT
iid	BIGINT
group_id	BIGINT
parent_id	BIGINT
parent_iid	BIGINT
title	STRING
description	STRING
state	STRING
confidential	BOOLEAN
web_url	STRING
reference	STRING
references	STRUCT<short: STRING, relative: STRING, full: STRING>
author	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
start_date	DATE
start_date_is_fixed	BOOLEAN
start_date_fixed	DATE
start_date_from_milestones	DATE
start_date_from_inherited_source	DATE
end_date	DATE
due_date	DATE
due_date_is_fixed	BOOLEAN
due_date_fixed	DATE
due_date_from_milestones	DATE
due_date_from_inherited_source	DATE
created_at	TIMESTAMP
updated_at	TIMESTAMP
closed_at	TIMESTAMP
labels	ARRAY<STRING>
upvotes	BIGINT
downvotes	BIGINT
color	STRING
_links	VARIANT

campo	Tipo de dados
id	BIGINT
work_item_id	BIGINT
iid	BIGINT
group_id	BIGINT
parent_id	BIGINT
parent_iid	BIGINT
title	STRING
description	STRING
state	STRING
confidential	BOOLEAN
web_url	STRING
reference	STRING
references	STRUCT<short: STRING, relative: STRING, full: STRING>
author	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
start_date	DATE
start_date_is_fixed	BOOLEAN
start_date_fixed	DATE
start_date_from_milestones	DATE
start_date_from_inherited_source	DATE
end_date	DATE
due_date	DATE
due_date_is_fixed	BOOLEAN
due_date_fixed	DATE
due_date_from_milestones	DATE
due_date_from_inherited_source	DATE
created_at	TIMESTAMP
updated_at	TIMESTAMP
closed_at	TIMESTAMP
labels	ARRAY<STRING>
upvotes	BIGINT
downvotes	BIGINT
color	STRING
_links	VARIANT

nota

Esta tabela não é compatível com o SCD tipo 2 porque possui colunas VARIANT.

merge_request_commits

Chave primária: project_id, merge_request_iid, id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
project_id	BIGINT
merge_request_iid	BIGINT
id	STRING
short_id	STRING
title	STRING
message	STRING
author_name	STRING
author_email	STRING
authored_date	TIMESTAMP
committer_name	STRING
committer_email	STRING
committed_date	TIMESTAMP
created_at	TIMESTAMP
parent_ids	ARRAY<STRING>
trailers	VARIANT
extended_trailers	VARIANT

campo	Tipo de dados
project_id	BIGINT
merge_request_iid	BIGINT
id	STRING
short_id	STRING
title	STRING
message	STRING
author_name	STRING
author_email	STRING
authored_date	TIMESTAMP
committer_name	STRING
committer_email	STRING
committed_date	TIMESTAMP
created_at	TIMESTAMP
parent_ids	ARRAY<STRING>
trailers	VARIANT
extended_trailers	VARIANT

nota

Esta tabela não é compatível com o SCD tipo 2 porque possui colunas VARIANT.

epic_issues

Chave primária: group_id, epic_iid, epic_issue_id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
group_id	BIGINT
epic_iid	BIGINT
epic_issue_id	BIGINT
id	BIGINT
iid	BIGINT
project_id	BIGINT
title	STRING
description	STRING
state	STRING
author	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
assignees	ARRAY<STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>>
milestone	STRUCT<id: BIGINT, iid: BIGINT, project_id: BIGINT, group_id: BIGINT, title: STRING, description: STRING, state: STRING, created_at: TIMESTAMP, updated_at: TIMESTAMP, due_date: DATE, start_date: DATE, expired: BOOLEAN, web_url: STRING>
labels	ARRAY<STRING>
confidential	BOOLEAN
weight	BIGINT
discussion_locked	BOOLEAN
user_notes_count	BIGINT
upvotes	BIGINT
downvotes	BIGINT
due_date	DATE
web_url	STRING
time_stats	STRUCT<time_estimate: BIGINT, total_time_spent: BIGINT, human_time_estimate: STRING, human_total_time_spent: STRING>
_links	VARIANT
created_at	TIMESTAMP
updated_at	TIMESTAMP
closed_at	TIMESTAMP

campo	Tipo de dados
group_id	BIGINT
epic_iid	BIGINT
epic_issue_id	BIGINT
id	BIGINT
iid	BIGINT
project_id	BIGINT
title	STRING
description	STRING
state	STRING
author	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
assignees	ARRAY<STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>>
milestone	STRUCT<id: BIGINT, iid: BIGINT, project_id: BIGINT, group_id: BIGINT, title: STRING, description: STRING, state: STRING, created_at: TIMESTAMP, updated_at: TIMESTAMP, due_date: DATE, start_date: DATE, expired: BOOLEAN, web_url: STRING>
labels	ARRAY<STRING>
confidential	BOOLEAN
weight	BIGINT
discussion_locked	BOOLEAN
user_notes_count	BIGINT
upvotes	BIGINT
downvotes	BIGINT
due_date	DATE
web_url	STRING
time_stats	STRUCT<time_estimate: BIGINT, total_time_spent: BIGINT, human_time_estimate: STRING, human_total_time_spent: STRING>
_links	VARIANT
created_at	TIMESTAMP
updated_at	TIMESTAMP
closed_at	TIMESTAMP

nota

Esta tabela não é compatível com o SCD tipo 2 porque possui colunas VARIANT.

pipelines_extended

Chave primária: project_id, id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
project_id	BIGINT
id	BIGINT
iid	BIGINT
name	STRING
sha	STRING
before_sha	STRING
ref	STRING
tag	BOOLEAN
status	STRING
source	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
started_at	TIMESTAMP
finished_at	TIMESTAMP
committed_at	TIMESTAMP
duration	BIGINT
queued_duration	DOUBLE
coverage	STRING
yaml_errors	STRING
web_url	STRING
user	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
detailed_status	STRUCT<icon: STRING, text: STRING, label: STRING, group: STRING, tooltip: STRING, has_details: BOOLEAN, details_path: STRING, favicon: STRING>
archived	BOOLEAN

campo	Tipo de dados
project_id	BIGINT
id	BIGINT
iid	BIGINT
name	STRING
sha	STRING
before_sha	STRING
ref	STRING
tag	BOOLEAN
status	STRING
source	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
started_at	TIMESTAMP
finished_at	TIMESTAMP
committed_at	TIMESTAMP
duration	BIGINT
queued_duration	DOUBLE
coverage	STRING
yaml_errors	STRING
web_url	STRING
user	STRUCT<id: BIGINT, username: STRING, public_email: STRING, name: STRING, state: STRING, locked: BOOLEAN, avatar_url: STRING, web_url: STRING>
detailed_status	STRUCT<icon: STRING, text: STRING, label: STRING, group: STRING, tooltip: STRING, has_details: BOOLEAN, details_path: STRING, favicon: STRING>
archived	BOOLEAN

group_iterations

Chave key: group_id, id Campo de cursor: updated_at

campo	Tipo de dados
group_id	BIGINT
id	BIGINT
iid	BIGINT
sequence	BIGINT
title	STRING
description	STRING
state	BIGINT
created_at	TIMESTAMP
updated_at	TIMESTAMP
start_date	DATE
due_date	DATE
web_url	STRING

campo	Tipo de dados
group_id	BIGINT
id	BIGINT
iid	BIGINT
sequence	BIGINT
title	STRING
description	STRING
state	BIGINT
created_at	TIMESTAMP
updated_at	TIMESTAMP
start_date	DATE
due_date	DATE
web_url	STRING

epic_boards

Chave primária: group_id, id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
group_id	BIGINT
id	BIGINT
name	STRING
hide_backlog_list	BOOLEAN
hide_closed_list	BOOLEAN
group	STRUCT<id: BIGINT, name: STRING, web_url: STRING>
labels	ARRAY<STRUCT<id: BIGINT, name: STRING, color: STRING, description: STRING, text_color: STRING>>
lists	ARRAY<STRUCT<id: BIGINT, label: STRUCT<id: BIGINT, name: STRING, color: STRING, description: STRING, text_color: STRING>, position: BIGINT, list_type: STRING>>

campo	Tipo de dados
group_id	BIGINT
id	BIGINT
name	STRING
hide_backlog_list	BOOLEAN
hide_closed_list	BOOLEAN
group	STRUCT<id: BIGINT, name: STRING, web_url: STRING>
labels	ARRAY<STRUCT<id: BIGINT, name: STRING, color: STRING, description: STRING, text_color: STRING>>
lists	ARRAY<STRUCT<id: BIGINT, label: STRUCT<id: BIGINT, name: STRING, color: STRING, description: STRING, text_color: STRING>, position: BIGINT, list_type: STRING>>

merge_request_discussions

Chave primária: project_id, merge_request_iid, id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
project_id	BIGINT
merge_request_iid	BIGINT
id	STRING
individual_note	BOOLEAN
notes	VARIANT

campo	Tipo de dados
project_id	BIGINT
merge_request_iid	BIGINT
id	STRING
individual_note	BOOLEAN
notes	VARIANT

nota

Esta tabela não é compatível com o SCD tipo 2 porque possui colunas VARIANT.

vulnerabilities

Chave primária: project_id, id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
project_id	BIGINT
id	STRING
title	STRING
description	STRING
state	STRING
severity	STRING
reportType	STRING
detectedAt	TIMESTAMP
confirmedAt	TIMESTAMP
resolvedAt	TIMESTAMP
dismissedAt	TIMESTAMP
dismissalReason	STRING

campo	Tipo de dados
project_id	BIGINT
id	STRING
title	STRING
description	STRING
state	STRING
severity	STRING
reportType	STRING
detectedAt	TIMESTAMP
confirmedAt	TIMESTAMP
resolvedAt	TIMESTAMP
dismissedAt	TIMESTAMP
dismissalReason	STRING

compliance_frameworks

Chave primária: group_id, id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
group_id	BIGINT
id	STRING
name	STRING
description	STRING
color	STRING
default	BOOLEAN
pipelineConfigurationFullPath	STRING

campo	Tipo de dados
group_id	BIGINT
id	STRING
name	STRING
description	STRING
color	STRING
default	BOOLEAN
pipelineConfigurationFullPath	STRING