Référence du connecteur GitLab

info

Bêta

Cette fonctionnalité est en version Bêta. Pour l'utiliser, un administrateur du workspace doit activer Lakeflow Connect for GitLab depuis la page Previews . Consultez Gérer les aperçus Databricks.

Cette page contient des informations de référence sur le connecteur GitLab géré, notamment sur les tables source prises en charge et les schémas de table de destination.

Tables sources prises en charge

Le connecteur GitLab prend en charge les tables sources suivantes, toutes situées sous le schéma source default :

Table source	Clé primaire	Description	Mode de synchronisation	Champ de curseur
`groups`	`id`	Groupes GitLab dont l’utilisateur effectuant l’authentification est membre.	Full refresh uniquement
`projects`	`id`	Projects GitLab dont l’utilisateur qui s’authentifie est membre.	Full refresh uniquement
`issues`	`id`	Problèmes dans l'ensemble des projets membres.	Incrémentiel	`updated_at`
`merge_requests`	`id`	Merge requests dans l’ensemble des projets membres.	Incrémentiel	`updated_at`
`commits`	`id`	Commits du repository pour chaque projet membre.	Incrémentiel	`created_at`
`pipelines`	`id`	Pipelines CI/CD pour chaque projet.	Incrémentiel	`updated_at`
`project_members`	`project_id, id`	Membres de chaque projet.	Full refresh uniquement
`branches`	`project_id, name`	Branches de repository pour chaque projet.	Full refresh uniquement
`tags`	`project_id, name`	Tags de repository pour chaque projet.	Full refresh uniquement
`releases`	`project_id, tag_name`	Versions de chaque projet.	Full refresh uniquement
`deployments`	`id`	Déploiements pour chaque projet.	Incrémentiel	`updated_at`
`jobs`	`id`	Jobs CI/CD pour chaque pipeline.	Full refresh uniquement
`project_labels`	`project_id, id`	Étiquettes définies dans chaque projet.	Full refresh uniquement
`project_milestones`	`id`	Jalons pour chaque project.	Incrémentiel	`updated_at`
`users`	`project_id, id`	Utilisateurs ayant accès à chaque projet.	Full refresh uniquement
`group_labels`	`group_id, id`	Étiquettes définies dans chaque groupe.	Full refresh uniquement
`group_milestones`	`id`	Jalons pour chaque groupe.	Incrémentiel	`updated_at`
`group_members`	`group_id, id`	Membres de chaque groupe.	Full refresh uniquement
`group_issue_boards`	`group_id, id`	Tableaux de bord des problèmes pour chaque groupe.	Full refresh uniquement
`epics`	`id`	Épopees pour chaque groupe. Nécessite un groupe GitLab Premium ou Ultimate.	Incrémentiel	`updated_at`
`merge_request_commits`	`project_id, merge_request_iid, id`	Commits sur chaque merge request.	Full refresh uniquement
`epic_issues`	`group_id, epic_iid, epic_issue_id`	Problèmes liés à chaque epic. Nécessite un groupe GitLab Premium ou Ultimate.	Full refresh uniquement
`pipelines_extended`	`project_id, id`	Détails détaillés pour chaque pipeline.	Full refresh uniquement
`group_iterations`	`group_id, id`	Itérations pour chaque groupe. Requiert un groupe GitLab Premium ou Ultimate.	Incrémentiel	`updated_at`
`epic_boards`	`group_id, id`	Tableaux d’épiques pour chaque groupe. Nécessite un groupe GitLab Premium ou Ultimate.	Full refresh uniquement
`merge_request_discussions`	`project_id, merge_request_iid, id`	Fils de discussion sur chaque merge request.	Full refresh uniquement
`vulnerabilities`	`project_id, id`	Vulnérabilités de sécurité pour chaque project. Nécessite un project GitLab Ultimate.	Full refresh uniquement
`compliance_frameworks`	`group_id, id`	Cadres de conformité pour chaque groupe. Requiert un groupe GitLab Ultimate.	Full refresh uniquement

Table source	Clé primaire	Description	Mode de synchronisation	Champ de curseur
`groups`	`id`	Groupes GitLab dont l’utilisateur effectuant l’authentification est membre.	Full refresh uniquement
`projects`	`id`	Projects GitLab dont l’utilisateur qui s’authentifie est membre.	Full refresh uniquement
`issues`	`id`	Problèmes dans l'ensemble des projets membres.	Incrémentiel	`updated_at`
`merge_requests`	`id`	Merge requests dans l’ensemble des projets membres.	Incrémentiel	`updated_at`
`commits`	`id`	Commits du repository pour chaque projet membre.	Incrémentiel	`created_at`
`pipelines`	`id`	Pipelines CI/CD pour chaque projet.	Incrémentiel	`updated_at`
`project_members`	`project_id, id`	Membres de chaque projet.	Full refresh uniquement
`branches`	`project_id, name`	Branches de repository pour chaque projet.	Full refresh uniquement
`tags`	`project_id, name`	Tags de repository pour chaque projet.	Full refresh uniquement
`releases`	`project_id, tag_name`	Versions de chaque projet.	Full refresh uniquement
`deployments`	`id`	Déploiements pour chaque projet.	Incrémentiel	`updated_at`
`jobs`	`id`	Jobs CI/CD pour chaque pipeline.	Full refresh uniquement
`project_labels`	`project_id, id`	Étiquettes définies dans chaque projet.	Full refresh uniquement
`project_milestones`	`id`	Jalons pour chaque project.	Incrémentiel	`updated_at`
`users`	`project_id, id`	Utilisateurs ayant accès à chaque projet.	Full refresh uniquement
`group_labels`	`group_id, id`	Étiquettes définies dans chaque groupe.	Full refresh uniquement
`group_milestones`	`id`	Jalons pour chaque groupe.	Incrémentiel	`updated_at`
`group_members`	`group_id, id`	Membres de chaque groupe.	Full refresh uniquement
`group_issue_boards`	`group_id, id`	Tableaux de bord des problèmes pour chaque groupe.	Full refresh uniquement
`epics`	`id`	Épopees pour chaque groupe. Nécessite un groupe GitLab Premium ou Ultimate.	Incrémentiel	`updated_at`
`merge_request_commits`	`project_id, merge_request_iid, id`	Commits sur chaque merge request.	Full refresh uniquement
`epic_issues`	`group_id, epic_iid, epic_issue_id`	Problèmes liés à chaque epic. Nécessite un groupe GitLab Premium ou Ultimate.	Full refresh uniquement
`pipelines_extended`	`project_id, id`	Détails détaillés pour chaque pipeline.	Full refresh uniquement
`group_iterations`	`group_id, id`	Itérations pour chaque groupe. Requiert un groupe GitLab Premium ou Ultimate.	Incrémentiel	`updated_at`
`epic_boards`	`group_id, id`	Tableaux d’épiques pour chaque groupe. Nécessite un groupe GitLab Premium ou Ultimate.	Full refresh uniquement
`merge_request_discussions`	`project_id, merge_request_iid, id`	Fils de discussion sur chaque merge request.	Full refresh uniquement
`vulnerabilities`	`project_id, id`	Vulnérabilités de sécurité pour chaque project. Nécessite un project GitLab Ultimate.	Full refresh uniquement
`compliance_frameworks`	`group_id, id`	Cadres de conformité pour chaque groupe. Requiert un groupe GitLab Ultimate.	Full refresh uniquement

Options du connecteur

Pour connaître l'utilisation, consultez les Examples.

Option	Type	Périmètre	Obligatoire	S’applique à	Description
`start_datetime`	chaîne	Pipeline	Non	Toutes les tables incrémentielles	L’Timestamp de l’enregistrement le plus ancien à ingérer lors de la première synchronisation, au format `yyyy-MM-dd'T'HH:mm:ss.SSS'Z'`. Par default sur `2018-01-01T00:00:00.000Z`.

Option	Type	Périmètre	Obligatoire	S’applique à	Description
`start_datetime`	chaîne	Pipeline	Non	Toutes les tables incrémentielles	L’Timestamp de l’enregistrement le plus ancien à ingérer lors de la première synchronisation, au format `yyyy-MM-dd'T'HH:mm:ss.SSS'Z'`. Par default sur `2018-01-01T00:00:00.000Z`.

Schémas de table de destination

`groups`

Clé principale : id Mode de synchronisation : refresh complet uniquement

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

Clé principale : id Mode de synchronisation : refresh complet uniquement

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

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

Primary key : id Cursor field : updated_at

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

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

Primary key : id Cursor field : updated_at

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

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

Primary key : id Cursor field : created_at

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

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

remarque

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

`pipelines`

Primary key : id Cursor field : updated_at

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

Clé principale : project_id, id Mode de synchronisation : refresh complet uniquement

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

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

Clé principale : project_id, name Mode de synchronisation : refresh complet uniquement

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

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

Clé principale : project_id, name Mode de synchronisation : refresh complet uniquement

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

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

Clé principale : project_id, tag_name Mode de synchronisation : refresh complet uniquement

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

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

remarque

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

`deployments`

Primary key : id Cursor field : updated_at

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

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

remarque

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

`jobs`

Clé principale : id Mode de synchronisation : refresh complet uniquement

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

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

Clé principale : project_id, id Mode de synchronisation : refresh complet uniquement

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

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

Primary key : id Cursor field : updated_at

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

Clé principale : project_id, id Mode de synchronisation : refresh complet uniquement

Champ	Type de données
`project_id`	`BIGINT`
`id`	`BIGINT`
`name`	`STRING`
`username`	`STRING`
`state`	`STRING`
`avatar_url`	`STRING`
`web_url`	`STRING`
`locked`	`BOOLEAN`

`group_labels`

Clé principale : group_id, id Mode de synchronisation : refresh complet uniquement

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

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

Primary key : id Cursor field : updated_at

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

Clé principale : group_id, id Mode de synchronisation : refresh complet uniquement

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

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

Clé principale : group_id, id Mode de synchronisation : refresh complet uniquement

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

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

Primary key : id Cursor field : updated_at

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

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

remarque

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

`merge_request_commits`

Clé principale : project_id, merge_request_iid, id Mode de synchronisation : refresh complet uniquement

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

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

remarque

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

`epic_issues`

Clé principale : group_id, epic_iid, epic_issue_id Mode de synchronisation : refresh complet uniquement

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

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

remarque

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

`pipelines_extended`

Clé principale : project_id, id Mode de synchronisation : refresh complet uniquement

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

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

Primary key : group_id, id Cursor field : updated_at

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

Clé principale : group_id, id Mode de synchronisation : refresh complet uniquement

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

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

Clé principale : project_id, merge_request_iid, id Mode de synchronisation : refresh complet uniquement

Champ	Type de données
`project_id`	`BIGINT`
`merge_request_iid`	`BIGINT`
`id`	`STRING`
`individual_note`	`BOOLEAN`
`notes`	`VARIANT`

remarque

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

`vulnerabilities`

Clé principale : project_id, id Mode de synchronisation : refresh complet uniquement

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

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

Clé principale : group_id, id Mode de synchronisation : refresh complet uniquement

Champ	Type de données
`group_id`	`BIGINT`
`id`	`STRING`
`name`	`STRING`
`description`	`STRING`
`color`	`STRING`
`default`	`BOOLEAN`
`pipelineConfigurationFullPath`	`STRING`

Tables sources prises en charge​

Options du connecteur​

Schémas de table de destination​

groups​

projects​

issues​

merge_requests​

commits​

pipelines​

project_members​

branches​

tags​

releases​

deployments​

jobs​

project_labels​

project_milestones​

users​

group_labels​

group_milestones​

group_members​

group_issue_boards​

epics​

merge_request_commits​

epic_issues​

pipelines_extended​

group_iterations​

epic_boards​

merge_request_discussions​

vulnerabilities​

compliance_frameworks​

Tables sources prises en charge

Options du connecteur

Schémas de table de destination

`groups`

`projects`

`issues`

`merge_requests`

`commits`

`pipelines`

`project_members`

`branches`

`tags`

`releases`

`deployments`

`jobs`

`project_labels`

`project_milestones`

`users`

`group_labels`

`group_milestones`

`group_members`

`group_issue_boards`

`epics`

`merge_request_commits`

`epic_issues`

`pipelines_extended`

`group_iterations`

`epic_boards`

`merge_request_discussions`

`vulnerabilities`

`compliance_frameworks`