Github Events

Snowflake table name : CYBERSYN.GITHUB_EVENTS

View data source documentation here.

Name	Description	Type	Example
ID	Unique identifier for the Github event	VARCHAR	22459724267
CREATED_AT_TIMESTAMP	Datetime the event took place	TIMESTAMP_TZ	2022-11-11 13:46:46+00:00
TYPE	Category of event logged	VARCHAR	PullRequestReviewEvent
ACTOR_AVATAR_URL	Avaatar of the user or actor	VARCHAR	https://avatars.githubusercontent.com/u/49699333?
ACTOR_DISPLAY_LOGIN	Display name of the user or actor involved in the event	VARCHAR	doctormacky
ACTOR_GRAVATAR_ID	None	VARCHAR	N/A
ACTOR_ID	Unique identifier of the user or actor involved in the event	NUMBER	49699333
ACTOR_LOGIN	Login name of the user or actor involved in the event	VARCHAR	EvanKrall
ACTOR_URL	None	VARCHAR	https://api.github.com/users/lucas-cavalcanti-ads
REPO_ID	Unique identifier for the repository involved in the event, joinable to the github_repos table	NUMBER	385765939
REPO_NAME	Name of the repository	VARCHAR	/
REPO_URL	URL of the repository	VARCHAR	https://api.github.dev/repos//
ORG_AVATAR_URL	Avatar of the organization	VARCHAR	https://avatars.githubusercontent.com/u/16550744?
ORG_GRAVATAR_ID	None	VARCHAR	N/A
ORG_ID	Unique identifier for the organization	NUMBER	3019853
ORG_LOGIN	Name of the organization	VARCHAR	sauron-demo
ORG_URL	URL that contains information about the org, including the Github org link	VARCHAR	https://api.github.com/orgs/PyFE
PAYLOAD	Request involved in the action	VARIANT	{ "action": "opened", "number": 23, "pull_request": { ...
PAYLOAD_ACTION	Type of action taken by the request	VARCHAR	added
PAYLOAD_DESCRIPTION	None	VARCHAR	Apache Superset is a Data Visualization and Data Exploration Pla...
PAYLOAD_COMMENT	None	VARCHAR	{"_links":{"html":{"href":"https://github.com/AvaloniaUI/Avaloni...
PAYLOAD_MASTER_BRANCH	None	VARCHAR	main
PAYLOAD_PULL_REQUEST	None	VARCHAR	{"_links":{"comments":{"href":"https://api.github.com/repos/xcxn...
PAYLOAD_PUSHER_TYPE	Category of user that made the push	VARCHAR	user
PAYLOAD_PUSH_ID	None	NUMBER	13618249408
PAYLOAD_HEAD	None	VARCHAR	27195542618c9fd3b967c8d5691f68e40767fc19
PAYLOAD_REF	None	VARCHAR	refs/heads/main
PAYLOAD_REF_TYPE	None	VARCHAR	branch
PAYLOAD_ISSUE_ID	None	NUMBER	1699059258
PAYLOAD_ISSUE	None	VARIANT	{ "active_lock_reason": null, "assignee": null, "assignees...
PUBLIC	None	BOOLEAN	True
LOAD_DATE	Date the event was loaded	VARCHAR	2023-07-11
CREATED_AT	Datetime the event took place	VARCHAR	2023-04-10T09:43:08Z
PAYLOAD_BODY	None	VARCHAR	N/A
PAYLOAD_COMMIT_ID	None	VARCHAR	N/A
PAYLOAD_CREATED_AT	None	VARCHAR	N/A
PAYLOAD_USER_ID	None	NUMBER	N/A
PAYLOAD_USER_LOGIN	None	VARCHAR	N/A
ISSUE	None	VARIANT	N/A
ISSUE_ACTIVE_LOCK_REASON	None	VARCHAR	N/A
ISSUE_ASSIGNEE	None	VARCHAR	N/A
ISSUE_ASSIGNEES	None	VARIANT	N/A
ISSUE_AUTHOR_ASSOCIATION	None	VARCHAR	N/A
ISSUE_BODY	None	VARCHAR	N/A
ISSUE_CLOSED_AT	None	VARCHAR	N/A
ISSUE_COMMENTS	None	NUMBER	N/A
ISSUE_COMMENTS_URL	None	VARCHAR	N/A
ISSUE_CREATED_AT	None	VARCHAR	N/A
ISSUE_DRAFT	None	BOOLEAN	N/A
ISSUE_EVENTS_URL	None	VARCHAR	N/A
ISSUE_HTML_URL	None	VARCHAR	N/A
ISSUE_ID	None	NUMBER	N/A
ISSUE_LABELS	None	VARIANT	N/A
ISSUE_LABELS_URL	None	VARCHAR	N/A
ISSUE_LOCKED	None	BOOLEAN	N/A
ISSUE_MILESTONE	None	VARCHAR	N/A
ISSUE_NODE_ID	None	VARCHAR	N/A
ISSUE_NUMBER	None	NUMBER	N/A
ISSUE_PERFORMED_VIA_GITHUB_APP	None	VARCHAR	N/A
ISSUE_PULL_REQUEST	None	VARIANT	N/A
ISSUE_REACTIONS	None	VARIANT	N/A
ISSUE_REPOSITORY_URL	None	VARCHAR	N/A
ISSUE_STATE	None	VARCHAR	N/A
ISSUE_TIMELINE_URL	None	VARCHAR	N/A
ISSUE_TITLE	None	VARCHAR	N/A
ISSUE_UPDATED_AT	None	VARCHAR	N/A
ISSUE_URL	None	VARCHAR	N/A
ISSUE_USER_ID	None	NUMBER	N/A
ISSUE_USER_LOGIN	None	VARCHAR	N/A
ISSUE_USER_TYPE	None	VARCHAR	N/A
LANGUAGE	Language of the repository.	VARCHAR	Roff