Gist Data Model
In the Gist Data Model, the connector models gists associated with the authenticated account—including their files, comments, forks, and commits—as an easy-to-use SQL database. Live connectivity to these objects means that any changes to your GitHub account are immediately reflected in the connector. Note that retrieving gists is not supported for Enterprise Managed Users.
Tables
The following Tables are shipped with the connector:
| Name | Description |
| Comments | Lists comments on gists. |
| Files | Lists up to three hundred files for each gist at their most recent revisions, including up to one megabyte of content per file. |
| Gists | Lists gists at their most recent revisions. |
| Parents | Lists parent gist information for forked gists. |
Views
The following Views are shipped with the connector:
| Name | Description |
| CommentEdits | Lists edit history for gist comments. |
| CommitFiles | Lists up to three hundred files for each gist at every revision, including up to one megabyte of content per file. |
| Commits | Lists the commit history of gists. |
| Forks | Lists gist forks. |
| Stargazers | Lists information about the users who have starred gists. |
| Starred | Lists starred gists for the authenticated user. |
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 connector:
| Name | Description |
| DownloadFile | Download a file from a gist. |
| GetCurrentlyAuthenticatedUser | Retrieves information about the currently authenticated user. |
| GetOAuthAccessToken | Gets the OAuth access token from GitHub. |
| GetOAuthAuthorizationURL | Gets the GitHub authorization URL. Access the URL returned in the output in a Web browser. This requests the access token that can be used as part of the connection string to GitHub. |
| IsGistStarred | Checks if a gist is starred by the authenticated user. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication. |
| StarGist | Stars a gist for the authenticated user. |
| UnstarGist | Unstar a gist for the authenticated user. |