GitHub НА ЭТОЙ СТРАНИЦЕ GitHub is a platform and cloud-based service for software development and version control using Git. You can use GitHub as a data source when landing or replicating data.
GitHub integration replicates data using the GitHub REST API v3 .
See the
Schema section for a list of objects available for replication.
Снимок функции Общий обзор этого коннектора, включая полезные ссылки и поддерживаемые функции.
Функция/возможность Сведения о поддержке Поддерживаемые проекты Qlik Talend Data Integration Только проекты репликации . Проекты конвейера данных не поддерживаются. Методы обновления целей
Задачи репликации:
Применить изменения
Сохранить изменения
Промежуточное хранение данных в озере данных:
Управление метаданными
Создание метаданных вручную не требуется. Эволюция схемы
Поддерживается только операция Изменить тип данных столбца . Репликация столбцов LOB (NCLOB, CLOB и BLOB) Не поддерживается. Запланированный CDC Требуется. Так целевой объект обновляется в соответствии с изменениями в источнике.
Для получения информации о задачах репликации см. раздел Планирование задач
Для получения информации о задачах промежуточного хранения в озере см. раздел Планирование CDC для задач промежуточного хранения в озере
Уведомления Частично поддерживается
Настройка уведомлений об изменениях в работе
Мониторинг Только CDC, так как полная загрузка для этого коннектора не актуальна.
Мониторинг индивидуальной задачи данных
Автоматическое извлечение вложенной полезной нагрузки столбцов JSON Не поддерживается. Вложенная полезная нагрузка столбцов JSON в исходных наборах данных не извлекается автоматически в цели.
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
Примечание к информации Убедитесь, что используемая учетная запись имеет доступ для чтения к таблицам, которые требуется получить.
Creating the connection Для получения дополнительной информации см. раздел Подключение к приложениям SaaS
Заполните необходимые свойства подключения. Заполните поле Имя подключения .
Установите флажок Открыть метаданные подключения , чтобы определить метаданные для подключения, когда оно будет создано.
Щелкните Создать .
Connection settings Setting Description Data gateway
Выберите шлюз Шлюз движения данных , если этого требует текущий сценарий использования.
Примечание к информации Это поле недоступно при использовании подписки Qlik Talend Cloud Starter , так как она не поддерживает Шлюз движения данных . Если используется другой уровень подписки или не требуется использовать Шлюз движения данных , выберите Нет .
Для получения информации о преимуществах Шлюз движения данных и о сценариях, требующих его использования, см. раздел Шлюз данных Qlik — движение данных
Start Date Введите дату в формате MM/DD/YYYY, начиная с которой данные должны реплицироваться из источника в цель.
Github Repository Name Github Repository Name Access token Access token.
Примечание к информации Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 2.
Depending on your destination, table and column names may not appear as they are outlined below.
assignees
The assignees table contains info about the available assignees for issues in the repositories specified for the integration.
assignees table schema
_sdc_repository
STRING
avatar_url
STRING
email
STRING
events_url
STRING
followers_url
STRING
following_url
STRING
gists_url
STRING
gravatar_id
STRING
html_url
STRING
id
INTEGER
login
STRING
name
STRING
node_id
STRING
organizations_url
STRING
received_events_url
STRING
repos_url
STRING
site_admin
BOOLEAN
starred_at
STRING
starred_url
STRING
subscriptions_url
STRING
type
STRING
url
STRING
collaborators
The collaborators table contains info about the users who contribute to the repositories specified for the integration.
For organization-owned repositories, this will include outside collaborators, organization owners, organization members that are direct collaborators, who have access through team memberships, or have access through default organization permissions.
collaborators table foreign keys Join collaborators with on pull_requests collaborators.id = pull_requests.user.id reviews collaborators.id = reviews.user.id
collaborators table schema
_sdc_repository
STRING
avatar_url
STRING
email
STRING
events_url
STRING
followers_url
STRING
following_url
STRING
gists_url
STRING
gravatar_id
STRING
html_url
STRING
id
INTEGER
login
STRING
name
STRING
node_id
STRING
organizations_url
STRING
permissions
OBJECT
This is a nested data structure:
admin: BOOLEAN maintain: BOOLEAN pull: BOOLEAN push: BOOLEAN triage: BOOLEAN
received_events_url
STRING
repos_url
STRING
role_name
STRING
site_admin
BOOLEAN
starred_url
STRING
subscriptions_url
STRING
type
STRING
url
STRING
The comments table contains info about comments made on issues in the repositories specified for the integration.
The commit_comments table contains info about the commit comments in the repositories specified for the integration.
Replication Method
CDC
Primary Key
id
Replication Key
updated_at
Useful links
GitHub API method
commits
The commits table contains info about repository commits in a project.
Replication Method
CDC
Primary Key
sha
Useful links
GitHub documentation
GitHub API method
commits table foreign keys Join commits with on issue_events commits.id = issue_events.commit_id reviews commits.id = reviews.commit_id review_comments commits.id = review_comments.commit_id commits.id = review_comments.original_commit_id events commits.sha = events.payload.commits.sha pr_commits commits.sha = pr_commits.sha
commits table schema
_sdc_repository
STRING
author
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
comments_url
STRING
commit
OBJECT
This is a nested data structure:
author: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING comment_count: INTEGER committer: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING message: STRING tree: OBJECT, which is also a nested data structure.
url: STRING
committer
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
html_url
STRING
id
STRING
node_id
STRING
parents
ARRAY
This is a nested data structure:
html_url: STRING sha: STRING url: STRING
pr_id
STRING
pr_number
INTEGER
sha
STRING
updated_at
DATE-TIME
url
STRING
events
The events table contains information about events in the repositories specified for the integration.
events table foreign keys Join events with on commits events.payload.commits.sha = commits.sha pr_commits events.payload.commits.sha = pr_commits.sha
events table schema
_sdc_repository
STRING
actor
OBJECT
This is a nested data structure:
avatar_url: STRING display_login: STRING gravatar_id: STRING id: STRING login: STRING url: STRING
created_at
STRING
distinct_size
NUMBER
head
STRING
id
NUMBER
org
OBJECT
This is a nested data structure:
avatar_url: STRING display_login: STRING gravatar_id: STRING id: STRING login: STRING url: STRING
payload
OBJECT
This is a nested data structure:
action: STRING before: STRING comment: OBJECT, STRING, which is also a nested data structure.
author_association: STRING body: STRING body_html: STRING body_text: STRING created_at: DATE-TIME html_url: STRING id: INTEGER issue_url: STRING node_id: STRING performed_via_github_app: OBJECT, which is also a nested data structure.
client_id: STRING client_secret: STRING created_at: DATE-TIME description: STRING events: ARRAY, which is also a nested data structure. external_url: STRING html_url: STRING id: INTEGER installations_count: INTEGER name: STRING node_id: STRING owner: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING pem: STRING permissions: OBJECT, which is also a nested data structure.
checks: STRING contents: STRING deployments: STRING issues: STRING metadata: STRING slug: STRING updated_at: DATE-TIME webhook_secret: STRING reactions: OBJECT, which is also a nested data structure.
+1: INTEGER -1: INTEGER confused: INTEGER eyes: INTEGER heart: INTEGER hooray: INTEGER laugh: INTEGER rocket: INTEGER total_count: INTEGER url: STRING updated_at: DATE-TIME url: STRING user: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING commits: ARRAY, which is also a nested data structure.
author: OBJECT, which is also a nested data structure.
email: STRING name: STRING distinct: BOOLEAN message: STRING sha: STRING url: STRING description: STRING issue: OBJECT, STRING, which is also a nested data structure.
body: STRING comments_url: STRING events_url: STRING html_url: STRING id: INTEGER labels: OBJECT, which is also a nested data structure.
active_lock_reason: STRING assignee: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING assignees: ARRAY, which is also a nested data structure. author_association: STRING body_html: STRING body_text: STRING closed_at: DATE-TIME closed_by: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING comments: INTEGER created_at: DATE-TIME draft: BOOLEAN items: OBJECT, which is also a nested data structure.
color: STRING default: BOOLEAN description: STRING id: INTEGER name: STRING node_id: STRING url: STRING locked: BOOLEAN milestone: OBJECT, which is also a nested data structure.
closed_at: DATE-TIME closed_issues: INTEGER created_at: DATE-TIME creator: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING description: STRING due_on: DATE-TIME html_url: STRING id: INTEGER labels_url: STRING node_id: STRING number: INTEGER open_issues: INTEGER state: STRING title: STRING updated_at: DATE-TIME url: STRING performed_via_github_app: OBJECT, which is also a nested data structure.
client_id: STRING client_secret: STRING created_at: DATE-TIME description: STRING events: ARRAY, which is also a nested data structure. external_url: STRING html_url: STRING id: INTEGER installations_count: INTEGER name: STRING node_id: STRING owner: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING pem: STRING permissions: OBJECT, which is also a nested data structure.
checks: STRING contents: STRING deployments: STRING issues: STRING metadata: STRING slug: STRING updated_at: DATE-TIME webhook_secret: STRING pull_request: OBJECT, which is also a nested data structure.
diff_url: STRING html_url: STRING merged_at: DATE-TIME patch_url: STRING url: STRING reactions: OBJECT, which is also a nested data structure.
+1: INTEGER -1: INTEGER confused: INTEGER eyes: INTEGER heart: INTEGER hooray: INTEGER laugh: INTEGER rocket: INTEGER total_count: INTEGER url: STRING repository: OBJECT, which is also a nested data structure. timeline_url: STRING updated_at: DATE-TIME labels_url: STRING node_id: STRING number: INTEGER repository_url: STRING state: STRING state_reason: STRING title: STRING url: STRING user: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING master_branch: STRING pages: ARRAY, which is also a nested data structure.
action: STRING html_url: STRING page_name: STRING sha: STRING summary: STRING title: STRING pusher_type: STRING ref: STRING ref_type: STRING
public
BOOLEAN
push_id
NUMBER
ref
STRING
repo
OBJECT
This is a nested data structure:
id: NUMBER name: STRING url: STRING
size
NUMBER
type
STRING
issue_events
The issue_events table contains info about issue events in the repositories specified for the integration.
issue_events table foreign keys Join issue_events with on commits issue_events.commit_id = commits.id reviews issue_events.commit_id = reviews.commit_id review_comments issue_events.commit_id = review_comments.commit_id issue_events.commit_id = review_comments.original_commit_id issues issue_events.id = issues.id pull_requests issue_events.id = pull_requests.id
issue_events table schema
_sdc_repository
STRING
actor
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
assignee
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
assigner
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
author_association
STRING
commit_id
STRING
commit_url
STRING
created_at
DATE-TIME
dismissed_review
OBJECT
This is a nested data structure:
dismissal_commit_id: STRING dismissal_message: STRING review_id: INTEGER state: STRING
draft
BOOLEAN
event
STRING
id
INTEGER
issue
OBJECT
This is a nested data structure:
active_lock_reason: STRING assignee: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING assignees: ARRAY, which is also a nested data structure. author_association: STRING body: STRING closed_at: DATE-TIME closed_by: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING comments: INTEGER comments_url: STRING created_at: DATE-TIME events_url: STRING html_url: STRING id: INTEGER labels: ARRAY, which is also a nested data structure.
color: STRING default: BOOLEAN description: STRING id: INTEGER name: STRING node_id: STRING url: STRING labels_url: STRING locked: BOOLEAN milestone: OBJECT, which is also a nested data structure.
closed_at: DATE-TIME closed_issues: INTEGER created_at: DATE-TIME creator: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING description: STRING due_on: DATE-TIME html_url: STRING id: INTEGER labels_url: STRING node_id: STRING number: INTEGER open_issues: INTEGER state: STRING title: STRING updated_at: DATE-TIME url: STRING node_id: STRING number: INTEGER performed_via_github_app: OBJECT, which is also a nested data structure.
client_id: STRING client_secret: STRING created_at: DATE-TIME description: STRING events: ARRAY, which is also a nested data structure. external_url: STRING html_url: STRING id: INTEGER installations_count: INTEGER name: STRING node_id: STRING owner: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING pem: STRING permissions: OBJECT, which is also a nested data structure.
checks: STRING contents: STRING deployments: STRING issues: STRING metadata: STRING slug: STRING updated_at: DATE-TIME webhook_secret: STRING pull_request: OBJECT, which is also a nested data structure.
diff_url: STRING html_url: STRING merged_at: DATE-TIME patch_url: STRING url: STRING reactions: OBJECT, which is also a nested data structure.
+1: INTEGER -1: INTEGER confused: INTEGER eyes: INTEGER heart: INTEGER hooray: INTEGER laugh: INTEGER rocket: INTEGER total_count: INTEGER url: STRING repository: OBJECT, which is also a nested data structure. repository_url: STRING state: STRING title: STRING updated_at: DATE-TIME url: STRING user: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
label
OBJECT
This is a nested data structure:
color: STRING name: STRING
lock_reason
STRING
milestone
OBJECT
This is a nested data structure:
node_id
STRING
performed_via_github_app
OBJECT
This is a nested data structure:
client_id: STRING client_secret: STRING created_at: DATE-TIME description: STRING events: ARRAY, which is also a nested data structure. external_url: STRING html_url: STRING id: INTEGER installations_count: INTEGER name: STRING node_id: STRING owner: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING pem: STRING permissions: OBJECT, which is also a nested data structure.
checks: STRING contents: STRING deployments: STRING issues: STRING metadata: STRING slug: STRING updated_at: DATE-TIME webhook_secret: STRING
project_card
OBJECT
This is a nested data structure:
column_name: STRING id: INTEGER previous_column_name: STRING project_id: INTEGER project_url: STRING url: STRING
rename
OBJECT
This is a nested data structure:
requested_reviewer
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
requested_team
OBJECT
This is a nested data structure:
description: STRING html_url: STRING id: INTEGER members_url: STRING name: STRING node_id: STRING parent: OBJECT, which is also a nested data structure.
description: STRING html_url: STRING id: INTEGER ldap_dn: STRING members_url: STRING name: STRING node_id: STRING permission: STRING privacy: STRING repositories_url: STRING slug: STRING url: STRING permission: STRING permissions: OBJECT, which is also a nested data structure.
admin: BOOLEAN maintain: BOOLEAN pull: BOOLEAN push: BOOLEAN triage: BOOLEAN privacy: STRING repositories_url: STRING slug: STRING url: STRING
review_requester
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
url
STRING
issue_labels
The issue_labels table contains info about issue labels in the repositories specified for the integration.
issue_labels table foreign keys Join issue_labels with on issues issue_labels.id = issues.labels.id pull_requests issue_labels.id = pull_requests.labels.id
issue_labels table schema
_sdc_repository
STRING
color
STRING
default
BOOLEAN
description
STRING
id
NUMBER
name
STRING
node_id
STRING
url
STRING
issue_milestones
The issue_milestones table contains info about issue milestones in the repositories specified for the integration.
issue_milestones table schema
_sdc_repository
STRING
closed_at
DATE-TIME
closed_issues
NUMBER
created_at
DATE-TIME
creator
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
description
STRING
due_on
DATE-TIME
html_url
STRING
id
NUMBER
labels_url
STRING
node_id
STRING
number
NUMBER
open_issues
NUMBER
state
STRING
title
STRING
updated_at
DATE-TIME
url
STRING
issues
The issues table contains info about issues in the repositories specified for the integration.
Issues and pull requests GitHub’s API considers every pull request an issue, but not every issue may be a pull request. Therefore, this table may contain both issues and pull requests.
issues table foreign keys issues table schema
_sdc_repository
STRING
active_lock_reason
STRING
assignee
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
assignees
ARRAY
This is a nested data structure.
author_association
STRING
body
STRING
body_html
STRING
body_text
STRING
closed_at
DATE-TIME
closed_by
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
comments
INTEGER
comments_url
STRING
created_at
DATE-TIME
draft
BOOLEAN
events_url
STRING
html_url
STRING
id
INTEGER
labels
ARRAY
This is a nested data structure:
color: STRING default: BOOLEAN description: STRING id: INTEGER name: STRING node_id: STRING url: STRING
labels_url
STRING
locked
BOOLEAN
milestone
OBJECT
This is a nested data structure:
closed_at: DATE-TIME closed_issues: INTEGER created_at: DATE-TIME creator: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING description: STRING due_on: DATE-TIME html_url: STRING id: INTEGER labels_url: STRING node_id: STRING number: INTEGER open_issues: INTEGER state: STRING title: STRING updated_at: DATE-TIME url: STRING
node_id
STRING
number
INTEGER
performed_via_github_app
OBJECT
This is a nested data structure:
client_id: STRING client_secret: STRING created_at: DATE-TIME description: STRING events: ARRAY, which is also a nested data structure. external_url: STRING html_url: STRING id: INTEGER installations_count: INTEGER name: STRING node_id: STRING owner: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING pem: STRING permissions: OBJECT, which is also a nested data structure.
checks: STRING contents: STRING deployments: STRING issues: STRING metadata: STRING slug: STRING updated_at: DATE-TIME webhook_secret: STRING
pull_request
OBJECT
This is a nested data structure:
diff_url: STRING html_url: STRING merged_at: DATE-TIME patch_url: STRING url: STRING
reactions
OBJECT
This is a nested data structure:
+1: INTEGER -1: INTEGER confused: INTEGER eyes: INTEGER heart: INTEGER hooray: INTEGER laugh: INTEGER rocket: INTEGER total_count: INTEGER url: STRING
repository_url
STRING
state
STRING
state_reason
STRING
timeline_url
STRING
title
STRING
updated_at
DATE-TIME
url
STRING
user
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
pr_commits
The pr_commits table contains info about pull request commits and is a slight variation of the commits
Replication Method
CDC
Primary Key
id
Useful links
pr_commits schema on GitHub
GitHub API method
pr_commits table foreign keys Join pr_commits with on issues pr_commits.pr_id = issues.id pull_requests pr_commits.pr_id = pull_requests.id commits pr_commits.sha = commits.sha events pr_commits.sha = events.payload.commits.sha
pr_commits table schema
_sdc_repository
STRING
author
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
comments_url
STRING
commit
OBJECT
This is a nested data structure:
author: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING comment_count: INTEGER committer: OBJECT, which is also a nested data structure.
date: DATE-TIME email: STRING login: STRING name: STRING message: STRING tree: OBJECT, which is also a nested data structure.
url: STRING verification: OBJECT, which is also a nested data structure.
payload: STRING reason: STRING signature: STRING verified: BOOLEAN
committer
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
html_url
STRING
id
STRING
node_id
STRING
parents
ARRAY
This is a nested data structure:
html_url: STRING sha: STRING url: STRING
pr_id
STRING
pr_number
INTEGER
sha
STRING
updated_at
DATE-TIME
url
STRING
project_cards
The project_cards table contains information about project cards in the repositories specified for the integration.
project_cards table schema
_sdc_repository
STRING
archived
BOOLEAN
cards_url
STRING
column_name
STRING
column_url
STRING
content_url
STRING
created_at
DATE-TIME
creator
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
id
NUMBER
name
STRING
node_id
STRING
note
STRING
project_id
STRING
project_url
STRING
updated_at
DATE-TIME
url
STRING
project_columns
The project_columns table contains info about the columns of projects in the repositories specified for the integration.
project_columns table schema
_sdc_repository
STRING
cards_url
STRING
created_at
DATE-TIME
id
NUMBER
name
STRING
node_id
STRING
project_url
STRING
updated_at
DATE-TIME
url
STRING
projects
The projects table contains info about projects in the repositories specified for the integration.
projects table schema
body
STRING
columns_url
STRING
created_at
DATE-TIME
creator
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
html_url
STRING
id
NUMBER
name
STRING
node_id
STRING
number
NUMBER
organization_permission
STRING
owner_url
STRING
private
BOOLEAN
state
STRING
updated_at
DATE-TIME
url
STRING
pull_requests
The pull_requests table contains info about pull requests made against the repositories specified for the integration.
pull_requests table foreign keys Join pull_requests with on collaborators pull_requests.user.id = collaborators.id reviews pull_requests.user.id = reviews.user.id issues pull_requests.id = issues.id pull_requests.labels.id = issues.labels.id issue_events pull_requests.id = issue_events.id issue_labels pull_requests.labels.id = issue_labels.id pr_commits pull_requests.id = pr_commits.pr_id
pull_requests table schema
_links
OBJECT
This is a nested data structure:
comments: OBJECT, which is also a nested data structure.
commits: OBJECT, which is also a nested data structure.
html: OBJECT, which is also a nested data structure.
issue: OBJECT, which is also a nested data structure.
review_comment: OBJECT, which is also a nested data structure.
review_comments: OBJECT, which is also a nested data structure.
self: OBJECT, which is also a nested data structure.
statuses: OBJECT, which is also a nested data structure.
_sdc_repository
STRING
active_lock_reason
STRING
assignee
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
assignees
ARRAY
This is a nested data structure.
author_association
STRING
auto_merge
OBJECT
This is a nested data structure:
commit_message: STRING commit_title: STRING enabled_by: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING merge_method: STRING
base
OBJECT
This is a nested data structure:
label: STRING ref: STRING repo: OBJECT, which is also a nested data structure. sha: STRING user: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
body
STRING
closed_at
DATE-TIME
comments_url
STRING
commits_url
STRING
created_at
DATE-TIME
diff_url
STRING
draft
BOOLEAN
head
OBJECT
This is a nested data structure:
label: STRING ref: STRING repo: OBJECT, which is also a nested data structure. sha: STRING user: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
html_url
STRING
id
STRING
issues_url
STRING
labels
ARRAY
This is a nested data structure:
color: STRING default: BOOLEAN description: STRING id: INTEGER name: STRING node_id: STRING url: STRING
locked
BOOLEAN
merge_commit_sha
STRING
merged_at
DATE-TIME
milestone
OBJECT
This is a nested data structure:
closed_at: DATE-TIME closed_issues: INTEGER created_at: DATE-TIME creator: OBJECT, which is also a nested data structure.
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING description: STRING due_on: DATE-TIME html_url: STRING id: INTEGER labels_url: STRING node_id: STRING number: INTEGER open_issues: INTEGER state: STRING title: STRING updated_at: DATE-TIME url: STRING
node_id
STRING
number
INTEGER
patch_url
STRING
requested_reviewers
ARRAY
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
requested_teams
ARRAY
This is a nested data structure:
description: STRING html_url: STRING id: INTEGER members_url: STRING name: STRING node_id: STRING parent: OBJECT, which is also a nested data structure.
description: STRING html_url: STRING id: INTEGER ldap_dn: STRING members_url: STRING name: STRING node_id: STRING permission: STRING privacy: STRING repositories_url: STRING slug: STRING url: STRING permission: STRING permissions: OBJECT, which is also a nested data structure.
admin: BOOLEAN maintain: BOOLEAN pull: BOOLEAN push: BOOLEAN triage: BOOLEAN privacy: STRING repositories_url: STRING slug: STRING url: STRING
review_comments_url
STRING
state
STRING
statuses_url
STRING
title
STRING
updated_at
DATE-TIME
url
STRING
user
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
releases
The releases table contains info about releases in the repositories specified for the integration.
Note : GitHub doesn’t include regular Git tags that haven’t been associated with a release.
releases table schema
_sdc_repository
STRING
assets
ARRAY
This is a nested data structure.
assets_url
STRING
author
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
body
STRING
body_html
STRING
body_text
STRING
created_at
DATE-TIME
discussion_url
STRING
draft
BOOLEAN
html_url
STRING
id
STRING
mentions_count
INTEGER
name
STRING
node_id
STRING
prerelease
BOOLEAN
published_at
DATE-TIME
reactions
OBJECT
This is a nested data structure:
+1: INTEGER -1: INTEGER confused: INTEGER eyes: INTEGER heart: INTEGER hooray: INTEGER laugh: INTEGER rocket: INTEGER total_count: INTEGER url: STRING
tag_name
STRING
tarball_url
STRING
target_commitish
STRING
upload_url
STRING
url
STRING
zipball_url
STRING
The review_comments table contains info about comments made on pull request reviews in the repositories specified for the integration.
reviews
The reviews table contains info about pull request reviews in the repositories specified for the integration. A pull request review is a group of comments on a pull request.
reviews table foreign keys Join reviews with on collaborators reviews.user.id = collaborators.id pull_requests reviews.user.id = pull_requests.user.id commits reviews.commit_id = commits.id issue_events reviews.commit_id = issue_events.commit_id review_comments reviews.commit_id = review_comments.commit_id reviews.commit_id = review_comments.original_commit_id reviews.id = review_comments.pull_request_review_id
reviews table schema
_links
OBJECT
This is a nested data structure:
html: OBJECT, which is also a nested data structure.
pull_request: OBJECT, which is also a nested data structure.
_sdc_repository
STRING
author_association
STRING
body
STRING
body_html
STRING
body_text
STRING
commit_id
STRING
html_url
STRING
id
INTEGER
node_id
STRING
pr_id
STRING
pull_request_url
STRING
state
STRING
submitted_at
DATE-TIME
user
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
stargazers
The stargazers table contains info about users who have starred the repositories specified for the integration.
stargazers table schema
_sdc_repository
STRING
starred_at
DATE-TIME
user
OBJECT
This is a nested data structure:
avatar_url: STRING email: STRING events_url: STRING followers_url: STRING following_url: STRING gists_url: STRING gravatar_id: STRING html_url: STRING id: INTEGER login: STRING name: STRING node_id: STRING organizations_url: STRING received_events_url: STRING repos_url: STRING site_admin: BOOLEAN starred_at: STRING starred_url: STRING subscriptions_url: STRING type: STRING url: STRING
user_id
INTEGER
team_members
The team_members table contains info about members of organization teams that are visible to the user who authorized the integration.
team_members table schema
_sdc_repository
STRING
avatar_url
STRING
email
STRING
events_url
STRING
followers_url
STRING
following_url
STRING
gists_url
STRING
gravatar_id
STRING
html_url
STRING
id
NUMBER
login
STRING
name
STRING
node_id
STRING
organizations_url
STRING
received_events_url
STRING
repos_url
STRING
site_admin
BOOLEAN
starred_at
STRING
starred_url
STRING
subscriptions_url
STRING
team_slug
STRING
type
STRING
url
STRING
team_memberships
The team_memberships table contains info about membership of users in of organization teams that are visible to the user who authorized the integration.
team_memberships table schema
_sdc_repository
STRING
login
STRING
role
STRING
state
STRING
url
STRING
teams
The teams table contains info about the teams in an organization. Only teams that are visible to the user who authorized the integration in Stitch will be replicated.
teams table schema
_sdc_repository
STRING
description
STRING
html_url
STRING
id
NUMBER
members_url
STRING
name
STRING
node_id
STRING
parent
OBJECT, STRING
This is a nested data structure.
permission
STRING
permissions
OBJECT
This is a nested data structure:
admin: BOOLEAN maintain: BOOLEAN pull: BOOLEAN push: BOOLEAN triage: BOOLEAN
privacy
STRING
repositories_url
STRING
slug
STRING
url
STRING
