This page provides a guide to Establishing a Connection to GitHub in CData Cloud, as well as information on the available resources, and a reference to the available connection properties.

Connecting to GitHub

Establishing a Connection shows how to authenticate to GitHub and configure any necessary connection properties to create a database in CData Cloud

Accessing Data from CData Cloud Services

Accessing data from GitHub through the available standard services and CData Cloud administration is documented in further details in the CData Cloud Documentation.

Connect to GitHub by selecting the corresponding icon in the Database tab. Required properties are listed under Settings. The Advanced tab lists connection properties that are not typically required.

Connecting to GitHub

To authenticate to GitHub you must connect using OAuth authentication.

When To Create a Custom OAuth Application

CData embeds OAuth Application Credentials with CData branding that can be used when connecting via a . You may choose to use your own OAuth Application Credentials when you want to

• control branding of the Authentication Dialog
• control the redirect URI that the application redirects the user to after the user authenticates
• customize the permissions that you are requesting from the user

Follow the steps below to create a custom OAuth application and obtain the connection properties in a specific OAuth authentication flow.

Create a Custom OAuth App

Follow the procedure below to obtain the OAuthClientId, OAuthClientSecret, and CallbackURL connection properties.

1. After logging in to your GitHub account, click your profile photo and then click Settings.
2. Click Developer Settings > OAuth Apps.
3. Click Register a New Application.
4. Enter the application name, homepage URL, and application description.
5. Set the callback URL:
   • For desktop applications, use http://localhost:33333 or another port number of your choice. When you connect, you must set the CallbackURL to this exact value.
6. Click Register Application.
7. Return to your OAuth apps. The client Id ( OAuthClientId) and its client secret (OAuthClientSecret) are located there.

Customizing the SSL Configuration

By default, the Cloud attempts to negotiate SSL/TLS by checking the server's certificate against the system's trusted certificate store.

To specify another certificate, see the SSLServerCert property for the available formats to do so.

Connecting Through a Firewall or Proxy

HTTP Proxies

To connect through the Windows system proxy, you do not need to set any additional connection properties. To connect to other proxies, set ProxyAutoDetect to false.

In addition, to authenticate to an HTTP proxy, set ProxyAuthScheme, ProxyUser, and ProxyPassword, in addition to ProxyServer and ProxyPort.

Other Proxies

Set the following properties:

• To use a proxy-based firewall, set FirewallType, FirewallServer, and FirewallPort.
• To tunnel the connection, set FirewallType to TUNNEL.
• To authenticate, specify FirewallUser and FirewallPassword.
• To authenticate to a SOCKS proxy, additionally set FirewallType to SOCKS5.

The CData Cloud models entities in the GitHub API as views and stored procedures. These are defined in schema files, which are simple, text-based configuration files.

The Cloud exposes three kinds of schemas:

Information Schema

The Information schema contains tables that expose licensing information and high-level overviews of the projects and repositories associated with the authenticated account. There is only one Information schema.

See Information Data Model for the available entities.

Repository Schemas

The Cloud exposes a schema for each repository in the authenticated user or organization's account.

See Repository Data Model for the available entities.

Project Schemas

The Cloud exposes a schema for each project in the authenticated user or organization's account.

See Project Data Model for the available entities.

Note: The Cloud does not read from classic projects, due their deprecation in the GitHub API.

Overview

In this schema, the Cloud models licensing information and high-level overviews of the organizations, projects, and repositories associated with the authenticated account as read-only views.

Key Features

• The Cloud models GitHub entities as relational views, allowing you to write SQL to query GitHub data.
• Stored procedures allow you to execute operations to GitHub.
• Live connectivity to these objects means any changes to your account are immediately reflected when using the Cloud.

Views

Views are read-only tables that expose GitHub entities like licenses, organizations, and organization teams, as well as high-level information about projects and repositories tied to the authenticated account.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They are used to perform functions such as getting the currently authenticated user or retrieving and refreshing OAuth access tokens.

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData Cloud - GitHub Views

Name	Description
Enterprises	A list of enterprises that the user belongs to.
LicenseConditions	The conditions set by the specified license.
LicenseLimitations	The limitations set by the specified license.
LicensePermissions	The permissions set by the specified license.
Licenses	Lists known open source licenses in GitHub.
OrganizationMannequins	Lists information about the mannequins of the logged in user's organizations or the mannequins of the specified organization.
OrganizationMembers	Lists information about the users of the logged in user's organizations or the teams of the specified organization.
Organizations	Lists information about the organizations of the logged in user, the specified user, or the specified organization.
OrganizationTeams	Lists information about the teams of the logged in user's organizations or the teams of the specified organization.
Projects	Lists information about the projects of the logged in user, a specific user or a specific organization.
Repositories	Lists information about a user's or organization's repositories.

A list of enterprises that the user belongs to.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• Slug supports the '=' comparison operator.
• MembershipType supports the '=' comparison operator.
• Login supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM [Information].[Enterprises] WHERE [Information].[Enterprises].[Slug] = 'test-enterprise'
SELECT * FROM [Information].[Enterprises] WHERE [Information].[Enterprises].[MembershipType] = 'ADMIN'
SELECT * FROM [Information].[Enterprises] WHERE [Information].[Enterprises].[Login] = 'test'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID of the Enterprise object.
UserId	String			The ID of the User object.
Location	String			The location of the enterprise.
Name	String			The name of the enterprise.
DatabaseId	Int			Identifies the primary key from the database.
Announcement	String			The text of the announcement.
AnnouncementExpiresAt	Datetime			The expiration date of the announcement, if any.
AnnouncementUserDismissible	Bool			Whether the announcement can be dismissed by the user.
BillingEmail	String			The enterprise's billing email.
BillingInfoAllLicensableUsersCount	Int			The number of licenseable users/emails across the enterprise.
BillingInfoAssetPacks	Int			The number of data packs used by all organizations owned by the enterprise.
BillingInfoBandwidthQuota	Double			The bandwidth quota in GB for all organizations owned by the enterprise.
BillingInfoBandwidthUsage	Double			The bandwidth usage in GB for all organizations owned by the enterprise.
BillingInfoBandwidthUsagePercentage	Int			The bandwidth usage as a percentage of the bandwidth quota.
BillingInfoStorageQuota	Double			The storage quota in GB for all organizations owned by the enterprise.
BillingInfoStorageUsage	Double			The storage usage in GB for all organizations owned by the enterprise.
BillingInfoStorageUsagePercentage	Int			The storage usage as a percentage of the storage quota.
BillingInfoTotalAvailableLicenses	Int			The number of available licenses across all owned organizations based on the unique number of billable users.
BillingInfoTotalLicenses	Int			The total number of licenses allocated.
CreatedAt	Datetime			Identifies the date and time when the object was created.
Description	String			The description of the enterprise.
DescriptionHTML	String			The description of the enterprise as HTML.
OwnerInfoOidcProviderId	String			The ID of the OIDCProvider object.
OwnerInfoOidcProviderTenantId	String			The ID of the tenant this provider is attached to.
OwnerInfoSamlIdentityProviderId	String			The ID of the EnterpriseIdentityProvider object.
ResourcePath	String			The HTTP path for this enterprise.
Slug	String			The URL-friendly identifier for the enterprise.
Url	String			The HTTP URL for this enterprise.
ViewerIsAdmin	Bool			Is the current viewer an admin of this enterprise?
WebsiteUrl	String			The URL of the enterprise website.
MembershipType	String			Filter enterprises returned based on the user's membership type.
Login	String			The user's login.

The conditions set by the specified license.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• LicenseKey supports the '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM [Information].[LicenseConditions] WHERE [Information].[LicenseConditions].[LicenseKey] = 'EXAMPLE'

Columns

Name	Type	References	OrderBySupport	Description
Key [KEY]	String			The machine-readable condition key.
LicenseKey [KEY]	String	Licenses.Key		The lowercased SPDX ID of the license.
Description	String			A description of the condition.
Label	String			The human-readable condition label.

The limitations set by the specified license.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• LicenseKey supports the '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM [Information].[LicenseLimitations] WHERE [Information].[LicenseLimitations].[LicenseKey] = 'EXAMPLE'

Columns

Name	Type	References	OrderBySupport	Description
Key [KEY]	String			The machine-readable limitation key.
LicenseKey [KEY]	String	Licenses.Key		The lowercased SPDX ID of the license.
Description	String			A description of the limitation.
Label	String			The human-readable limitation label.

The permissions set by the specified license.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• LicenseKey supports the '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM [Information].[LicensePermissions] WHERE [Information].[LicensePermissions].[LicenseKey] = 'EXAMPLE'

Columns

Name	Type	References	OrderBySupport	Description
Key [KEY]	String			The machine-readable permission key.
LicenseKey [KEY]	String	Licenses.Key		The lowercased SPDX ID of the license.
Description	String			A description of the permission.
Label	String			The human-readable permission label.

Lists known open source licenses in GitHub.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• Key supports the '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM [Information].[Licenses] WHERE [Information].[Licenses].[Key] = 'EXAMPLE'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID of the license.
Key	String			The lowercased SPDX ID of the license.
SpdxId	String			Short identifier specified by https://spdx.org/licenses.
Name	String			The license full name specified by https://spdx.org/licenses.
Nickname	String			Customary short name if applicable (e.g, GPLv3).
Body	String			The full text of the license.
Description	String			A human-readable description of the license.
Featured	Bool			Whether the license should be featured.
Implementation	String			Instructions on how to implement the license.
Url	String			URL to the license on https://choosealicense.com.
PseudoLicense	Bool			Whether the license is a pseudo-license placeholder (e.g., other, no-license).
Hidden	Bool			Whether the license should be displayed in license pickers.

Lists information about the mannequins of the logged in user's organizations or the mannequins of the specified organization.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• OrganizationLogin supports the '=' comparison operator.

The Cloud uses the GitHub API to process ORDER BY clause conditions built with the following column. The Cloud processes ordering by other columns client-side within the Cloud.

• Login
• CreatedAt

For example, the following query is processed server side:

SELECT * FROM [Information].[OrganizationMannequins] WHERE [Information].[OrganizationMannequins].[OrganizationLogin] = 'EXAMPLE'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID for this mannequin.
DatabaseId	Int			Identifies the primary key from the database.
OrganizationLogin	String	Organizations.Login		The organization's login.
Login	String		True	The username of the actor.
Email	String			The mannequin's email on the source instance.
Url	String			The URL to this resource.
ResourcePath	String			The HTML path to this resource.
CreatedAt	Datetime		True	Identifies the date and time when the object was created.
UpdatedAt	Datetime			Identifies the date and time when the object was last updated.
ClaimantId	String			The ID of the claimant.
ClaimantLogin	String			The username used to login.

Lists information about the users of the logged in user's organizations or the teams of the specified organization.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• OrganizationLogin supports the '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM [Information].[OrganizationMembers] WHERE [Information].[OrganizationMembers].[OrganizationLogin] = 'EXAMPLE'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID of the user.
DatabaseId	Int			Identifies the primary key from the database.
Login	String			The username used to login.
Name	String			The user's public profile name.
Email	String			The user's publicly visible profile email.
TwitterUsername	String			The user's Twitter username.
Pronouns	String			The user's profile pronouns.
Bio	String			The user's public profile bio.
BioHTML	String			The user's public profile bio as HTML.
Company	String			The user's public profile company.
CompanyHTML	String			The user's public profile company as HTML.
Location	String			The user's public profile location.
AnyPinnableItems	Bool			Determine if this repository owner has any items that can be pinned to their profile. Arguments type (PinnableItemType) Filter to only a particular kind of pinnable item.
PinnedItemsRemaining	Int			Returns how many more items this profile owner can pin to their profile.
ItemShowcaseHasPinnedItems	Bool			Whether or not the owner has pinned any repositories or gists.
IsEmployee	Bool			Whether or not this user is a GitHub employee.
IsHireable	Bool			Whether or not the user has marked themselves as for hire.
IsBountyHunter	Bool			Whether or not this user is a participant in the GitHub Security Bug Bounty.
IsCampusExpert	Bool			Whether or not this user is a participant in the GitHub Campus Experts Program.
IsFollowingViewer	Bool			Whether or not this user is following the viewer. Inverse of viewerIsFollowing.
IsSiteAdmin	Bool			Whether or not this user is a site administrator.
IsDeveloperProgramMember	Bool			Whether or not this user is a GitHub Developer Program member.
IsGitHubStar	Bool			Whether or not this user is a member of the GitHub Stars Program.
IsSponsoringViewer	Bool			True if the viewer is sponsored by this user/organization.
IsViewer	Bool			Whether or not this user is the viewing user.
ViewerCanFollow	Bool			Whether or not the viewer is able to follow the user.
ViewerCanSponsor	Bool			Whether or not the viewer is able to sponsor this user/organization.
ViewerIsFollowing	Bool			Whether or not this user is followed by the viewer.
ViewerIsSponsoring	Bool			True if the viewer is sponsoring this user/organization.
ViewerCanCreateProjects	Bool			Whether the current viewer can create new projects on this owner.
ViewerCanChangePinnedItems	Bool			Whether the viewer can pin repositories and gists to the profile.
StatusId	String			The emoji's id.
StatusEmoji	String			An emoji summarizing the user's status.
StatusMessage	String			A brief message describing what the user is doing.
StatusIndicatesLimitedAvailability	Bool			Whether this status indicates the user is not fully available on GitHub.
StatusEmojiHTML	String			The status emoji as HTML.
StatusCreatedAt	Datetime			Identifies the date and time when the object was created.
StatusExpiresAt	Datetime			If set, the status will not be shown after this date.
StatusUpdatedAt	Datetime			Identifies the date and time when the object was last updated.
StatusOrganizationId	String			The organization's id.
StatusOrganizationLogin	String			The organization's login name.
InteractionAbilityLimit	String			The current limit that is enabled on this object.
InteractionAbilityOrigin	String			The origin of the currently active interaction limit.
InteractionAbilityExpiresAt	Datetime			The time the currently active limit expires.
HasSponsorsListing	Bool			True if this user/organization has a GitHub Sponsors listing.
MonthlyEstimatedSponsorsIncomeInCents	Int			The estimated monthly GitHub Sponsors income for this user/organization in cents (USD).
EstimatedNextSponsorsPayoutInCents	Int			The estimated next GitHub Sponsors payout for this user/organization in cents (USD).
SponsorsListingId	String			The listing's id.
SponsorsListingName	String			The listing's full name.
TotalSponsorshipAmountAsSponsorInCents	Int			The amount in US cents that this entity has spent on GitHub to fund sponsorships. Only returns a value when viewed by the user themselves or by a user who can manage sponsorships for the requested organization.
ResourcePath	String			The HTTP path for this user.
ProjectsResourcePath	String			The HTTP path listing user's projects.
Url	String			The HTTP URL for this user.
ProjectsUrl	String			The HTTP URL listing user's projects.
WebsiteUrl	String			A URL pointing to the user's public website/blog.
AvatarUrl	String			A URL pointing to the user's public avatar. Arguments size (Int) The size of the resulting square image.
CreatedAt	Datetime			Identifies the date and time when the object was created.
UpdatedAt	Datetime			Identifies the date and time when the object was last updated.
RepositoryCount	Int			The number of repositories that a user owns.
FollowerCount	Int			The number of followers that a user has.
Role	String			The role of this user has in the organization.
HasTwoFactorEnabled	Bool			Whether the organization member has two factor enabled or not. Returns null if information is not available to viewer.
OrganizationLogin [KEY]	String	Organizations.Login		The organization's login name.

Lists information about the organizations of the logged in user, the specified user, or the specified organization.

View-Specific Information

By default this view will only return information about the organizations of the logged in user.

Specific columns require the authenticated user to be an owner of the organization to retrieve data. These columns include WebCommitSignoffRequired, IpAllowListEnabledSetting, RequiresTwoFactorAuthentication, MembersCanForkPrivateRepositories, NotificationDeliveryRestrictionEnabledSetting and IpAllowListForInstalledAppsEnabledSetting.

Data access to third-parties is limited if an organization has enabled OAuth App access restrictions.

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• Login supports the '=' comparison operator.
• MemberLogin supports the '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM [Information].[Organizations] WHERE [Information].[Organizations].[Login] = 'OrganizationLogin'
SELECT * FROM [Information].[Organizations] WHERE [Information].[Organizations].[MemberLogin] = 'UserLogin'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The id of the organization.
DatabaseId	Int			Identifies the primary key from the database.
Login	String			The organization's login name.
Name	String			The organization's public profile name.
TwitterUsername	String			The organization's Twitter username.
Description	String			The organization's public profile description.
DescriptionHTML	String			The organization's public profile description rendered to HTML.
Email	String			The organization's public email.
OrganizationBillingEmail	String			The billing email for the organization.
Location	String			The organization's public profile location.
AnyPinnableItems	Bool			Determine if this repository owner has any items that can be pinned to their profile. Arguments type (PinnableItemType) Filter to only a particular kind of pinnable item.
PinnedItemsRemaining	Int			Returns how many more items this profile owner can pin to their profile.
WebCommitSignoffRequired	Bool			Whether contributors are required to sign off on web-based commits for repositories in this organization.
MembersCanForkPrivateRepositories	Bool			Members can fork private repositories in this organization.
IpAllowListEnabledSetting	String			The setting value for whether the organization has an IP allow list enabled.
NotificationDeliveryRestrictionEnabledSetting	String			Indicates if email notification delivery for this organization is restricted to verified or approved domains.
IpAllowListForInstalledAppsEnabledSetting	String			The setting value for whether the organization has IP allow list configuration for installed GitHub Apps enabled.
Announcement	String			The text of the announcement.
AnnouncementUserDismissible	Bool			Whether the announcement can be dismissed by the user.
AnnouncementExpiresAt	Datetime			The expiration date of the announcement, if any.
CreatedAt	Datetime			Identifies the date and time when the object was created.
UpdatedAt	Datetime			Identifies the date and time when the object was last updated.
ArchivedAt	Datetime			Identifies the date and time when the object was archived.
ResourcePath	String			The HTTP path for this organization.
ProjectsResourcePath	String			The HTTP path listing organization's projects.
TeamsResourcePath	String			The HTTP path listing organization's teams.
NewTeamResourcePath	String			The HTTP path creating a new team.
Url	String			The HTTP URL for this organization.
AvatarUrl	String			A URL pointing to the organization's public avatar. Arguments size (Int) The size of the resulting square image.
ProjectsUrl	String			The HTTP URL listing organization's projects.
WebsiteUrl	String			The organization's public profile URL.
TeamsUrl	String			The HTTP URL listing organization's teams.
NewTeamUrl	String			The HTTP URL creating a new team.
IsVerified	Bool			Whether the organization has verified its profile email and website.
IsSponsoringViewer	Bool			True if the viewer is sponsored by this user/organization.
ViewerCanAdminister	Bool			Organization is adminable by the viewer.
ViewerCanSponsor	Bool			Whether or not the viewer is able to sponsor this user/organization.
ViewerIsFollowing	Bool			Whether or not this Organization is followed by the viewer.
ViewerIsSponsoring	Bool			True if the viewer is sponsoring this user/organization.
ViewerCanCreateProjects	Bool			Can the current viewer create new projects on this owner?
ViewerCanCreateRepositories	Bool			Viewer can create repositories on this organization.
ViewerCanCreateTeams	Bool			Viewer can create teams on this organization.
ViewerIsAMember	Bool			Viewer is an active member of this organization.
ViewerCanChangePinnedItems	Bool			Can the viewer pin repositories and gists to the profile?
InteractionAbilityLimit	String			The current limit that is enabled on this object.
InteractionAbilityOrigin	String			The origin of the currently active interaction limit.
InteractionAbilityExpiresAt	Datetime			The time the currently active limit expires.
ItemShowcaseHasPinnedItems	Bool			Whether or not the owner has pinned any repositories or gists.
RequiresTwoFactorAuthentication	Bool			When true the organization requires all members, billing managers, and outside collaborators to enable two-factor authentication.
SamlIdentityProviderId	String			The ID for the SAML Identity Provider.
SamlIdentityProviderIssuer	String			The Issuer Entity ID for the SAML Identity Provider.
SamlIdentityProviderDigestMethod	String			The digest algorithm used to sign SAML requests for the Identity Provider.
SamlIdentityProviderIdpCertificate	String			The x509 certificate used by the Identity Provider to sign assertions and responses.
SamlIdentityProviderSignatureMethod	String			The signature algorithm used to sign SAML requests for the Identity Provider.
SamlIdentityProviderSsoUrl	String			The URL endpoint for the Identity Provider's SAML SSO.
HasSponsorsListing	Bool			True if this user/organization has a GitHub Sponsors listing.
SponsorsListingId	String			The listing's id.
SponsorsListingName	String			The listing's full name.
EstimatedNextSponsorsPayoutInCents	Int			The estimated next GitHub Sponsors payout for this user/organization in cents (USD).
MonthlyEstimatedSponsorsIncomeInCents	Int			The estimated monthly GitHub Sponsors income for this user/organization in cents (USD).
MemberLogin	String			Filter organizations based on having a specific member by that user's login.

Lists information about the teams of the logged in user's organizations or the teams of the specified organization.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• OrganizationLogin supports the '=' comparison operator.
• Privacy supports the '=' comparison operator.
• Slug supports the '=' comparison operator.
• NotificationSetting supports the '=' comparison operator.
• LdapMapped supports the '=' comparison operator.
• Role supports the '=' comparison operator.
• RootTeamsOnly supports the '=' comparison operator.
• UserLogins supports the '=, IN' comparison operators.

The Cloud uses the GitHub API to process ORDER BY clause conditions built with the following column. The Cloud processes ordering by other columns client-side within the Cloud.

• Name

For example, the following queries are processed server side:

SELECT * FROM [Information].[OrganizationTeams] WHERE [Information].[OrganizationTeams].[OrganizationLogin] = 'EXAMPLE'

SELECT * FROM [Information].[OrganizationTeams] WHERE [Information].[OrganizationTeams].[Privacy] = 'EXAMPLE'

SELECT * FROM [Information].[OrganizationTeams] WHERE [Information].[OrganizationTeams].[Slug] = 'EXAMPLE'

SELECT * FROM [Information].[OrganizationTeams] WHERE [Information].[OrganizationTeams].[NotificationSetting] = 'EXAMPLE'

SELECT * FROM [Information].[OrganizationTeams] WHERE [Information].[OrganizationTeams].[LdapMapped] = 'true'

SELECT * FROM [Information].[OrganizationTeams] WHERE [Information].[OrganizationTeams].[Role] = 'EXAMPLE'

SELECT * FROM [Information].[OrganizationTeams] WHERE [Information].[OrganizationTeams].[RootTeamsOnly] = 'true'

SELECT * FROM [Information].[OrganizationTeams] WHERE [Information].[OrganizationTeams].[UserLogins] = 'EXAMPLE'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID of the team.
DatabaseId	Int			Identifies the primary key from the database.
OrganizationId	String	Organizations.Id		The ID of the organization.
OrganizationLogin	String	Organizations.Login		The organization's login name.
Name	String		True	The name of the team.
Description	String			The description of the team.
Privacy	String			The level of privacy the team has.
Slug	String			The slug corresponding to the team.
Url	String			The HTTP URL for this team.
CombinedSlug	String			The slug corresponding to the organization and team.
DiscussionsUrl	String			The HTTP URL for team discussions.
MembersUrl	String			The HTTP URL for the team' members.
NotificationSetting	String			The notification setting that the team has set.
RepositoriesUrl	String			The HTTP URL for this team's repositories.
ResourcePath	String			The HTTP path for this team.
TeamsUrl	String			The HTTP URL for this team's teams.
ViewerSubscription	String			Identifies if the viewer is watching, not watching, or ignoring the subscribable entity.
DiscussionsResourcePath	String			The HTTP path for team discussions.
EditTeamUrl	String			The HTTP URL for editing this team.
MembersResourcePath	String			The HTTP path for the team' members.
NewTeamUrl	String			The HTTP URL creating a new team.
RepositoriesResourcePath	String			The HTTP path for this team's repositories.
TeamsResourcePath	String			The HTTP path for this team's teams.
ViewerCanAdminister	Bool			Team is adminable by the viewer.
ViewerCanSubscribe	Bool			Check if the viewer is able to change their subscription status for the repository.
EditTeamResourcePath	String			The HTTP path for editing this team.
NewTeamResourcePath	String			The HTTP path creating a new team.
CreatedAt	Datetime			Identifies the date and time when the object was created.
UpdatedAt	Datetime			Identifies the date and time when the object was last updated.
LdapMapped	Bool			If true, filters teams that are mapped to an LDAP Group (Enterprise only).
Role	String			If non-null, filters teams according to whether the viewer is an admin or member on team.
RootTeamsOnly	Bool			If true, restrict to only root teams.
UserLogins	String			User logins to filter by.

Lists information about the projects of the logged in user, a specific user or a specific organization.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• OwnerLogin supports the '=' comparison operator.
• Number supports the '=' comparison operator.

The Cloud uses the GitHub API to process ORDER BY clause conditions built with the following column. The Cloud processes ordering by other columns client-side within the Cloud.

• Number
• Title
• UpdatedAt
• CreatedAt

For example, the following queries are processed server side:

SELECT * FROM [Information].[Projects] WHERE [Information].[Projects].[OwnerLogin] = 'EXAMPLE'

SELECT * FROM [Information].[Projects] WHERE [Information].[Projects].[Number] = '100'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The project ID.
OwnerLogin	String			The login of the owner of the project.
Number	Int		True	The project's number.
DatabaseId	Int			Identifies the primary key from the database.
Title	String		True	The project's name.
ShortDescription	String			The project's short description.
Readme	String			The project's readme.
Creator	String			The actor's login name who originally created the project.
Public	Bool			Returns true if the project is public.
Template	Bool			Returns true if this project is a template.
Closed	Bool			Returns true if the project is closed.
ViewerCanClose	Bool			Indicates if the object can be closed by the viewer.
ViewerCanReopen	Bool			Indicates if the object can be reopened by the viewer.
ViewerCanUpdate	Bool			Check if the current viewer can update this object.
ResourcePath	String			The HTTP path for this project.
Url	String			The HTTP URL for this project.
UpdatedAt	Datetime		True	Identifies the date and time when the object was last updated.
ClosedAt	Datetime			Identifies the date and time when the object was closed.
CreatedAt	Datetime		True	Identifies the date and time when the object was created.

Lists information about a user's or organization's repositories.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• Name supports the '=, !=' comparison operators.
• OwnerLogin supports the '=' comparison operator.
• DiskUsage supports the '=, >, >=, <, <=' comparison operators.
• ForkCount supports the '=, >, >=, <, <=' comparison operators.
• StargazerCount supports the '=, >, >=, <, <=' comparison operators.
• TopicCount supports the '=, >, >=, <, <=' comparison operators.
• IsArchived supports the '=' comparison operator.
• IsFork supports the '=' comparison operator.
• IsMirror supports the '=' comparison operator.
• IsPrivate supports the '=' comparison operator.
• LicenseKey supports the '=, !=' comparison operators.
• LanguageName supports the '=, !=' comparison operators.
• PushedAt supports the '=, >, >=, <, <=' comparison operators.
• CreatedAt supports the '=, >, >=, <, <=' comparison operators.

The Cloud uses the GitHub API to process ORDER BY clause conditions built with the following column. The Cloud processes ordering by other columns client-side within the Cloud.

• UpdatedAt

For example, the following queries are processed server side:

SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[Name] = 'EXAMPLE'

SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[OwnerLogin] = 'EXAMPLE'

SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[DiskUsage] = '100'

SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[ForkCount] = '100'

SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[StargazerCount] = '100'

SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[TopicCount] = '100'

SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[IsArchived] = 'true'

SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[IsFork] = 'true'

SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[IsMirror] = 'true'

SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[IsPrivate] = 'true'

SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[LicenseKey] = 'EXAMPLE'

SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[LanguageName] = 'EXAMPLE'

SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[PushedAt] = '2000-01-01 01:00:00.0'

SELECT * FROM [Information].[Repositories] WHERE [Information].[Repositories].[CreatedAt] = '2000-01-01 01:00:00.0'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID of the repository.
DatabaseId	Int			Identifies the primary key from the database.
Name	String			The name of the repository.
NameWithOwner	String			The repository's name with owner.
OwnerId	String			The repository's owner ID.
OwnerLogin	String			The login field of a user or organization.
Visibility	String			Indicates the repository's visibility level.
DiskUsage	Int			The number of kilobytes this repository occupies on disk.
ForkCount	Int			Returns how many forks there are of this repository in the whole network.
StargazerCount	Int			Returns a count of how many stargazers there are on this object.
WatcherCount	Int			The number of watchers in a repository.
TopicCount	Int			The number of topics that have been applied to the repository.
TempCloneToken	String			Temporary authentication token for cloning this repository.
WebCommitSignoffRequired	Bool			Whether contributors are required to sign off on web-based commits in this repository.
UsesCustomOpenGraphImage	Bool			Whether this repository has a custom image to use with Open Graph as opposed to being represented by the owner's avatar.
Description	String			The description of the repository.
DescriptionHTML	String			The description of the repository rendered to HTML.
ShortDescriptionHTML	String			A description of the repository, rendered to HTML without any links in it.
ResourcePath	String			The HTTP path for this repository.
ProjectsResourcePath	String			The HTTP path listing the repository's projects.
Url	String			The HTTP URL for this repository.
HomepageUrl	String			The repository's URL.
MirrorUrl	String			The repository's original mirror URL.
ProjectsUrl	String			The HTTP URL listing the repository's projects.
SecurityPolicyUrl	String			The security policy URL.
SSHUrl	String			The SSH URL to clone this repository.
OpenGraphImageUrl	String			The image used to represent this repository in Open Graph data.
MergeCommitTitle	String			How the default commit title will be generated when merging a pull request.
MergeCommitMessage	String			How the default commit message will be generated when merging a pull request.
SquashMergeCommitTitle	String			How the default commit title will be generated when squash merging a pull request.
SquashMergeCommitMessage	String			How the default commit message will be generated when squash merging a pull request.
DeleteBranchOnMerge	Bool			Whether or not branches are automatically deleted when merged in this repository.
HasDiscussionsEnabled	Bool			Indicates if the repository has the Discussions feature enabled.
HasIssuesEnabled	Bool			Indicates if the repository has issues feature enabled.
HasProjectsEnabled	Bool			Indicates if the repository has the Projects feature enabled.
HasWikiEnabled	Bool			Indicates if the repository has wiki feature enabled.
HasVulnerabilityAlertsEnabled	Bool			Whether vulnerability alerts are enabled for the repository.
HasSponsorshipsEnabled	Bool			Indicates if the repository displays a Sponsor button for financial contributions.
IsInOrganization	Bool			Indicates if a repository is either owned by an organization, or is a private fork of an organization repository.
IsBlankIssuesEnabled	Bool			Returns true if blank issue creation is allowed.
IsSecurityPolicyEnabled	Bool			Returns true if this repository has a security policy.
IsUserConfigurationRepository	Bool			Is this repository a user configuration repository?
IsArchived	Bool			Indicates if the repository is unmaintained.
IsDisabled	Bool			Returns whether or not this repository disabled.
IsEmpty	Bool			Returns whether or not this repository is empty.
IsFork	Bool			Identifies if the repository is a fork.
IsLocked	Bool			Indicates if the repository has been locked or not.
IsMirror	Bool			Identifies if the repository is a mirror.
IsPrivate	Bool			Identifies if the repository is private.
IsTemplate	Bool			Identifies if the repository is a template that can be used to generate new repositories.
LockReason	String			The reason the repository has been locked.
TemplateRepositoryId	String			The ID of the repository from which this repository was generated, if any.
ParentId	String			The repository parent ID, if this is a fork.
ForkingAllowed	Bool			Whether this repository allows forks.
AutoMergeAllowed	Bool			Whether or not Auto-merge can be enabled on pull requests in this repository.
SquashMergeAllowed	Bool			Whether or not squash-merging is enabled on this repository.
RebaseMergeAllowed	Bool			Whether or not rebase-merging is enabled on this repository.
MergeCommitAllowed	Bool			Whether or not PRs are merged with a merge commit on this repository.
AllowUpdateBranch	Bool			Whether or not a pull request head branch that is behind its base branch can always be updated even if it is not required to be up to date before merging.
ViewerPermission	String			The users permission level on the repository. Will return null if authenticated as an GitHub App.
ViewerSubscription	String			Identifies if the viewer is watching, not watching, or ignoring the subscribable entity.
ViewerHasStarred	Bool			Returns a boolean indicating whether the viewing user has starred this starrable.
ViewerDefaultCommitEmail	String			The last commit email for the viewer.
ViewerDefaultMergeMethod	String			The last used merge method by the viewer or the default for the repository.
ViewerPossibleCommitEmails	String			A list of emails this viewer can commit with.
ViewerCanAdminister	Bool			Indicates whether the viewer has admin permissions on this repository.
ViewerCanSubscribe	Bool			Check if the viewer is able to change their subscription status for the repository.
ViewerCanCreateProjects	Bool			Can the current viewer create new projects on this owner?
ViewerCanUpdateTopics	Bool			Indicates whether the viewer can update the topics of this repository.
CodeOfConductId	String			The ID of the Code of Conduct.
CodeOfConductName	String			The formal name of the Code of Conduct.
CodeOfConductBody	String			The body of the Code of Conduct.
CodeOfConductKey	String			The key for the Code of Conduct.
CodeOfConductUrl	String			The HTTP URL for this Code of Conduct.
CodeOfConductResourcePath	String			The HTTP path for this Code of Conduct.
DefaultBranchRefId	String			The ref id.
DefaultBranchRefName	String			The ref name.
InteractionAbilityLimit	String			The current limit that is enabled on this object.
InteractionAbilityOrigin	String			The origin of the currently active interaction limit.
InteractionAbilityExpiresAt	Datetime			The time the currently active limit expires.
LatestReleaseId	String			The ID of the release.
LatestReleaseName	String			The title of the release.
LicenseId	String			The ID of the license associated with the repository.
LicenseKey	String	Licenses.Key		The key of the license associated with the repository.
LanguageId	String			The ID of the current primary language.
LanguageName	String			The name defined for the current language.
LanguageColor	String			The color defined for the current language.
PushedAt	Datetime			Identifies when the repository was last pushed to.
ArchivedAt	Datetime			Identifies the date and time when the repository was archived.
CreatedAt	Datetime			Identifies the date and time when the object was created.
UpdatedAt	Datetime		True	Identifies the date and time when the object was last updated.

Stored procedures are function-like interfaces that extend the functionality of the Cloud beyond simple SELECT operations with GitHub.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from GitHub, along with an indication of whether the procedure succeeded or failed.

CData Cloud - GitHub Stored Procedures

Name	Description
GetCurrentlyAuthenticatedUser	Retrieves information about the currently authenticated user.

Retrieves information about the currently authenticated user.

Result Set Columns

Name	Type	Description
Id	String	The user ID.
Login	String	The username used to login.
Bio	String	The user's public profile bio.
BioHTML	String	The user's public profile bio as HTMl.
AvatarUrl	String	A URL pointing to the user's public avatar.
Name	String	The user's public profile name.
Company	String	The user's public profile company.
CompanyHTML	String	The user's public profile company as HTML.
CreatedAt	Datetime	Identifies the date and time when the object was created.
Email	String	The user's publicly visible profile email.
IsBountyHunter	Bool	Whether or not this user is a participant in the GitHub Security Bug Bounty.
IsCampusExpert	Bool	Whether or not this user is a participant in the GitHub Campus Experts Program.
IsDeveloperProgramMember	Bool	Whether or not this user is a GitHub Developer Program member.
IsEmployee	Bool	Whether or not this user is a GitHub employee.
IsHireable	Bool	Whether or not the user has marked themselves as for hire.
IsSiteAdmin	Bool	Whether or not this user is a site administrator.
IsViewer	Bool	Whether or not this user is the viewing user.
Location	String	The user's public profile location.
PinnedItemsRemaining	Integer	Returns how many more items this profile owner can pin to their profile.
ProjectsUrl	String	The HTTP URL listing user's projects.
ResourcePath	String	The HTTP path for this user.
TwitterUsername	String	The user's Twitter username.
UpdatedAt	Datetime	Identifies the date and time when the object was last updated.
URL	String	The HTTP URL for this user.
ViewerCanChangePinnedItems	Bool	Can the viewer pin repositories and gists to the profile?
ViewerCanCreateProjects	Bool	Can the current viewer create new projects on this owner?
ViewerCanFollow	Bool	Whether or not the viewer is able to follow the user.
ViewerIsFollowing	Bool	Whether or not this user is followed by the viewer.
WebsiteUrl	String	A URL pointing to the user's public website/blog.

Overview

The Cloud models each repository associated with the authenticated account as a schema.

Key Features

• The Cloud models GitHub entities as relational views, allowing you to write SQL to query GitHub data.
• Stored procedures allow you to execute operations to GitHub.
• Live connectivity to these objects means any changes to your account are immediately reflected when using the Cloud.

Views

Views are read-only tables that expose GitHub entities like pull requests, issues, and commits.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They are used to perform functions such as retrieving and refreshing OAuth access tokens.

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData Cloud - GitHub Views

Name	Description
AssignableUsers	Lists information about the users that can be assigned to issues in this repository.
Branches	Lists information about branches in a repository.
Collaborators	A list of collaborators associated with the repository.
CommitComments	Lists information about comments which were made on a specific commit.
Commits	Lists information about commits done in a repository .
Forks	Lists information about forks of a repository.
IssueAssignees	Lists information about the users assigned to the repository's issues.
IssueComments	Lists information about comments which were made on a specific issue.
Issues	Lists all project issues.
Labels	Lists information about the different labels you can apply on an issue.
MentionableUsers	Lists information about the users that can be mentioned in the context of the repository.
MergeQueueEntries	Lists information about the different entries on an merge queue.
MergeQueues	Lists information about the different labels you can apply on an issue.
Milestones	Lists information about milestones in a repository.
PullRequestComments	Lists information about comments which were made on a specific pull request.
PullRequestReviewComments	Lists information about comments which were made on a pull request review.
PullRequestReviews	Lists information about pull request reviews in a repository.
PullRequests	Lists information about pull requests in a repository.
ReleaseAssets	List of releases assets which are dependent on a release.
Releases	Lists information about the different releases of a repository.
Stargazers	Lists information about the users who have starred this repository.
Topics	A list of applied repository-topic associations for this repository.
Watchers	A list of users watching the repository.

Lists information about the users that can be assigned to issues in this repository.

View-Specific Information

Select

The Cloud processes filters client-side within the Cloud.

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID of the user.
DatabaseId	Int			Identifies the primary key from the database.
Login	String			The username used to login.
Name	String			The user's public profile name.
Email	String			The user's publicly visible profile email.
TwitterUsername	String			The user's Twitter username.
Pronouns	String			The user's profile pronouns.
Bio	String			The user's public profile bio.
BioHTML	String			The user's public profile bio as HTML.
Company	String			The user's public profile company.
CompanyHTML	String			The user's public profile company as HTML.
Location	String			The user's public profile location.
AnyPinnableItems	Bool			Determine if this repository owner has any items that can be pinned to their profile. Arguments type (PinnableItemType) Filter to only a particular kind of pinnable item.
PinnedItemsRemaining	Int			Returns how many more items this profile owner can pin to their profile.
ItemShowcaseHasPinnedItems	Bool			Whether or not the owner has pinned any repositories or gists.
IsEmployee	Bool			Whether or not this user is a GitHub employee.
IsHireable	Bool			Whether or not the user has marked themselves as for hire.
IsBountyHunter	Bool			Whether or not this user is a participant in the GitHub Security Bug Bounty.
IsCampusExpert	Bool			Whether or not this user is a participant in the GitHub Campus Experts Program.
IsFollowingViewer	Bool			Whether or not this user is following the viewer. Inverse of viewerIsFollowing.
IsSiteAdmin	Bool			Whether or not this user is a site administrator.
IsDeveloperProgramMember	Bool			Whether or not this user is a GitHub Developer Program member.
IsGitHubStar	Bool			Whether or not this user is a member of the GitHub Stars Program.
IsSponsoringViewer	Bool			True if the viewer is sponsored by this user/organization.
IsViewer	Bool			Whether or not this user is the viewing user.
ViewerCanFollow	Bool			Whether or not the viewer is able to follow the user.
ViewerCanSponsor	Bool			Whether or not the viewer is able to sponsor this user/organization.
ViewerIsFollowing	Bool			Whether or not this user is followed by the viewer.
ViewerIsSponsoring	Bool			True if the viewer is sponsoring this user/organization.
ViewerCanCreateProjects	Bool			Can the current viewer create new projects on this owner?
ViewerCanChangePinnedItems	Bool			Can the viewer pin repositories and gists to the profile?
StatusId	String			The emoji's id.
StatusEmoji	String			An emoji summarizing the user's status.
StatusMessage	String			A brief message describing what the user is doing.
StatusIndicatesLimitedAvailability	Bool			Whether this status indicates the user is not fully available on GitHub.
StatusEmojiHTML	String			The status emoji as HTML.
StatusCreatedAt	Datetime			Identifies the date and time when the object was created.
StatusExpiresAt	Datetime			If set, the status will not be shown after this date.
StatusUpdatedAt	Datetime			Identifies the date and time when the object was last updated.
StatusOrganizationId	String			The organization's id.
StatusOrganizationLogin	String			The organization's login name.
InteractionAbilityLimit	String			The current limit that is enabled on this object.
InteractionAbilityOrigin	String			The origin of the currently active interaction limit.
InteractionAbilityExpiresAt	Datetime			The time the currently active limit expires.
HasSponsorsListing	Bool			True if this user/organization has a GitHub Sponsors listing.
MonthlyEstimatedSponsorsIncomeInCents	Int			The estimated monthly GitHub Sponsors income for this user/organization in cents (USD).
EstimatedNextSponsorsPayoutInCents	Int			The estimated next GitHub Sponsors payout for this user/organization in cents (USD).
SponsorsListingId	String			The listing's id.
SponsorsListingName	String			The listing's full name.
TotalSponsorshipAmountAsSponsorInCents	Int			The amount in US cents that this entity has spent on GitHub to fund sponsorships. Only returns a value when viewed by the user themselves or by a user who can manage sponsorships for the requested organization.
ResourcePath	String			The HTTP path for this user.
ProjectsResourcePath	String			The HTTP path listing user's projects.
Url	String			The HTTP URL for this user.
ProjectsUrl	String			The HTTP URL listing user's projects.
WebsiteUrl	String			A URL pointing to the user's public website/blog.
AvatarUrl	String			A URL pointing to the user's public avatar. Arguments size (Int) The size of the resulting square image.
CreatedAt	Datetime			Identifies the date and time when the object was created.
UpdatedAt	Datetime			Identifies the date and time when the object was last updated.
RepositoryCount	Int			The number of repositories that a user owns.
FollowerCount	Int			The number of followers that a user has.

Lists information about branches in a repository.

View-Specific Information

Select

The Cloud processes filters client-side within the Cloud.

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID of the branch.
Name	String			The branch name.
Prefix	String			The branch prefix.

A list of collaborators associated with the repository.

View-Specific Information

Select

The Cloud processes filters client-side within the Cloud.

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID of the user.
DatabaseId	Int			Identifies the primary key from the database.
Login	String			The username used to login.
Name	String			The user's public profile name.
Email	String			The user's publicly visible profile email.
TwitterUsername	String			The user's Twitter username.
Pronouns	String			The user's profile pronouns.
Bio	String			The user's public profile bio.
BioHTML	String			The user's public profile bio as HTML.
Company	String			The user's public profile company.
CompanyHTML	String			The user's public profile company as HTML.
Location	String			The user's public profile location.
AnyPinnableItems	Bool			Determine if this repository owner has any items that can be pinned to their profile. Arguments type (PinnableItemType) Filter to only a particular kind of pinnable item.
PinnedItemsRemaining	Int			Returns how many more items this profile owner can pin to their profile.
ItemShowcaseHasPinnedItems	Bool			Whether or not the owner has pinned any repositories or gists.
IsEmployee	Bool			Whether or not this user is a GitHub employee.
IsHireable	Bool			Whether or not the user has marked themselves as for hire.
IsBountyHunter	Bool			Whether or not this user is a participant in the GitHub Security Bug Bounty.
IsCampusExpert	Bool			Whether or not this user is a participant in the GitHub Campus Experts Program.
IsFollowingViewer	Bool			Whether or not this user is following the viewer. Inverse of viewerIsFollowing.
IsSiteAdmin	Bool			Whether or not this user is a site administrator.
IsDeveloperProgramMember	Bool			Whether or not this user is a GitHub Developer Program member.
IsGitHubStar	Bool			Whether or not this user is a member of the GitHub Stars Program.
IsSponsoringViewer	Bool			True if the viewer is sponsored by this user/organization.
IsViewer	Bool			Whether or not this user is the viewing user.
ViewerCanFollow	Bool			Whether or not the viewer is able to follow the user.
ViewerCanSponsor	Bool			Whether or not the viewer is able to sponsor this user/organization.
ViewerIsFollowing	Bool			Whether or not this user is followed by the viewer.
ViewerIsSponsoring	Bool			True if the viewer is sponsoring this user/organization.
ViewerCanCreateProjects	Bool			Can the current viewer create new projects on this owner.
ViewerCanChangePinnedItems	Bool			Can the viewer pin repositories and gists to the profile?.
StatusId	String			The emoji's id.
StatusEmoji	String			An emoji summarizing the user's status.
StatusMessage	String			A brief message describing what the user is doing.
StatusIndicatesLimitedAvailability	Bool			Whether this status indicates the user is not fully available on GitHub.
StatusEmojiHTML	String			The status emoji as HTML.
StatusCreatedAt	Datetime			Identifies the date and time when the object was created.
StatusExpiresAt	Datetime			If set, the status will not be shown after this date.
StatusUpdatedAt	Datetime			Identifies the date and time when the object was last updated.
StatusOrganizationId	String			The organization's id.
StatusOrganizationLogin	String			The organization's login name.
InteractionAbilityLimit	String			The current limit that is enabled on this object.
InteractionAbilityOrigin	String			The origin of the currently active interaction limit.
InteractionAbilityExpiresAt	Datetime			The time the currently active limit expires.
HasSponsorsListing	Bool			True if this user/organization has a GitHub Sponsors listing.
MonthlyEstimatedSponsorsIncomeInCents	Int			The estimated monthly GitHub Sponsors income for this user/organization in cents (USD).
EstimatedNextSponsorsPayoutInCents	Int			The estimated next GitHub Sponsors payout for this user/organization in cents (USD).
SponsorsListingId	String			The listing's id.
SponsorsListingName	String			The listing's full name.
TotalSponsorshipAmountAsSponsorInCents	Int			The amount in US cents that this entity has spent on GitHub to fund sponsorships. Only returns a value when viewed by the user themselves or by a user who can manage sponsorships for the requested organization.
ResourcePath	String			The HTTP path for this user.
ProjectsResourcePath	String			The HTTP path listing user's projects.
Url	String			The HTTP URL for this user.
ProjectsUrl	String			The HTTP URL listing user's projects.
WebsiteUrl	String			A URL pointing to the user's public website/blog.
AvatarUrl	String			A URL pointing to the user's public avatar. Arguments size (Int) The size of the resulting square image.
CreatedAt	Datetime			Identifies the date and time when the object was created.
UpdatedAt	Datetime			Identifies the date and time when the object was last updated.
RepositoryCount	Int			The number of repositories that a user owns.
FollowerCount	Int			The number of followers that a user has.
RepositoryId	String			The ID of the Repository object.

Lists information about comments which were made on a specific commit.

View-Specific Information

Select

The Cloud processes filters client-side within the Cloud.

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The unique identifier.
DatabaseId	Int			Identifies the primary key from the database.
Body	String			The body as Markdown.
BodyText	String			The body rendered to text.
BodyHTML	String			The body rendered to HTML.
Author	String			The username of the actor who authored the comment.
AuthorAssociation	String			Author's association with the subject of the comment.
Editor	String			The username of the actor who edited the comment.
IsMinimized	Bool			Returns whether or not a comment has been minimized.
MinimizedReason	String			Returns why the comment was minimized.
CreatedViaEmail	Bool			Check if this comment was created via an email reply.
IncludesCreatedEdit	Bool			Check if this comment was edited and includes an edit with the creation data.
ResourcePath	String			The HTTP path for this comment.
Url	String			The HTTP URL for this comment.
LastEditedAt	Datetime			The moment the editor made the last edit.
PublishedAt	Datetime			Identifies when the comment was published at.
CreatedAt	Datetime			Identifies the date and time when the object was created.
UpdatedAt	Datetime			Identifies the date and time when the object was last updated.
ViewerDidAuthor	Bool			Did the viewer author this comment?
ViewerCanDelete	Bool			Check if the current viewer can delete this object.
ViewerCanMinimize	Bool			Check if the current viewer can minimize this object.
ViewerCanReact	Bool			Can user react to this subject?
ViewerCanUpdate	Bool			Check if the current viewer can update this object.
ViewerCannotUpdateReasons	String			Reasons why the current viewer can not update this comment.
ReactionGroups	String			A list of reactions grouped by content left on the subject.
ViewerId	String			The viewer ID.
CommitId	String	Commits.Id		Identifies the commit associated with the comment, if the commit exists.
Path	String			Identifies the file path associated with the comment.
Position	Int			Identifies the line position associated with the comment.

Lists information about commits done in a repository .

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• BranchName supports the '=' comparison operator.
• CommittedDate supports the '=, >=, >, <, <=' comparison operators.

For example, the following queries are processed server side:

SELECT * FROM [Repository].[Commits] WHERE [Repository].[Commits].[BranchName] = 'EXAMPLE'

SELECT * FROM [Repository].[Commits] WHERE [Repository].[Commits].[CommittedDate] >= '2017-12-18 09:02:22.0' AND [Repository].[Commits].[CommittedDate] <= '2018-01-11 15:00:08.0'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID of the commit.
Oid	String			The Git object ID.
AbbreviatedOid	String			An abbreviated version of the Git object ID.
BranchName [KEY]	String	Branches.Name		The name of the branch.
ChangedFilesIfAvailable	Int			The number of changed files in this commit. If GitHub is unable to calculate the number of changed files (for example due to a timeout), this will return 'null'. We recommend using this field instead of 'changedFiles'.
Additions	Int			The number of additions in this commit.
Deletions	Int			The number of deletions in this commit.
AuthoredByCommitter	Bool			Check if the committer and the author match.
CommittedViaWeb	Bool			Check if committed via GitHub web UI.
AuthoredDate	Datetime			The datetime when this commit was authored.
CommittedDate	Datetime			The datetime when this commit was committed.
ViewerSubscription	String			Identifies if the viewer is watching, not watching, or ignoring the subscribable entity.
ViewerCanSubscribe	Bool			Check if the viewer is able to change their subscription status for the repository.
Message	String			The Git commit message.
MessageBody	String			The Git commit message body.
MessageHeadline	String			The Git commit message headline.
MessageBodyHTML	String			The commit message body rendered to HTML.
MessageHeadlineHTML	String			The commit message headline rendered to HTML.
ResourcePath	String			The HTTP path for this commit.
CommitResourcePath	String			The HTTP path for this Git object.
TreeResourcePath	String			The HTTP path for the tree of this commit.
Url	String			The HTTP URL for this commit.
CommitUrl	String			The HTTP URL for this Git object.
TarballUrl	String			Returns a URL to download a tarball archive for a repository. Note: For private repositories, these links are temporary and expire after five minutes.
TreeUrl	String			The HTTP URL for the tree of this commit.
ZipballUrl	String			Returns a URL to download a zipball archive for a repository. Note: For private repositories, these links are temporary and expire after five minutes.
AuthorName	String			The name in the Git commit.
AuthorEmail	String			The email of the commit author.
AuthorDate	Datetime			The timestamp of the Git action (authoring or committing).
AuthorUserLogin	String			The GitHub user corresponding to the email field. Null if no such user exists.
CommitterName	String			The name in the Git commit.
CommitterEmail	String			The email of the committer.
CommitterDate	Datetime			The timestamp of the Git action (authoring or committing).
CommitterUserLogin	String			The GitHub user corresponding to the email field. Null if no such user exists.
OnBehalfOfId	String			The organization's ID this commit was made on behalf of.
OnBehalfOf	String			The organization's login name this commit was made on behalf of.
SignatureIsValid	Bool			True if the signature is valid and verified by GitHub.
Signature	String			ASCII-armored signature header from object.
SignatureEmail	String			Email used to sign this object.
SignaturePayload	String			Payload for GPG signing object. Raw ODB object without the signature header.
SignatureState	String			The state of this signature. VALID if signature is valid and verified by GitHub, otherwise represents reason why signature is considered invalid.
SignatureSigner	String			GitHub user's login name corresponding to the email signing this commit.
WasSignedByGitHub	Bool			True if the signature was made with GitHub's signing key.
StatusId	String			The commit status ID.
StatusState	String			The combined commit status.
StatusCheckRollupId	String			The Check and Status rollup ID.
StatusCheckRollupState	String			Check and Status rollup combined status state for this commit.
TreeId	String			The commit's root Tree ID.
TreeOid	String			The Git object ID.
TreeAbbreviatedOid	String			An abbreviated version of the Git object ID.
TreeCommitUrl	String			The HTTP URL for this Git object.
TreeCommitResourcePath	String			The HTTP path for this Git object.

Lists information about forks of a repository.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• IsLocked supports the '=' comparison operator.
• HasIssuesEnabled supports the '=' comparison operator.
• IsPrivate supports the '=' comparison operator.
• Visibility supports the '=' comparison operator.

The Cloud uses the GitHub API to process ORDER BY clause conditions built with the following column. The Cloud processes ordering by other columns client-side within the Cloud.

• Name
• CreatedAt
• UpdatedAt
• PushedAt

For example, the following query is processed server side:

SELECT * FROM [Repository].[Forks] WHERE [Repository].[Forks].[IsLocked] = 'true'
SELECT * FROM [Repository].[Forks] WHERE [Repository].[Forks].[HasIssuesEnabled] = 'false'
SELECT * FROM [Repository].[Forks] WHERE [Repository].[Forks].[Visibility] = 'PUBLIC'
SELECT * FROM [Repository].[Forks] WHERE [Repository].[Forks].[IsPrivate] = 'false'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The fork ID.
ForkOwnerLogin	String			The login name that owns the fork.
Name	String		True	The name of the fork.
Description	String			The fork description.
DescriptionHTML	String			The fork HTML description.
HasIssuesEnabled	Bool			Indicates if the fork has issues feature enabled.
IsLocked	Bool			Whether the fork is locked.
IsPrivate	Bool			Identifies if the fork is private.
Visibility	String			Indicates the fork's visibility level.
ForkCount	Int			Returns how many forks there are of this fork in the whole network.
StargazerCount	Int		True	Returns a count of how many stargazers there are on this object.
ForkingAllowed	Bool			Whether this fork allows forks.
Url	String			The HTTP URL for this fork.
MirrorUrl	String			The mirror URL of the fork.
CreatedAt	Datetime		True	The creation date of the fork.
UpdatedAt	Datetime		True	The date when the fork was last updated.
PushedAt	Datetime		True	The date the fork was last pushed to.

Lists information about the users assigned to the repository's issues.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• IssueNumber supports the '=' comparison operator.

The Cloud uses the GitHub API to process ORDER BY clause conditions built with the following column. The Cloud processes ordering by other columns client-side within the Cloud.

• UpdatedAt

For example, the following query is processed server side:

SELECT * FROM [Repository].[IssueAssignees] WHERE [Repository].[IssueAssignees].[IssueNumber] = '100'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID of the user.
DatabaseId	Int			Identifies the primary key from the database.
Login	String			The username used to login.
Name	String			The user's public profile name.
Email	String			The user's publicly visible profile email.
TwitterUsername	String			The user's Twitter username.
Pronouns	String			The user's profile pronouns.
Bio	String			The user's public profile bio.
BioHTML	String			The user's public profile bio as HTML.
Company	String			The user's public profile company.
CompanyHTML	String			The user's public profile company as HTML.
Location	String			The user's public profile location.
AnyPinnableItems	Bool			Determine if this repository owner has any items that can be pinned to their profile. Arguments type (PinnableItemType) Filter to only a particular kind of pinnable item.
PinnedItemsRemaining	Int			Returns how many more items this profile owner can pin to their profile.
ItemShowcaseHasPinnedItems	Bool			Whether or not the owner has pinned any repositories or gists.
IsEmployee	Bool			Whether or not this user is a GitHub employee.
IsHireable	Bool			Whether or not the user has marked themselves as for hire.
IsBountyHunter	Bool			Whether or not this user is a participant in the GitHub Security Bug Bounty.
IsCampusExpert	Bool			Whether or not this user is a participant in the GitHub Campus Experts Program.
IsFollowingViewer	Bool			Whether or not this user is following the viewer. Inverse of viewerIsFollowing.
IsSiteAdmin	Bool			Whether or not this user is a site administrator.
IsDeveloperProgramMember	Bool			Whether or not this user is a GitHub Developer Program member.
IsGitHubStar	Bool			Whether or not this user is a member of the GitHub Stars Program.
IsSponsoringViewer	Bool			True if the viewer is sponsored by this user/organization.
IsViewer	Bool			Whether or not this user is the viewing user.
ViewerCanFollow	Bool			Whether or not the viewer is able to follow the user.
ViewerCanSponsor	Bool			Whether or not the viewer is able to sponsor this user/organization.
ViewerIsFollowing	Bool			Whether or not this user is followed by the viewer.
ViewerIsSponsoring	Bool			True if the viewer is sponsoring this user/organization.
ViewerCanCreateProjects	Bool			Can the current viewer create new projects on this owner?
ViewerCanChangePinnedItems	Bool			Can the viewer pin repositories and gists to the profile?
StatusId	String			The emoji's id.
StatusEmoji	String			An emoji summarizing the user's status.
StatusMessage	String			A brief message describing what the user is doing.
StatusIndicatesLimitedAvailability	Bool			Whether this status indicates the user is not fully available on GitHub.
StatusEmojiHTML	String			The status emoji as HTML.
StatusCreatedAt	Datetime			Identifies the date and time when the object was created.
StatusExpiresAt	Datetime			If set, the status will not be shown after this date.
StatusUpdatedAt	Datetime			Identifies the date and time when the object was last updated.
StatusOrganizationId	String			The organization's id.
StatusOrganizationLogin	String			The organization's login name.
InteractionAbilityLimit	String			The current limit that is enabled on this object.
InteractionAbilityOrigin	String			The origin of the currently active interaction limit.
InteractionAbilityExpiresAt	Datetime			The time the currently active limit expires.
HasSponsorsListing	Bool			True if this user/organization has a GitHub Sponsors listing.
MonthlyEstimatedSponsorsIncomeInCents	Int			The estimated monthly GitHub Sponsors income for this user/organization in cents (USD).
EstimatedNextSponsorsPayoutInCents	Int			The estimated next GitHub Sponsors payout for this user/organization in cents (USD).
SponsorsListingId	String			The listing's id.
SponsorsListingName	String			The listing's full name.
TotalSponsorshipAmountAsSponsorInCents	Int			The amount in US cents that this entity has spent on GitHub to fund sponsorships. Only returns a value when viewed by the user themselves or by a user who can manage sponsorships for the requested organization.
ResourcePath	String			The HTTP path for this user.
ProjectsResourcePath	String			The HTTP path listing user's projects.
Url	String			The HTTP URL for this user.
ProjectsUrl	String			The HTTP URL listing user's projects.
WebsiteUrl	String			A URL pointing to the user's public website/blog.
AvatarUrl	String			A URL pointing to the user's public avatar. Arguments size (Int) The size of the resulting square image.
CreatedAt	Datetime			Identifies the date and time when the object was created.
UpdatedAt	Datetime			Identifies the date and time when the object was last updated.
RepositoryCount	Int			The number of repositories that a user owns.
FollowerCount	Int			The number of followers that a user has.
IssueNumber [KEY]	Int	Issues.Number		Identifies the issue number associated with the assignee.

Lists information about comments which were made on a specific issue.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• IssueNumber supports the '=' comparison operator.

The Cloud uses the GitHub API to process ORDER BY clause conditions built with the following column. The Cloud processes ordering by other columns client-side within the Cloud.

• UpdatedAt

For example, the following query is processed server side:

SELECT * FROM [Repository].[IssueComments] WHERE [Repository].[IssueComments].[IssueNumber] = '100'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The unique identifier.
DatabaseId	Int			Identifies the primary key from the database.
Body	String			The body as Markdown.
BodyText	String			The body rendered to text.
BodyHTML	String			The body rendered to HTML.
Author	String			The username of the actor who authored the comment.
AuthorAssociation	String			Author's association with the subject of the comment.
Editor	String			The username of the actor who edited the comment.
IsMinimized	Bool			Returns whether or not a comment has been minimized.
MinimizedReason	String			Returns why the comment was minimized.
CreatedViaEmail	Bool			Check if this comment was created via an email reply.
IncludesCreatedEdit	Bool			Check if this comment was edited and includes an edit with the creation data.
ResourcePath	String			The HTTP path for this comment.
Url	String			The HTTP URL for this comment.
LastEditedAt	Datetime			The moment the editor made the last edit.
PublishedAt	Datetime			Identifies when the comment was published at.
CreatedAt	Datetime			Identifies the date and time when the object was created.
UpdatedAt	Datetime		True	Identifies the date and time when the object was last updated.
ViewerDidAuthor	Bool			Did the viewer author this comment?
ViewerCanDelete	Bool			Check if the current viewer can delete this object.
ViewerCanMinimize	Bool			Check if the current viewer can minimize this object.
ViewerCanReact	Bool			Can user react to this subject?
ViewerCanUpdate	Bool			Check if the current viewer can update this object.
ViewerCannotUpdateReasons	String			Reasons why the current viewer can not update this comment.
ReactionGroups	String			A list of reactions grouped by content left on the subject.
ViewerId	String			The viewer ID.
IssueNumber	Int	Issues.Number		Identifies the issue number associated with the comment.
IssueId	String			Identifies the issue ID associated with the comment.
PullRequestId	String			Returns the ID of the pull request associated with the comment, if this comment was made on a pull request.
FullDatabaseId	Long			Identifies the primary key from the database as a BigInt.

Lists all project issues.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• Author supports the '=, !=' comparison operators.
• State supports the '=' comparison operator.
• ClosedAt supports the '=, >, >=, <, <=' comparison operators.
• UpdatedAt supports the '=, >, >=, <, <=' comparison operators.
• CreatedAt supports the '=, >, >=, <, <=' comparison operators.
• CommentCount supports the '=, >, >=, <, <=' comparison operators.
• ReactionCount supports the '=, >, >=, <, <=' comparison operators.
• Mentions supports the '=' comparison operator.
• Assignee supports the '=' comparison operator.

The Cloud uses the GitHub API to process ORDER BY clause conditions built with the following column. The Cloud processes ordering by other columns client-side within the Cloud.

• UpdatedAt
• CreatedAt

For example, the following queries are processed server side:

SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[Author] = 'EXAMPLE'

SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[State] = 'EXAMPLE'

SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[ClosedAt] = '2018-05-10 11:11:38.0'

SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[UpdatedAt] = '2018-05-10 11:11:38.0'

SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[CreatedAt] = '2018-05-10 11:11:38.0'

SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[CommentCount] = '100'

SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[ReactionCount] = '100'

SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[Mentions] = 'User'

SELECT * FROM [Repository].[Issues] WHERE [Repository].[Issues].[Assignee] = 'User'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The Issue ID.
DatabaseId	Int			Identifies the primary key from the database.
FullDatabaseId	Long			Identifies the primary key from the database as a BigInt.
Title	String			Identifies the issue title.
TitleHTML	String			Identifies the issue title rendered to HTML.
Author	String			The username of the actor who authored the comment.
AuthorAssociation	String			Author's association with the subject of the comment.
Editor	String			The username of the actor who edited the comment.
Body	String			Identifies the body of the issue.
BodyText	String			Identifies the body of the issue rendered to text.
BodyHTML	String			The body rendered to HTML.
BodyResourcePath	String			The http path for this issue body.
BodyUrl	String			The http URL for this issue body.
Number	Int			Identifies the issue number.
State	String			Identifies the state of the issue.
StateReason	String			Identifies the reason for the issue state.
Locked	Bool			True if the object is locked.
ActiveLockReason	String			Reason that the conversation was locked.
Closed	Bool			True if the object is closed (definition of closed may depend on type).
IsPinned	Bool			Indicates whether or not this issue is currently pinned to the repository issues list.
IncludesCreatedEdit	Bool			Check if this comment was edited and includes an edit with the creation data.
CreatedViaEmail	Bool			Check if this comment was created via an email reply.
ResourcePath	String			The HTTP path for this issue.
Url	String			The HTTP URL for this issue.
LastEditedAt	Datetime			The moment the editor made the last edit.
PublishedAt	Datetime			Identifies when the comment was published at.
ClosedAt	Datetime			Identifies the date and time when the object was closed.
UpdatedAt	Datetime		True	Identifies the date and time when the object was last updated.
CreatedAt	Datetime		True	Identifies the date and time when the object was created.
MilestoneId	String	Milestones.Id		Identifies the milestone associated with the issue.
MilestoneTitle	String			Identifies the title of the milestone.
MilestoneNumber	Int			Identifies the number of the milestone.
IsReadByViewer	Bool			Is this issue read by the viewer.
ViewerDidAuthor	Bool			Did the viewer author this comment?
ViewerSubscription	String			Identifies if the viewer is watching, not watching, or ignoring the subscribable entity.
ViewerCanClose	Bool			Indicates if the object can be closed by the viewer.
ViewerCanReopen	Bool			Indicates if the object can be reopened by the viewer.
ViewerCanDelete	Bool			Check if the current viewer can delete this object.
ViewerCanReact	Bool			Can user react to this subject?
ViewerCanSubscribe	Bool			Check if the viewer is able to change their subscription status for the repository.
ViewerThreadSubscriptionStatus	String			Identifies the viewer's thread subscription status.
ViewerThreadSubscriptionFormAction	String			Identifies the viewer's thread subscription form action.
ViewerCanUpdate	Bool			Check if the current viewer can update this object.
ViewerCannotUpdateReasons	String			Reasons why the current viewer can not update this comment.
CommentCount	Int			The number of comments on the issue.
ReactionCount	Int			The number of reactions on the issue.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
Mentions	String		You can find issues that mention a certain user.
Assignee	String		You can find find issues and pull requests that are assigned to a certain user.

Lists information about the different labels you can apply on an issue.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• Name supports the '=' comparison operator.

The Cloud uses the GitHub API to process ORDER BY clause conditions built with the following column. The Cloud processes ordering by other columns client-side within the Cloud.

• Name
• CreatedAt

For example, the following query is processed server side:

SELECT * FROM [Repository].[Labels] WHERE [Repository].[Labels].[Name] = 'EXAMPLE'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID of the label.
Name	String		True	Identifies the label name.
Description	String			A brief description of this label.
Color	String			Identifies the label color.
IsDefault	Bool			Indicates whether or not this is a default label.
ResourcePath	String			The HTTP path for this label.
Url	String			The HTTP URL for this label.
UpdatedAt	Datetime			Identifies the date and time when the label was last updated.
CreatedAt	Datetime		True	Identifies the date and time when the label was created.

Lists information about the users that can be mentioned in the context of the repository.

View-Specific Information

Select

The Cloud processes filters client-side within the Cloud.

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID of the user.
DatabaseId	Int			Identifies the primary key from the database.
Login	String			The username used to login.
Name	String			The user's public profile name.
Email	String			The user's publicly visible profile email.
TwitterUsername	String			The user's Twitter username.
Pronouns	String			The user's profile pronouns.
Bio	String			The user's public profile bio.
BioHTML	String			The user's public profile bio as HTML.
Company	String			The user's public profile company.
CompanyHTML	String			The user's public profile company as HTML.
Location	String			The user's public profile location.
AnyPinnableItems	Bool			Determine if this repository owner has any items that can be pinned to their profile. Arguments type (PinnableItemType) Filter to only a particular kind of pinnable item.
PinnedItemsRemaining	Int			Returns how many more items this profile owner can pin to their profile.
ItemShowcaseHasPinnedItems	Bool			Whether or not the owner has pinned any repositories or gists.
IsEmployee	Bool			Whether or not this user is a GitHub employee.
IsHireable	Bool			Whether or not the user has marked themselves as for hire.
IsBountyHunter	Bool			Whether or not this user is a participant in the GitHub Security Bug Bounty.
IsCampusExpert	Bool			Whether or not this user is a participant in the GitHub Campus Experts Program.
IsFollowingViewer	Bool			Whether or not this user is following the viewer. Inverse of viewerIsFollowing.
IsSiteAdmin	Bool			Whether or not this user is a site administrator.
IsDeveloperProgramMember	Bool			Whether or not this user is a GitHub Developer Program member.
IsGitHubStar	Bool			Whether or not this user is a member of the GitHub Stars Program.
IsSponsoringViewer	Bool			True if the viewer is sponsored by this user/organization.
IsViewer	Bool			Whether or not this user is the viewing user.
ViewerCanFollow	Bool			Whether or not the viewer is able to follow the user.
ViewerCanSponsor	Bool			Whether or not the viewer is able to sponsor this user/organization.
ViewerIsFollowing	Bool			Whether or not this user is followed by the viewer.
ViewerIsSponsoring	Bool			True if the viewer is sponsoring this user/organization.
ViewerCanCreateProjects	Bool			Can the current viewer create new projects on this owner?
ViewerCanChangePinnedItems	Bool			Can the viewer pin repositories and gists to the profile?
StatusId	String			The emoji's id.
StatusEmoji	String			An emoji summarizing the user's status.
StatusMessage	String			A brief message describing what the user is doing.
StatusIndicatesLimitedAvailability	Bool			Whether this status indicates the user is not fully available on GitHub.
StatusEmojiHTML	String			The status emoji as HTML.
StatusCreatedAt	Datetime			Identifies the date and time when the object was created.
StatusExpiresAt	Datetime			If set, the status will not be shown after this date.
StatusUpdatedAt	Datetime			Identifies the date and time when the object was last updated.
StatusOrganizationId	String			The organization's id.
StatusOrganizationLogin	String			The organization's login name.
InteractionAbilityLimit	String			The current limit that is enabled on this object.
InteractionAbilityOrigin	String			The origin of the currently active interaction limit.
InteractionAbilityExpiresAt	Datetime			The time the currently active limit expires.
HasSponsorsListing	Bool			True if this user/organization has a GitHub Sponsors listing.
MonthlyEstimatedSponsorsIncomeInCents	Int			The estimated monthly GitHub Sponsors income for this user/organization in cents (USD).
EstimatedNextSponsorsPayoutInCents	Int			The estimated next GitHub Sponsors payout for this user/organization in cents (USD).
SponsorsListingId	String			The listing's id.
SponsorsListingName	String			The listing's full name.
TotalSponsorshipAmountAsSponsorInCents	Int			The amount in US cents that this entity has spent on GitHub to fund sponsorships. Only returns a value when viewed by the user themselves or by a user who can manage sponsorships for the requested organization.
ResourcePath	String			The HTTP path for this user.
ProjectsResourcePath	String			The HTTP path listing user's projects.
Url	String			The HTTP URL for this user.
ProjectsUrl	String			The HTTP URL listing user's projects.
WebsiteUrl	String			A URL pointing to the user's public website/blog.
AvatarUrl	String			A URL pointing to the user's public avatar. Arguments size (Int) The size of the resulting square image.
CreatedAt	Datetime			Identifies the date and time when the object was created.
UpdatedAt	Datetime			Identifies the date and time when the object was last updated.
RepositoryCount	Int			The number of repositories that a user owns.
FollowerCount	Int			The number of followers that a user has.

Lists information about the different entries on an merge queue.

View-Specific Information

Select

The Cloud processes filters client-side within the Cloud.

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID of the MergeQueueEntry object.
RepositoryId	String			The ID of the Repository object.
RepositoryMergeQueueId	String			The ID of the MergeQueue object.
BaseCommitId	String			The ID of the base commit.
EnqueuedAt	Datetime			The date and time this entry was added to the merge queue.
EstimatedTimeToMerge	Int			The estimated time in seconds until this entry will be merged.
HeadCommitId	String			The ID of the head commit.
Jump	Bool			Whether this pull request should jump the queue.
Position	Int			The position of this entry in the queue.
PullRequestId	String			The ID of the PullRequest object.
Solo	Bool			Does this pull request need to be deployed on its own?
State	String			The state of this entry in the queue.

Lists information about the different labels you can apply on an issue.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• Branch supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM [Repository].[MergeQueues] WHERE [Repository].[MergeQueues].[Branch] = 'test'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID of the MergeQueueEntry object.
ResourcePath	String			The HTTP path for the merge queue.
Branch	String			The name of the branch to get the merge queue for.
Url	String			The HTTP URL for the merge queue.
RepositoryId	String			The ID of the repository.
NextEntryEstimatedTimeToMerge	Int			The estimated time in seconds until a newly added entry would be merged.

Lists information about milestones in a repository.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• Number supports the '=' comparison operator.
• State supports the '=' comparison operator.

The Cloud uses the GitHub API to process ORDER BY clause conditions built with the following column. The Cloud processes ordering by other columns client-side within the Cloud.

• Number
• DueOn
• UpdatedAt
• CreatedAt

For example, the following queries are processed server side:

SELECT * FROM [Repository].[Milestones] WHERE [Repository].[Milestones].[Number] = '100'

SELECT * FROM [Repository].[Milestones] WHERE [Repository].[Milestones].[State] = 'all'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The ID of the milestone.
Title	String			Identifies the title of the milestone.
Closed	Bool			True if the object is closed (definition of closed may depend on type).
ProgressPercentage	Double			Progress Percentage for this milestone.
Description	String			Identifies the description of the milestone.
Number	Int		True	Identifies the number of the milestone.
State	String			Identifies the state of the milestone.
ResourcePath	String			The HTTP path for this milestone.
Url	String			The HTTP URL for this milestone.
ViewerCanClose	Bool			Indicates if the object can be closed by the viewer.
ViewerCanReopen	Bool			Indicates if the object can be reopened by the viewer.
DueOn	Datetime		True	Identifies the due date of the milestone.
ClosedAt	Datetime			Identifies the date and time when the object was closed.
UpdatedAt	Datetime		True	Identifies the date and time when the object was last updated.
CreatedAt	Datetime		True	Identifies the date and time when the object was created.

Lists information about comments which were made on a specific pull request.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• PullRequestId supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM [Repository].[PullRequestComments] WHERE [Repository].[PullRequestComments].[PullRequestId] = 'PR_kwDO00RTuc5l2kMj'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The unique identifier.
DatabaseId	Int			Identifies the primary key from the database.
Body	String			The body as Markdown.
BodyText	String			The body rendered to text.
BodyHTML	String			The body rendered to HTML.
Author	String			The username of the actor who authored the comment.
AuthorAssociation	String			Author's association with the subject of the comment.
Editor	String			The username of the actor who edited the comment.
IsMinimized	Bool			Returns whether or not a comment has been minimized.
MinimizedReason	String			Returns why the comment was minimized.
CreatedViaEmail	Bool			Check if this comment was created via an email reply.
IncludesCreatedEdit	Bool			Check if this comment was edited and includes an edit with the creation data.
ResourcePath	String			The HTTP path for this comment.
Url	String			The HTTP URL for this comment.
LastEditedAt	Datetime			The moment the editor made the last edit.
PublishedAt	Datetime			Identifies when the comment was published at.
CreatedAt	Datetime			Identifies the date and time when the object was created.
UpdatedAt	Datetime			Identifies the date and time when the object was last updated.
ViewerDidAuthor	Bool			Did the viewer author this comment?
ViewerCanDelete	Bool			Check if the current viewer can delete this object.
ViewerCanMinimize	Bool			Check if the current viewer can minimize this object.
ViewerCanReact	Bool			Can user react to this subject?
ViewerCanUpdate	Bool			Check if the current viewer can update this object.
ViewerCannotUpdateReasons	String			Reasons why the current viewer can not update this comment.
IssueId	String			Identifies the issue ID associated with the comment.
PullRequestId	String			Returns the ID of the pull request associated with the comment, if this comment was made on a pull request.
FullDatabaseId	Long			Identifies the primary key from the database as a BigInt.

Lists information about comments which were made on a pull request review.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• PullRequestReviewId supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM [Repository].[PullRequestReviewComments] WHERE [Repository].[PullRequestReviewComments].[PullRequestReviewId] = 'PRR_kwDO000Tuc5yOHvY'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The unique identifier.
DatabaseId	Int			Identifies the primary key from the database.
Body	String			The body as Markdown.
BodyText	String			The body rendered to text.
BodyHTML	String			The body rendered to HTML.
Author	String			The username of the actor who authored the comment.
AuthorAssociation	String			Author's association with the subject of the comment.
Editor	String			The username of the actor who edited the comment.
IsMinimized	Bool			Returns whether or not a comment has been minimized.
MinimizedReason	String			Returns why the comment was minimized.
CreatedViaEmail	Bool			Check if this comment was created via an email reply.
IncludesCreatedEdit	Bool			Check if this comment was edited and includes an edit with the creation data.
ResourcePath	String			The HTTP path for this comment.
Url	String			The HTTP URL for this comment.
LastEditedAt	Datetime			The moment the editor made the last edit.
PublishedAt	Datetime			Identifies when the comment was published at.
CreatedAt	Datetime			Identifies the date and time when the object was created.
UpdatedAt	Datetime			Identifies the date and time when the object was last updated.
ViewerDidAuthor	Bool			Did the viewer author this comment?
ViewerCanDelete	Bool			Check if the current viewer can delete this object.
ViewerCanMinimize	Bool			Check if the current viewer can minimize this object.
ViewerCanReact	Bool			Can user react to this subject?
ViewerCanUpdate	Bool			Check if the current viewer can update this object.
ViewerCannotUpdateReasons	String			Reasons why the current viewer can not update this comment.
PullRequestId	String			Returns the ID of the pull request associated with the comment, if this comment was made on a pull request.
PullRequestReviewId	String			Identifies the pull request number associated with this pull request review.
FullDatabaseId	Long			Identifies the primary key from the database as a BigInt.

Lists information about pull request reviews in a repository.

View-Specific Information

Select

The Cloud uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The Cloud processes other filters client-side within the Cloud.

• PullRequestNumber supports the '=' comparison operator.
• State supports the '=, IN' comparison operators.
• Author supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM [Repository].[PullRequestReviews] WHERE [Repository].[PullRequestReviews].[PullRequestNumber] = '100'

SELECT * FROM [Repository].[PullRequestReviews] WHERE [Repository].[PullRequestReviews].[State] = 'PENDING'

SELECT * FROM [Repository].[PullRequestReviews] WHERE [Repository].[PullRequestReviews].[Author] = 'EXAMPLE'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The unique identifier.
DatabaseId	Int			Identifies the primary key from the database.
Body	String			The body as Markdown.
BodyText	String			The body rendered to text.
BodyHTML	String			The body rendered to HTML.
Author	String			The actor's username login who authored the comment.
AuthorAssociation	String			Author's association with the subject of the comment.
Editor	String			The username of the actor who edited the comment.
IsMinimized	Bool			Returns whether or not a comment has been minimized.
MinimizedReason	String			Returns why the comment was minimized.
CreatedViaEmail	Bool			Check if this comment was created via an email reply.
IncludesCreatedEdit	Bool			Check if this comment was edited and includes an edit with the creation data.
ResourcePath	String			The HTTP path for this comment.
Url	String			The HTTP URL for this comment.
LastEditedAt	Datetime			The moment the editor made the last edit.
PublishedAt	Datetime			Identifies when the comment was published at.
CreatedAt	Datetime			Identifies the date and time when the object was created.
UpdatedAt	Datetime			Identifies the date and time when the object was last updated.
ViewerDidAuthor	Bool			Did the viewer author this comment?
ViewerCanDelete	Bool			Check if the current viewer can delete this object.
ViewerCanMinimize	Bool			Check if the current viewer can minimize this object.
ViewerCanReact	Bool			Can user react to this subject?
ViewerCanUpdate	Bool			Check if the current viewer can update this object.
ViewerCannotUpdateReasons	String			Reasons why the current viewer can not update this comment.
ReactionGroups	String			A list of reactions grouped by content left on the subject.
ViewerId	String			The viewer ID.
PullRequestId	String	PullRequests.Id		Identifies the pull request ID associated with this pull request review.
PullRequestNumber	Int			Identifies the pull request number associated with this pull request review.
CommitId	String			Identifies the commit associated with this pull request review.
SubmittedAt	Datetime			Identifies when the Pull Request Review was submitted.
State	String			Identifies the current state of the pull request review.
AuthorCanPushToRepository	Bool			Indicates whether the author of this review has push access to the repository.
FullDatabaseId	Long			Identifies the primary key from the database as a BigInt.