Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Expected GitLab Data

GitLab Info
This integration was created by Stitch for Singer, an open-source, composable ETL platform. Check out & contribute to the repo on GitHub.

GitLab is currently in Open Beta. The info in this article is subject to change.

Now that GitLab is successfully connected to your Stitch account, what comes next? In this article, we'll cover:

  1. How Stitch replicates GitLab data
  2. The tables that will be created in your data warehouse

Replicating GitLab Data

Historical Sync

By default, a historical sync of GitLab data goes back one year from the Stitch connection date.

Frequency

Stitch will replicate GitLab data based on the frequency you define. The default setting is every 30 minutes, but you can change it better suit your needs.

Replication Method

When Stitch replicates GitLab data, it does so using Incremental Replication. This means that every time GitLab data is queued for replication, only new and updated data will be replicated to your data warehouse.

There is one exception to this, however. The users table uses Full Table Replication, meaning that both new and existing rows will be replicated to your data warehouse during every replication job.

GitLab Tables in Your Data Warehouse

Below is a list of the GitLab tables that will be created in your data warehouse. Because GitLab uses nested arrays to structure data in some of its API's endpoints, Stitch will de-nest these arrays and create subtables if your data warehouse doesn't natively support nested structures. Refer to the Handling of Nested Data Structures doc for more info.

Nested arrays are marked with a *.

Click the table names to check out GitLab's API docs.

branches
Replication Method: Incremental
Primary Key: project_id : name

The branches table contains high-level info about repository branches in your projects.

Attributes include:

  • project_id
  • name
  • merged
  • protected
  • developers_can_push
  • developers_can_merge
  • commit_id

commits
Replication Method: Incremental
Primary Key: id

The commits table contains info about repository commits in a project.

Attributes include:

  • Commit ID (id)
  • project_id
  • short_id
  • title
  • author_name
  • author_email
  • committer_name
  • committer_email
  • created_at
  • message
  • allow_failure

issues
Replication Method: Incremental
Primary Key: id

The issues table contains info about issues contained within projects.

Attributes include:

  • Issue ID (id)
  • project_id
  • milestone_id
  • author_id
  • assignee_id
  • description
  • state
  • iid
  • labels *
  • title
  • updated_at
  • created_at
  • subscribed
  • user_notes_count
  • due_date
  • web_url
  • confidential

milestones
Replication Method: Incremental
Primary Key: id

The milestones table contains info about project milestones.

Attributes include:

  • Milestone ID (id)
  • iid
  • project_id
  • title
  • description
  • due_date
  • start_date
  • state
  • updated_at
  • created_at

projects
Replication Method: Incremental
Primary Key: id

The projects table contains info about specific projects.

Attributes include:

  • Project ID (id)
  • approvals_before_merge
  • archived
  • avatar_url
  • builds_enabled
  • container_registry_enabled
  • created_at
  • creator_id
  • default_branch
  • description
  • forks_count
  • http_url_to_repo
  • issues_enabled
  • last_activity_at
  • lfs_enabled
  • merge_requests_enabled
  • name
  • name_with_namespace
  • namespace__id
  • namespace__kind
  • namespace__name
  • namespace__path
  • only_allow_merge_if_all_discussions_are_resolved
  • only_allow_merge_if_build_succeeds
  • open_issues_count
  • owner_id
  • path
  • path_with_namespace
  • permissions__group_access__access_level
  • permissions__group_access__notification_level
  • project_access__group_access__access_level
  • project_access__group_access__notification_level
  • public
  • public_builds
  • request_access_enabled
  • shared_runners_enabled
  • shared_with_groups *
  • snippets_enabled
  • ssh_url_to_repo
  • star_count
  • tag_list *
  • visibility_level
  • web_url
  • wiki_enabled

users
Replication Method: Full Table
Primary Key: id

The users table contains info about the users in your GitLab account.

Attributes include:

  • User ID (id)
  • username
  • name
  • state
  • avatar_url
  • web_url

Related

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!