GitHub Plugin documentation

Report an issue

Back to plugin list

Official

Premium

GitHub

The CloudQuery GitHub plugin extracts your GitHub API and loads it into any supported CloudQuery destination

Publisher

cloudquery

Latest version

v11.7.1

Type

Source

Platforms

Date Published

September 4, 2024

Price per 1M rows

Starting from $15

monthly free quota

1M rows

Documentation Tables Changelog Destinations

github_billing_action
github_billing_package
github_billing_storage
github_code_scanning_alerts
github_external_groups
github_hooks
- github_hook_deliveries
github_installations
github_issues
- github_issue_pullrequest_reviews
- github_issue_timeline_events
github_organizations
- github_organization_dependabot_alerts
- github_organization_members
- github_organization_dependabot_secrets
github_pull_requests
github_repositories
- github_repository_dependabot_alerts
- github_repository_branches
- github_repository_collaborators
- github_repository_custom_properties
- github_repository_keys
- github_releases
  - github_release_assets
- github_repository_sboms
- github_repository_dependabot_secrets
github_secret_scanning_alerts
github_teams
- github_team_members
- github_team_repositories
github_traffic_clones
github_traffic_paths
github_traffic_referrers
github_traffic_views
github_workflow_runs
- github_workflow_run_usage
- github_workflow_jobs
github_workflows

Github Issues

The github_issues table shows data for Github Issues.

Lists all issues in a repository, both open and closed. Pull requests are also included in the list of issues, and can be distinguished by the value in the is_pull_request column. This table can be used without the associated permissions if only public resources are requested. https://docs.github.com/rest/issues/issues#list-repository-issues

The composite primary key for this table is id, org, repository_id.

"Issues" repository permissions (read)

It supports incremental syncs based on the updated_at column.

Columns

Name	Type
active_lock_reason	`utf8`
assignee	`json`
assignees	`json`
author_association	`utf8`
body	`utf8`
closed_at	`timestamp[us, tz=UTC]`
closed_by	`json`
comments	`int64`
comments_url	`utf8`
_cq_id	`uuid`
_cq_parent_id	`uuid`
created_at	`timestamp[us, tz=UTC]`
draft	`bool`
events_url	`utf8`
html_url	`utf8`
id	`int64`
is_pull_request	`bool`
labels	`json`
labels_url	`utf8`
locked	`bool`
milestone	`json`
node_id	`utf8`
number	`int64`
org	`utf8`
pull_request	`json`
reactions	`json`
repository_id	`int64`
repository_url	`utf8`
state	`utf8`
state_reason	`utf8`
text_matches	`json`
title	`utf8`
updated_at	`timestamp[us, tz=UTC]`
url	`utf8`
user	`json`

Relations

The following tables depend on "Github Issues":

Github Issue Pullrequest Reviews Github Issue Timeline Events