Gitlab

Setting up the Gitlab connector

No	Item	Required	Example	Notes
1	Authorization Method	Yes
2	API URL	Yes	gitlab.com	Please enter your basic URL from GitLab instance.
3	Start Date	Yes	2021-03-01T00:00:00Z	The date from which you'd like to replicate data for GitLab API, in the format YYYY-MM-DDT00:00:00Z. All data generated after this date will be replicated.
4	Groups	No	airbyte.io	Space-delimited list of groups. e.g. zipstack.io.
5	Projects	No	airbyte.io/documentation	Space-delimited list of projects. e.g. zipstack.io/documentation meltano/tap-gitlab.

Tables in the Gitlab connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	projects	81	id	Full Refresh		API Reference
2	group_milestones	12	id	Full Refresh
3	merge_requests	43	id	Full Refresh, Incremental	updated_at
4	group_members	10	id	Full Refresh
5	jobs	22	id	Full Refresh		API Reference
6	groups	31	id	Full Refresh		API Reference
7	branches	10	name	Full Refresh		API Reference
8	group_labels	11	id	Full Refresh
9	epics	27	iid	Full Refresh		API Reference
10	issues	36	id	Full Refresh, Incremental	updated_at	API Reference
11	users	6	id	Full Refresh		API Reference
12	releases	15	name	Full Refresh		API Reference
13	tags	7	name	Full Refresh		API Reference
14	project_milestones	12	id	Full Refresh
15	project_members	10	id	Full Refresh
16	pipelines	8	id	Full Refresh, Incremental	updated_at	API Reference
17	project_labels	13	id	Full Refresh
18	commits	16	id	Full Refresh, Incremental	created_at	API Reference
19	merge_request_commits	55	id	Full Refresh
20	epic_issues	25	epic_issue_id	Full Refresh
21	group_issue_boards	7	id	Full Refresh
22	pipelines_extended	19	id	Full Refresh

Table: projects

No	Column Name	Type	Notes
1	ssh_url_to_repo	VARCHAR
2	only_allow_merge_if_all_discussions_are_resolved	BOOLEAN
3	_links	VARCHAR
4	request_access_enabled	BOOLEAN
5	build_timeout	INTEGER
6	path	VARCHAR
7	permissions	VARCHAR
8	repository_access_level	VARCHAR
9	wiki_access_level	VARCHAR
10	shared_runners_enabled	BOOLEAN
11	id	INTEGER	Primary Key
12	merge_requests_access_level	VARCHAR
13	allow_merge_on_skipped_pipeline	BOOLEAN
14	lfs_enabled	BOOLEAN
15	visibility	VARCHAR
16	resolve_outdated_diff_discussions	BOOLEAN
17	builds_access_level	VARCHAR
18	merge_requests_enabled	BOOLEAN
19	forking_access_level	VARCHAR
20	shared_with_groups	VARCHAR
21	security_and_compliance_enabled	BOOLEAN
22	build_coverage_regex	VARCHAR
23	suggestion_commit_message	VARCHAR
24	pages_access_level	VARCHAR
25	auto_devops_enabled	BOOLEAN
26	service_desk_enabled	BOOLEAN
27	requirements_enabled	BOOLEAN
28	compliance_frameworks	VARCHAR
29	name	VARCHAR
30	creator_id	INTEGER
31	ci_forward_deployment_enabled	BOOLEAN
32	external_authorization_classification_label	VARCHAR
33	default_branch	VARCHAR
34	auto_devops_deploy_strategy	VARCHAR
35	can_create_merge_request_in	BOOLEAN
36	name_with_namespace	VARCHAR
37	runners_token	VARCHAR
38	autoclose_referenced_issues	BOOLEAN
39	issues_enabled	BOOLEAN
40	service_desk_address	VARCHAR
41	open_issues_count	INTEGER
42	restrict_user_defined_variables	BOOLEAN
43	container_registry_image_prefix	VARCHAR
44	auto_cancel_pending_pipelines	VARCHAR
45	packages_enabled	BOOLEAN
46	snippets_enabled	BOOLEAN
47	description	VARCHAR
48	created_at	VARCHAR
49	import_status	VARCHAR
50	ci_default_git_depth	INTEGER
51	archived	BOOLEAN
52	ci_config_path	VARCHAR
53	build_git_strategy	VARCHAR
54	tag_list	VARCHAR
55	last_activity_at	VARCHAR
56	container_expiration_policy	VARCHAR
57	container_registry_enabled	BOOLEAN
58	operations_access_level	VARCHAR
59	issues_access_level	VARCHAR
60	emails_disabled	BOOLEAN
61	printing_merge_request_link_enabled	BOOLEAN
62	path_with_namespace	VARCHAR
63	topics	VARCHAR
64	jobs_enabled	BOOLEAN
65	import_error	VARCHAR
66	snippets_access_level	VARCHAR
67	http_url_to_repo	VARCHAR
68	only_allow_merge_if_pipeline_succeeds	BOOLEAN
69	readme_url	VARCHAR
70	analytics_access_level	VARCHAR
71	merge_method	VARCHAR
72	web_url	VARCHAR
73	avatar_url	VARCHAR
74	wiki_enabled	BOOLEAN
75	public_jobs	BOOLEAN
76	remove_source_branch_after_merge	BOOLEAN
77	namespace	VARCHAR
78	empty_repo	BOOLEAN
79	star_count	INTEGER
80	forks_count	INTEGER
81	statistics	VARCHAR

Table: group_milestones

No	Column Name	Type	Notes
1	expired	BOOLEAN
2	updated_at	VARCHAR
3	web_url	VARCHAR
4	iid	INTEGER
5	group_id	INTEGER
6	due_date	VARCHAR
7	description	VARCHAR
8	created_at	VARCHAR
9	id	INTEGER	Primary Key
10	state	VARCHAR
11	title	VARCHAR
12	start_date	VARCHAR

Table: merge_requests

No	Column Name	Type	Notes
1	discussion_locked	BOOLEAN
2	has_conflicts	BOOLEAN
3	upvotes	INTEGER
4	merge_when_pipeline_succeeds	BOOLEAN
5	references	VARCHAR
6	iid	INTEGER
7	milestone_id	INTEGER
8	description	VARCHAR
9	created_at	VARCHAR
10	assignees	VARCHAR
11	title	VARCHAR
12	source_branch	VARCHAR
13	reference	VARCHAR
14	squash	BOOLEAN
15	updated_at	VARCHAR	Incremental sync key
16	project_id	INTEGER
17	merge_commit_sha	VARCHAR
18	time_stats	VARCHAR
19	blocking_discussions_resolved	BOOLEAN
20	id	INTEGER	Primary Key
21	state	VARCHAR
22	assignee_id	INTEGER
23	closed_at	VARCHAR
24	work_in_progress	BOOLEAN
25	merged_at	VARCHAR
26	target_branch	VARCHAR
27	merged_by_id	INTEGER
28	source_project_id	INTEGER
29	downvotes	INTEGER
30	should_remove_source_branch	BOOLEAN
31	reviewers	VARCHAR
32	sha	VARCHAR
33	labels	VARCHAR
34	closed_by_id	INTEGER
35	web_url	VARCHAR
36	merge_status	VARCHAR
37	user_notes_count	INTEGER
38	squash_commit_sha	VARCHAR
39	task_completion_status	VARCHAR
40	approvals_before_merge	BOOLEAN
41	author_id	INTEGER
42	target_project_id	INTEGER
43	force_remove_source_branch	BOOLEAN

Table: group_members

No	Column Name	Type	Notes
1	access_level	INTEGER
2	expires_at	VARCHAR
3	avatar_url	VARCHAR
4	web_url	VARCHAR
5	group_id	INTEGER
6	name	VARCHAR
7	created_at	VARCHAR
8	id	INTEGER	Primary Key
9	state	VARCHAR
10	username	VARCHAR

Table: jobs

No	Column Name	Type	Notes
1	coverage	DOUBLE
2	runner_id	INTEGER
3	finished_at	VARCHAR
4	created_at	VARCHAR
5	artifacts_expire_at	VARCHAR
6	queued_duration	DOUBLE
7	duration	DOUBLE
8	ref	VARCHAR
9	allow_failure	BOOLEAN
10	stage	VARCHAR
11	web_url	VARCHAR
12	user_id	INTEGER
13	project_id	INTEGER
14	tag_list	VARCHAR
15	name	VARCHAR
16	pipeline_id	INTEGER
17	started_at	VARCHAR
18	id	INTEGER	Primary Key
19	tag	BOOLEAN
20	commit_id	VARCHAR
21	status	VARCHAR
22	artifacts	VARCHAR

Table: groups

No	Column Name	Type	Notes
1	projects	VARCHAR
2	request_access_enabled	BOOLEAN
3	ldap_access	VARCHAR
4	description	VARCHAR
5	share_with_group_lock	BOOLEAN
6	created_at	VARCHAR
7	mentions_disabled	BOOLEAN
8	path	VARCHAR
9	ldap_cn	VARCHAR
10	project_creation_level	VARCHAR
11	id	INTEGER	Primary Key
12	full_path	VARCHAR
13	lfs_enabled	BOOLEAN
14	shared_projects	VARCHAR
15	emails_disabled	BOOLEAN
16	visibility	VARCHAR
17	shared_runners_minutes_limit	INTEGER
18	two_factor_grace_period	INTEGER
19	require_two_factor_authentication	BOOLEAN
20	shared_with_groups	VARCHAR
21	subgroup_creation_level	VARCHAR
22	auto_devops_enabled	BOOLEAN
23	full_name	VARCHAR
24	web_url	VARCHAR
25	avatar_url	VARCHAR
26	extra_shared_runners_minutes_limit	INTEGER
27	parent_id	INTEGER
28	name	VARCHAR
29	default_branch_protection	INTEGER
30	prevent_forking_outside_group	BOOLEAN
31	runners_token	VARCHAR

Table: branches

No	Column Name	Type	Notes
1	default	BOOLEAN
2	protected	BOOLEAN
3	web_url	VARCHAR
4	project_id	INTEGER
5	developers_can_push	BOOLEAN
6	developers_can_merge	BOOLEAN
7	name	VARCHAR	Primary Key
8	merged	BOOLEAN
9	can_push	BOOLEAN
10	commit_id	VARCHAR

Table: group_labels

No	Column Name	Type	Notes
1	subscribed	BOOLEAN
2	color	VARCHAR
3	group_id	INTEGER
4	open_issues_count	INTEGER
5	name	VARCHAR
6	open_merge_requests_count	INTEGER
7	description	VARCHAR
8	closed_issues_count	INTEGER
9	id	INTEGER	Primary Key
10	description_html	VARCHAR
11	text_color	VARCHAR

Table: epics

No	Column Name	Type	Notes
1	end_date	VARCHAR
2	references	VARCHAR
3	upvotes	INTEGER
4	iid	INTEGER	Primary Key
5	description	VARCHAR
6	created_at	VARCHAR
7	title	VARCHAR
8	reference	VARCHAR
9	due_date_is_fixed	BOOLEAN
10	start_date_is_fixed	BOOLEAN
11	updated_at	VARCHAR
12	id	INTEGER
13	state	VARCHAR
14	due_date_from_inherited_source	VARCHAR
15	confidential	BOOLEAN
16	start_date	VARCHAR
17	closed_at	VARCHAR
18	start_date_from_inherited_source	VARCHAR
19	due_date	VARCHAR
20	downvotes	INTEGER
21	due_date_fixed	VARCHAR
22	labels	VARCHAR
23	web_url	VARCHAR
24	group_id	INTEGER
25	parent_id	INTEGER
26	start_date_fixed	VARCHAR
27	author_id	INTEGER

Table: issues

No	Column Name	Type	Notes
1	discussion_locked	BOOLEAN
2	upvotes	INTEGER
3	references	VARCHAR
4	iid	INTEGER
5	merge_requests_count	INTEGER
6	_links	VARCHAR
7	milestone_id	INTEGER
8	description	VARCHAR
9	created_at	VARCHAR
10	assignees	VARCHAR
11	title	VARCHAR
12	type	VARCHAR
13	has_tasks	BOOLEAN
14	subscribed	BOOLEAN
15	service_desk_reply_to	VARCHAR
16	updated_at	VARCHAR	Incremental sync key
17	project_id	INTEGER
18	time_stats	VARCHAR
19	id	INTEGER	Primary Key
20	state	VARCHAR
21	confidential	BOOLEAN
22	assignee_id	INTEGER
23	task_status	VARCHAR
24	closed_at	VARCHAR
25	due_date	VARCHAR
26	issue_type	VARCHAR
27	weight	INTEGER
28	downvotes	INTEGER
29	blocking_issues_count	INTEGER
30	labels	VARCHAR
31	moved_to_id	INTEGER
32	closed_by_id	INTEGER
33	web_url	VARCHAR
34	user_notes_count	INTEGER
35	task_completion_status	VARCHAR
36	author_id	INTEGER

Table: users

No	Column Name	Type	Notes
1	avatar_url	VARCHAR
2	web_url	VARCHAR
3	name	VARCHAR
4	id	INTEGER	Primary Key
5	state	VARCHAR
6	username	VARCHAR

Table: releases

No	Column Name	Type	Notes
1	_links	VARCHAR
2	tag_name	VARCHAR
3	description	VARCHAR
4	created_at	VARCHAR
5	released_at	VARCHAR
6	commit_path	VARCHAR
7	upcoming_release	BOOLEAN
8	assets	VARCHAR
9	project_id	INTEGER
10	name	VARCHAR	Primary Key
11	milestones	VARCHAR
12	evidences	VARCHAR
13	author_id	INTEGER
14	tag_path	VARCHAR
15	commit_id	VARCHAR

Table: tags

No	Column Name	Type	Notes
1	protected	BOOLEAN
2	project_id	INTEGER
3	release	VARCHAR
4	name	VARCHAR	Primary Key
5	message	VARCHAR
6	commit_id	VARCHAR
7	target	VARCHAR

Table: project_milestones

No	Column Name	Type	Notes
1	expired	BOOLEAN
2	updated_at	VARCHAR
3	web_url	VARCHAR
4	iid	INTEGER
5	project_id	INTEGER
6	due_date	VARCHAR
7	description	VARCHAR
8	created_at	VARCHAR
9	id	INTEGER	Primary Key
10	state	VARCHAR
11	title	VARCHAR
12	start_date	VARCHAR

Table: project_members

No	Column Name	Type	Notes
1	access_level	INTEGER
2	expires_at	VARCHAR
3	avatar_url	VARCHAR
4	web_url	VARCHAR
5	project_id	INTEGER
6	name	VARCHAR
7	created_at	VARCHAR
8	id	INTEGER	Primary Key
9	state	VARCHAR
10	username	VARCHAR

Table: pipelines

No	Column Name	Type	Notes
1	ref	VARCHAR
2	updated_at	VARCHAR	Incremental sync key
3	web_url	VARCHAR
4	project_id	INTEGER
5	created_at	VARCHAR
6	id	INTEGER	Primary Key
7	sha	VARCHAR
8	status	VARCHAR

Table: project_labels

No	Column Name	Type	Notes
1	color	VARCHAR
2	open_issues_count	INTEGER
3	description	VARCHAR
4	closed_issues_count	INTEGER
5	priority	INTEGER
6	is_project_label	BOOLEAN
7	subscribed	BOOLEAN
8	project_id	INTEGER
9	name	VARCHAR
10	open_merge_requests_count	INTEGER
11	id	INTEGER	Primary Key
12	description_html	VARCHAR
13	text_color	VARCHAR

Table: commits

No	Column Name	Type	Notes
1	author_name	VARCHAR
2	authored_date	VARCHAR
3	committer_email	VARCHAR
4	created_at	VARCHAR	Incremental sync key
5	short_id	VARCHAR
6	parent_ids	VARCHAR
7	title	VARCHAR
8	message	VARCHAR
9	committer_name	VARCHAR
10	trailers	VARCHAR
11	committed_date	VARCHAR
12	web_url	VARCHAR
13	project_id	INTEGER
14	stats	VARCHAR
15	author_email	VARCHAR
16	id	VARCHAR	Primary Key

Table: merge_request_commits

No	Column Name	Type	Notes
1	discussion_locked	BOOLEAN
2	upvotes	INTEGER
3	merge_when_pipeline_succeeds	BOOLEAN
4	references	VARCHAR
5	assignees	VARCHAR
6	merge_request_iid	INTEGER
7	changes_count	INTEGER
8	reference	VARCHAR
9	subscribed	BOOLEAN
10	squash	BOOLEAN
11	project_id	INTEGER
12	time_stats	VARCHAR
13	id	INTEGER	Primary Key
14	state	VARCHAR
15	closed_at	VARCHAR
16	work_in_progress	BOOLEAN
17	author	VARCHAR
18	merged_at	VARCHAR
19	target_branch	VARCHAR
20	downvotes	INTEGER
21	should_remove_source_branch	BOOLEAN
22	sha	VARCHAR
23	first_deployed_to_production_at	VARCHAR
24	labels	VARCHAR
25	user_notes_count	INTEGER
26	squash_commit_sha	VARCHAR
27	assignee	VARCHAR
28	task_completion_status	VARCHAR
29	approvals_before_merge	BOOLEAN
30	target_project_id	INTEGER
31	force_remove_source_branch	BOOLEAN
32	head_pipeline	VARCHAR
33	has_conflicts	BOOLEAN
34	iid	INTEGER
35	description	VARCHAR
36	created_at	VARCHAR
37	merged_by	VARCHAR
38	first_contribution	BOOLEAN
39	title	VARCHAR
40	latest_build_started_at	VARCHAR
41	closed_by	VARCHAR
42	source_branch	VARCHAR
43	updated_at	VARCHAR
44	merge_commit_sha	VARCHAR
45	blocking_discussions_resolved	BOOLEAN
46	merge_error	BOOLEAN
47	diff_refs	VARCHAR
48	source_project_id	INTEGER
49	reviewers	VARCHAR
50	pipeline	VARCHAR
51	milestone	VARCHAR
52	web_url	VARCHAR
53	merge_status	VARCHAR
54	latest_build_finished_at	VARCHAR
55	user	VARCHAR

Table: epic_issues

No	Column Name	Type	Notes
1	discussion_locked	BOOLEAN
2	upvotes	INTEGER
3	iid	INTEGER
4	_links	VARCHAR
5	milestone_id	INTEGER
6	description	VARCHAR
7	created_at	VARCHAR
8	assignees	VARCHAR
9	title	VARCHAR
10	epic_issue_id	INTEGER	Primary Key
11	updated_at	VARCHAR
12	project_id	INTEGER
13	time_stats	VARCHAR
14	id	INTEGER
15	state	VARCHAR
16	assignee_id	INTEGER
17	confidential	BOOLEAN
18	closed_at	VARCHAR
19	due_date	VARCHAR
20	weight	INTEGER
21	downvotes	INTEGER
22	labels	VARCHAR
23	web_url	VARCHAR
24	user_notes_count	INTEGER
25	author_id	INTEGER

Table: group_issue_boards

No	Column Name	Type	Notes
1	hide_backlog_list	BOOLEAN
2	group_id	INTEGER
3	lists	VARCHAR
4	name	VARCHAR
5	project	INTEGER
6	id	INTEGER	Primary Key
7	hide_closed_list	BOOLEAN

Table: pipelines_extended

No	Column Name	Type	Notes
1	coverage	DOUBLE
2	before_sha	VARCHAR
3	detailed_status	VARCHAR
4	finished_at	VARCHAR
5	created_at	VARCHAR
6	sha	VARCHAR
7	queued_duration	DOUBLE
8	yaml_errors	VARCHAR
9	duration	INTEGER
10	ref	VARCHAR
11	updated_at	VARCHAR
12	web_url	VARCHAR
13	project_id	INTEGER
14	committed_at	VARCHAR
15	started_at	VARCHAR
16	id	INTEGER	Primary Key
17	tag	BOOLEAN
18	user	VARCHAR
19	status	VARCHAR

External Resources

• Gitlab
• Personal Access Token
• Gitlab Account
• Group Issue Boards
• Project Milestones
• Project Merge Requests
• Group Milestones
• Group And Project Members
• Group Labels
• Project Labels
• Epic Issues
• Rate Limits

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.