Official

GitHub source integration documentation

Name: CloudQuery GitHub Integration
Author: CloudQuery

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

Publisher

cloudquery

Latest version

v17.1.0

Type

Source

Platforms

Date Published

Start Syncing View Platform setup guide

github_billing_advanced_security
github_billing_usage_report
github_code_scanning_alerts
github_copilot_billing
github_copilot_enterprise_usage_metrics
github_copilot_organization_metrics
github_copilot_organization_usage_metrics
github_copilot_organization_user_teams
github_copilot_organization_user_usage_metrics
github_copilot_seats
github_deployments
- github_deployment_statuses
github_enterprise_billing_advanced_security
github_enterprise_copilot_metrics
github_enterprise_runner_groups
github_enterprise_runners
github_environments
- github_environment_protection_rules
- github_deployment_branch_policies
github_external_groups
github_hooks
- github_hook_deliveries
github_installations
github_issues
- github_issue_pullrequest_reviews
- github_issue_timeline_events
github_organization_personal_access_token_requests
github_organization_roles
- github_organization_role_users
- github_organization_role_teams
github_organization_rulesets
github_organization_rule_suites
github_organization_runner_groups
github_organization_runners
github_organizations
- github_organization_dependabot_alerts
- github_organization_members
  - github_organization_memberships
- github_organization_dependabot_secrets
- github_organization_members_with_role
- github_organization_saml_identity_providers
- github_organization_saml_external_identities
github_pull_request_closing_issues_references
github_pull_requests
- github_pull_request_commits
- github_pull_request_reviews
github_repositories
- github_repository_dependabot_alerts
- github_repository_branches
- github_repository_collaborators
- github_repository_commits
- github_repository_first_commits
- github_repository_contributors
- github_repository_custom_properties
- github_repository_hooks
  - github_repository_hook_deliveries
- github_repository_keys
- github_repository_pages
- github_releases
  - github_release_assets
- github_repository_sboms
- github_repository_dependabot_secrets
github_repository_fork_pr_workflow_settings
github_repository_rulesets
github_repository_rule_suites
github_repository_runners
github_saml_identities
github_secret_scanning_alerts
github_teams
- github_team_members
  - github_team_memberships
- github_team_repositories
- github_copilot_team_metrics
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.

This table supports incremental syncing. Read more about incremental syncing here.

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

Table Options #

Milestone (string)
state (string) (default: all)
State filters issues based on their state. Possible values are: open, closed, all. Default is "open".
assignee (string)
Assignee filters issues based on their assignee. Possible values are a user name, "none" for issues that are not assigned, "*" for issues with any assigned user.
creator (string)
Creator filters issues based on their creator.
mentioned (string)
Mentioned filters issues to those mentioned a specific user.
labels ([]string)
Labels filters issues based on their label.
since (string)
Since filters issues by time in natural date format. Defaults to all issues. Examples: "14 days ago", "last month"

"Issues" repository permissions (read)

Primary Keys #

Name	Type
id	`int64`
org	`utf8`
repository_id	`int64`

Incremental Sync Keys #

Name	Type
updated_at	`timestamp[us, tz=UTC]`

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`
issue_dependencies_summary	`json`
issue_field_values	`json`
labels	`json`
labels_url	`utf8`
locked	`bool`
milestone	`json`
node_id	`utf8`
number	`int64`
org	`utf8`
parent_issue_url	`utf8`
performed_via_github_app	`json`
pinned_comment	`json`
pull_request	`json`
reactions	`json`
repository_id	`int64`
repository_url	`utf8`
state	`utf8`
state_reason	`utf8`
sub_issues_summary	`json`
text_matches	`json`
title	`utf8`
type	`json`
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

Loading plugin tables