Movatterモバイル変換

[0]ホーム
URL:

DOCS >INTEGRATIONS >SAAS >GITHUB (V2)
  1. version 2 (Latest)
  2. version 1 (Deprecated)

Get started with a free trial today

Already have an account? Sign in

GitHub (v2)

GitHub extraction is supported by Stitch
This integration is powered bySinger's GitHub tap and certified by Stitch.Check out and contribute to the repo on GitHub.

For support, contactSupport.

GitHub integration summary

Stitch’s GitHub integration replicates data using theGitHub REST API v3. Refer to theSchema section for a list of objects available for replication.

GitHub feature snapshot

A high-level look at Stitch's GitHub (v2) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status

Released on September 29, 2022

Supported by

Stitch

Stitch plan

Standard

API availability

Available

Singer GitHub repository

singer-io/tap-github

REPLICATION SETTINGS
Anchor Scheduling

Supported

Advanced Scheduling

Supported

Table-level reset

Unsupported

Configurable Replication Methods

Unsupported

DATA SELECTION
Table selection

Supported

Column selection

Supported

Select all

Supported

TRANSPARENCY
Extraction Logs

Supported

Loading Reports

Supported

Connecting GitHub

GitHub setup requirements

To set up GitHub in Stitch, you need:

  • Access to the projects you want to replicate data from. Stitch will only be able to access the same projects as the user who authorizes the connection in Stitch.

Step 1: Add GitHub as a Stitch data source

  1. Sign into your Stitch account.

  2. On the Stitch Dashboard page, click theAdd Integration button.

  3. Click theGitHub icon.

  4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

    For example, the name “Stitch GitHub” would create a schema calledstitch_github in the destination.Note: Schema names cannot be changed after you save the integration.

  5. In theBase Url field, enter the GitHub URL to use. This is required only if you are using a custom base URL, such ashttps://git.your-company.example.com. The default value ishttps://api.github.com.

  6. In theGitHub Repository Name field, enter the paths of the repositories you want to track. The path is relative to the base URL. For example: The path for the Stitch Docs repository isstitchdata/docs.

    • To track multiple repositories, enter a space delimited list of the repository paths. For example:stitchdata/docs stitchdata/docs-about-docs
    • To track all repositories in an organization, use* to replace the repository name in the path. For example:singer-io/*

Step 2: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your GitHub integration. This means that dataequal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond GitHub’s default setting of1 year. For a detailed look at historical replication jobs, check out theSyncing Historical SaaS Data guide.

Step 3: Create a replication schedule

Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to theReplication Scheduling documentation for more information.

In theReplication Frequency section, you’ll create the integration’sreplication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

GitHub integrations support the following replication scheduling methods:

To keep your row usage low, consider setting the integration to replicate less frequently. See theUnderstanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 4: Authorize Stitch to access GitHub

  1. Once you’ve configured the integration parameters, clickAuthorize. You will be prompted to grant Stitch access to your GitHub account.
  2. Sign in to GitHub.

  3. If you want to replicate data from private repositories, clickRequest next to the name of the relevant GitHub organization, then clickRequest approval from owners. The owners of the repository will then receive an email prompting them to approve or deny the request.

    Note: This step is not needed if you only want to access public repositories. Any public repository, even within your work organization, should be available without approval from the owners.

    GitHub authorization screen

  4. ClickAuthorize singer-bot.

Once the authorization process is completed, you will be redirected to Stitch. You will be able to start replicating data from public repositories. The extraction from private repositories will fail until the owner has approved the access request.

Initial and historical replication jobs

After you finish setting up GitHub, itsSync Status may show asPending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, aPending status indicates that Stitch is in the process of scheduling the initial replication job for the integration.This may take some time to complete.

Initial replication jobs with Anchor Scheduling

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to theAnchor Scheduling documentation for more information.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Replication will continue after the seven days are over. If you’re no longer interested in this source, be sure topause ordelete the integration to prevent unwanted usage.

GitHub table reference

Schemas and versioning

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is forversion 2 of this integration.

This is the latest version of the GitHub integration.

Table and column names in your destination

Depending on your destination, table and column names may not appear as they are outlined below.

For example: Object names are lowercased in Redshift (CusTomERs >customers), while case is maintained in PostgreSQL destinations (CusTomERs >CusTomERs). Refer to theLoading Guide for your destination for more info.

assignees

Theassignees table contains info about the available assignees for issues in the repositories specified for the integration.

Replication Method

Full Table

Primary Key

id

Useful links

GitHub documentation

assignees schema on GitHub

GitHub API method

_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

Thecollaborators 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.

Replication Method

Full Table

Primary Key

id

Useful links

collaborators schema on GitHub

GitHub API method

Join collaborators withon
pull_requests
collaborators.id = pull_requests.user.id
reviews
collaborators.id = reviews.user.id

_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

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

comments

Thecomments table contains info about comments made on issues in the repositories specified for the integration.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

GitHub documentation

comments schema on GitHub

GitHub API method

_sdc_repository

STRING

author_association

STRING

body

STRING

body_html

STRING

body_text

STRING

created_at

DATE-TIME

home_url

STRING

html_url

STRING

id

INTEGER

issue_url

STRING

node_id

STRING

performed_via_github_app

OBJECT

client_id

STRING

client_secret

STRING

created_at

DATE-TIME

description

STRING

events

ARRAY

external_url

STRING

html_url

STRING

id

INTEGER

installations_count

INTEGER

name

STRING

node_id

STRING

owner

OBJECT

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

checks

STRING

contents

STRING

deployments

STRING

issues

STRING

metadata

STRING

slug

STRING

updated_at

DATE-TIME

webhook_secret

STRING

reactions

OBJECT

+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

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

STRING

starred_at

STRING

starred_url

STRING

subscriptions_url

STRING

type

STRING

url

STRING

commit_comments

Thecommit_comments table contains info about the commit comments in the repositories specified for the integration.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updated_at

Useful links

commit_comments schema on GitHub

GitHub API method

author_association

STRING

body

STRING

commit_id

STRING

created_at

DATE-TIME

html_url

STRING

id

NUMBER

line

NUMBER

node_id

STRING

path

STRING

position

NUMBER

reactions

OBJECT

+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

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

type

STRING

url

STRING

commits

Thecommits table contains info about repository commits in a project.

Replication Method

Key-based Incremental

Primary Key

sha

Useful links

GitHub documentation

commits schema on GitHub

GitHub API method

Join commits withon
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

_sdc_repository

STRING

author

OBJECT

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

author

OBJECT

avatar_url

STRING

date

DATE-TIME

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

avatar_url

STRING

date

DATE-TIME

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

sha

STRING

url

STRING

url

STRING

committer

OBJECT

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

html_url

STRING

sha

STRING

url

STRING

pr_id

STRING

pr_number

INTEGER

sha

STRING

updated_at

DATE-TIME

url

STRING

events

Theevents table contains information about events in the repositories specified for the integration.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

GitHub documentation

events schema on GitHub

GitHub API method

Join events withon
commits
events.payload.commits.sha = commits.sha
pr_commits
events.payload.commits.sha = pr_commits.sha

_sdc_repository

STRING

actor

OBJECT

avatar_url

STRING

display_login

STRING

gravatar_id

STRING

id

NUMBER

login

STRING

url

STRING

created_at

STRING

distinct_size

NUMBER

head

STRING

id

NUMBER

org

OBJECT

avatar_url

STRING

display_login

STRING

gravatar_id

STRING

id

NUMBER

login

STRING

url

STRING

payload

OBJECT

action

STRING

before

STRING

comment

OBJECT, STRING

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

client_id

STRING

client_secret

STRING

created_at

DATE-TIME

description

STRING

events

ARRAY

external_url

STRING

html_url

STRING

id

INTEGER

installations_count

INTEGER

name

STRING

node_id

STRING

owner

OBJECT

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

checks

STRING

contents

STRING

deployments

STRING

issues

STRING

metadata

STRING

slug

STRING

updated_at

DATE-TIME

webhook_secret

STRING

reactions

OBJECT

+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

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

author

OBJECT

email

STRING

name

STRING

distinct

BOOLEAN

message

STRING

sha

STRING

url

STRING

description

STRING

issue

OBJECT, STRING

body

STRING

comments_url

STRING

events_url

STRING

html_url

STRING

id

INTEGER

labels

OBJECT

active_lock_reason

STRING

assignee

OBJECT

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

author_association

STRING

body_html

STRING

body_text

STRING

closed_at

DATE-TIME

closed_by

OBJECT

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

color

STRING

default

BOOLEAN

description

STRING

id

INTEGER

name

STRING

node_id

STRING

url

STRING

locked

BOOLEAN

milestone

OBJECT

closed_at

DATE-TIME

closed_issues

INTEGER

created_at

DATE-TIME

creator

OBJECT

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

client_id

STRING

client_secret

STRING

created_at

DATE-TIME

description

STRING

events

ARRAY

external_url

STRING

html_url

STRING

id

INTEGER

installations_count

INTEGER

name

STRING

node_id

STRING

owner

OBJECT

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

checks

STRING

contents

STRING

deployments

STRING

issues

STRING

metadata

STRING

slug

STRING

updated_at

DATE-TIME

webhook_secret

STRING

pull_request

OBJECT

diff_url

STRING

html_url

STRING

merged_at

DATE-TIME

patch_url

STRING

url

STRING

reactions

OBJECT

+1

INTEGER

-1

INTEGER

confused

INTEGER

eyes

INTEGER

heart

INTEGER

hooray

INTEGER

laugh

INTEGER

rocket

INTEGER

total_count

INTEGER

url

STRING

repository

OBJECT

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

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

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

id

NUMBER

name

STRING

url

STRING

size

NUMBER

type

STRING

issue_events

Theissue_events table contains info about issue events in the repositories specified for the integration.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

issue_events schema on GitHub

GitHub API method

Join issue_events withon
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

_sdc_repository

STRING

actor

OBJECT

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

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

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

dismissal_commit_id

STRING

dismissal_message

STRING

review_id

INTEGER

state

STRING

draft

BOOLEAN

event

STRING

id

INTEGER

issue

OBJECT

active_lock_reason

STRING

assignee

OBJECT

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

author_association

STRING

body

STRING

closed_at

DATE-TIME

closed_by

OBJECT

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

color

STRING

default

BOOLEAN

description

STRING

id

INTEGER

name

STRING

node_id

STRING

url

STRING

labels_url

STRING

locked

BOOLEAN

milestone

OBJECT

closed_at

DATE-TIME

closed_issues

INTEGER

created_at

DATE-TIME

creator

OBJECT

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

client_id

STRING

client_secret

STRING

created_at

DATE-TIME

description

STRING

events

ARRAY

external_url

STRING

html_url

STRING

id

INTEGER

installations_count

INTEGER

name

STRING

node_id

STRING

owner

OBJECT

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

checks

STRING

contents

STRING

deployments

STRING

issues

STRING

metadata

STRING

slug

STRING

updated_at

DATE-TIME

webhook_secret

STRING

pull_request

OBJECT

diff_url

STRING

html_url

STRING

merged_at

DATE-TIME

patch_url

STRING

url

STRING

reactions

OBJECT

+1

INTEGER

-1

INTEGER

confused

INTEGER

eyes

INTEGER

heart

INTEGER

hooray

INTEGER

laugh

INTEGER

rocket

INTEGER

total_count

INTEGER

url

STRING

repository

OBJECT

repository_url

STRING

state

STRING

title

STRING

updated_at

DATE-TIME

url

STRING

user

OBJECT

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

color

STRING

name

STRING

lock_reason

STRING

milestone

OBJECT

node_id

STRING

performed_via_github_app

OBJECT

client_id

STRING

client_secret

STRING

created_at

DATE-TIME

description

STRING

events

ARRAY

external_url

STRING

html_url

STRING

id

INTEGER

installations_count

INTEGER

name

STRING

node_id

STRING

owner

OBJECT

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

checks

STRING

contents

STRING

deployments

STRING

issues

STRING

metadata

STRING

slug

STRING

updated_at

DATE-TIME

webhook_secret

STRING

project_card

OBJECT

column_name

STRING

id

INTEGER

previous_column_name

STRING

project_id

INTEGER

project_url

STRING

url

STRING

rename

OBJECT

from

STRING

to

STRING

requested_reviewer

OBJECT

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

description

STRING

html_url

STRING

id

INTEGER

members_url

STRING

name

STRING

node_id

STRING

parent

OBJECT

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

admin

BOOLEAN

maintain

BOOLEAN

pull

BOOLEAN

push

BOOLEAN

triage

BOOLEAN

privacy

STRING

repositories_url

STRING

slug

STRING

url

STRING

review_requester

OBJECT

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

Theissue_labels table contains info about issue labels in the repositories specified for the integration.

Replication Method

Full Table

Primary Key

id

Useful links

issue_labels schema on GitHub

GitHub API method

Join issue_labels withon
issues
issue_labels.id = issues.labels.id
pull_requests
issue_labels.id = pull_requests.labels.id

_sdc_repository

STRING

color

STRING

default

BOOLEAN

description

STRING

id

NUMBER

name

STRING

node_id

STRING

url

STRING

issue_milestones

Theissue_milestones table contains info about issue milestones in the repositories specified for the integration.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

issue_milestones schema on GitHub

GitHub API method

_sdc_repository

STRING

closed_at

DATE-TIME

closed_issues

NUMBER

created_at

DATE-TIME

creator

OBJECT

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

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

Theissues 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.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

GitHub documentation

issues schema on GitHub

GitHub API method

Join issues withon
issue_events
issues.id = issue_events.id
pull_requests
issues.id = pull_requests.id
issues.labels.id = pull_requests.labels.id
issue_labels
issues.labels.id = issue_labels.id
pr_commits
issues.id = pr_commits.pr_id

_sdc_repository

STRING

active_lock_reason

STRING

assignee

OBJECT

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

author_association

STRING

body

STRING

body_html

STRING

body_text

STRING

closed_at

DATE-TIME

closed_by

OBJECT

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

color

STRING

default

BOOLEAN

description

STRING

id

INTEGER

name

STRING

node_id

STRING

url

STRING

labels_url

STRING

locked

BOOLEAN

milestone

OBJECT

closed_at

DATE-TIME

closed_issues

INTEGER

created_at

DATE-TIME

creator

OBJECT

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

client_id

STRING

client_secret

STRING

created_at

DATE-TIME

description

STRING

events

ARRAY

external_url

STRING

html_url

STRING

id

INTEGER

installations_count

INTEGER

name

STRING

node_id

STRING

owner

OBJECT

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

checks

STRING

contents

STRING

deployments

STRING

issues

STRING

metadata

STRING

slug

STRING

updated_at

DATE-TIME

webhook_secret

STRING

pull_request

OBJECT

diff_url

STRING

html_url

STRING

merged_at

DATE-TIME

patch_url

STRING

url

STRING

reactions

OBJECT

+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

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

Thepr_commits table contains info about pull request commits and is a slight variation of thecommits table. This allows you to associate commits to pull requests that are squash merged.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

pr_commits schema on GitHub

GitHub API method

Join pr_commits withon
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

_sdc_repository

STRING

author

OBJECT

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

author

OBJECT

avatar_url

STRING

date

DATE-TIME

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

date

DATE-TIME

email

STRING

login

STRING

name

STRING

message

STRING

tree

OBJECT

sha

STRING

url

STRING

url

STRING

verification

OBJECT

payload

STRING

reason

STRING

signature

STRING

verified

BOOLEAN

committer

OBJECT

avatar_url

STRING

date

DATE-TIME

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

html_url

STRING

sha

STRING

url

STRING

pr_id

STRING

pr_number

INTEGER

sha

STRING

updated_at

DATE-TIME

url

STRING

project_cards

Theproject_cards table contains information about project cards in the repositories specified for the integration.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

GitHub documentation

project_cards schema on GitHub

GitHub API method

_sdc_repository

STRING

archived

BOOLEAN

cards_url

STRING

column_name

STRING

column_url

STRING

content_url

STRING

created_at

DATE-TIME

creator

OBJECT

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

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

Theproject_columns table contains info about the columns of projects in the repositories specified for the integration.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

project_columns schema on GitHub

GitHub API method

_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

Theprojects table contains info about projects in the repositories specified for the integration.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

projects schema on GitHub

GitHub API method

body

STRING

columns_url

STRING

created_at

DATE-TIME

creator

OBJECT

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

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

Thepull_requests table contains info about pull requests made against the repositories specified for the integration.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

GitHub documentation

pull_requests schema on GitHub

GitHub API method

Join pull_requests withon
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

_links

OBJECT

comments

OBJECT

commits

OBJECT

html

OBJECT

issue

OBJECT

review_comment

OBJECT

review_comments

OBJECT

self

OBJECT

statuses

OBJECT

_sdc_repository

STRING

active_lock_reason

STRING

assignee

OBJECT

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

author_association

STRING

auto_merge

OBJECT

commit_message

STRING

commit_title

STRING

enabled_by

OBJECT

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

label

STRING

ref

STRING

repo

OBJECT

sha

STRING

user

OBJECT

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

label

STRING

ref

STRING

repo

OBJECT

sha

STRING

user

OBJECT

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

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

closed_at

DATE-TIME

closed_issues

INTEGER

created_at

DATE-TIME

creator

OBJECT

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

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

description

STRING

html_url

STRING

id

INTEGER

members_url

STRING

name

STRING

node_id

STRING

parent

OBJECT

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

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

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

Thereleases 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.

Replication Method

Full Table

Primary Key

id

Useful links

releases schema on GitHub

GitHub API method

_sdc_repository

STRING

assets

ARRAY

assets_url

STRING

author

OBJECT

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

+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

review_comments

Thereview_comments table contains info about comments made on pull request reviews in the repositories specified for the integration.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

review_comments schema on GitHub

GitHub API method

Join review_comments withon
commits
review_comments.commit_id = commits.id
review_comments.original_commit_id = commits.id
issue_events
review_comments.commit_id = issue_events.commit_id
review_comments.original_commit_id = issue_events.commit_id
reviews
review_comments.commit_id = reviews.commit_id
review_comments.original_commit_id = reviews.commit_id
review_comments.pull_request_review_id = reviews.id

_links

OBJECT

html

OBJECT

pull_request

OBJECT

self

OBJECT

_sdc_repository

STRING

assignee

STRING

assignees

STRING

author_association

STRING

base

STRING

body

STRING

body_html

STRING

body_text

STRING

comments_url

STRING

commit_id

STRING

commits_url

STRING

created_at

DATE-TIME

diff_hunk

STRING

diff_url

STRING

head

STRING

html_url

STRING

id

INTEGER

in_reply_to_id

INTEGER

issue_url

STRING

labels

STRING

line

INTEGER

locked

STRING

merge_commit_sha

STRING

milestone

STRING

node_id

STRING

original_commit_id

STRING

original_line

INTEGER

original_position

INTEGER

original_start_line

INTEGER

patch_url

STRING

path

STRING

position

INTEGER

pr_id

STRING

pull_request_review_id

INTEGER

pull_request_url

STRING

reactions

OBJECT

+1

INTEGER

-1

INTEGER

confused

INTEGER

eyes

INTEGER

heart

INTEGER

hooray

INTEGER

laugh

INTEGER

rocket

INTEGER

total_count

INTEGER

url

STRING

requested_reviewers

STRING

requested_teams

STRING

review_comment_url

STRING

review_comments_url

STRING

side

STRING

start_line

INTEGER

start_side

STRING

statuses_url

STRING

updated_at

DATE-TIME

url

STRING

user

OBJECT

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

reviews

Thereviews 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.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

GitHub documentation

reviews schema on GitHub

GitHub API method

Join reviews withon
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

_links

OBJECT

html

OBJECT

pull_request

OBJECT

_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

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

Thestargazers table contains info about users who have starred the repositories specified for the integration.

Replication Method

Full Table

Primary Key

user_id

Useful links

stargazers schema on GitHub

GitHub API method

_sdc_repository

STRING

starred_at

DATE-TIME

user

OBJECT

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

Theteam_members table contains info about members of organization teams that are visible to the user who authorized the integration.

Replication Method

Full Table

Primary Key

id

Useful links

team_members schema on GitHub

GitHub API method

_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

Theteam_memberships table contains info about membership of users in of organization teams that are visible to the user who authorized the integration.

Replication Method

Full Table

Primary Key

url

Useful links

team_memberships schema on GitHub

GitHub API method

_sdc_repository

STRING

login

STRING

role

STRING

state

STRING

url

STRING

teams

Theteams 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.

Replication Method

Full Table

Primary Key

id

Useful links

teams schema on GitHub

GitHub API method

_sdc_repository

STRING

description

STRING

html_url

STRING

id

NUMBER

members_url

STRING

name

STRING

node_id

STRING

parent

OBJECT, STRING

permission

STRING

permissions

OBJECT

admin

BOOLEAN

maintain

BOOLEAN

pull

BOOLEAN

push

BOOLEAN

triage

BOOLEAN

privacy

STRING

repositories_url

STRING

slug

STRING

url

STRING

RelatedTroubleshooting
Questions? Feedback?

Did this article help? If you have questions or feedback, feel free tosubmit a pull request with your suggestions,open an issue on GitHub, orreach out to us.

[8]ページ先頭
©2009-2026 Movatter.jp