Project Data Model
In the Project Data Model, the provider models each project associated with the authenticated account as a schema. Live connectivity to these objects means that any changes to your GitHub account are immediately reflected in the provider.
Note: The provider does not read from classic projects; they have been deprecated in the GitHub API.
Tables
The Tables section, which details standard SQL tables, contains samples of what you might have access to in your GitHub account.
The following tables are shipped with the provider:
| Name | Description |
| StatusUpdates | Logs status changes for project items, helping teams track progress and communicate updates effectively. |
Views
The Views section, which lists read-only SQL tables, contains samples of what you might have access to in your GitHub account.
The following views are shipped with the provider:
| Name | Description |
| CustomView | Displays project items labeled 'bug,' sorted by label name in ascending order, to facilitate issue tracking. |
| ItemAssignees | Tracks users assigned to project items, offering a detailed view of task ownership and accountability. |
| ItemLabels | Stores labels applied to project items, enabling better categorization and filtering of tasks. |
| ItemLinkedPullRequests | Connects pull requests to specific project items, creating traceability between project tasks and related code changes. |
| ItemReviewers | Maintains a list of reviewers assigned to specific project items, ensuring tracking of review responsibilities. |
| Items | Contains all details related to project items, including metadata and any associated fields. |
| ItemsView | Offers a complete and unfiltered view of all project items, facilitating comprehensive project analysis. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including getting the currently authenticated user or retrieving and refreshing OAuth access tokens.
The following procedures are shipped with the provider:
| Name | Description |
| GetCurrentlyAuthenticatedUser | Retrieves information about the currently authenticated user in the context of a GitHub project, including roles and permissions. |
| GetOAuthAccessToken | Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to GitHub. |
| GetOAuthAuthorizationURL | Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process. |
| RefreshOAuthAccessToken | Refreshes an expired OAuth Access Token to maintain continuous authenticated access to GitHub resources without requiring reauthorization from the user. |