Github Events

Snowflake table name : CYBERSYN.GITHUB_EVENTS

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
ID	Unique identifier for the Github event	VARCHAR	15883144240
CREATED_AT_TIMESTAMP	Datetime the event took place	TIMESTAMP_TZ	2018-07-05 18:39:56+00:00
TYPE	Category of event logged	VARCHAR	PushEvent
ACTOR_AVATAR_URL	Avaatar of the user or actor	VARCHAR	https://avatars.githubusercontent.com/u/21038158?
ACTOR_DISPLAY_LOGIN	Display name of the user or actor involved in the event	VARCHAR	dependabot
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	stevenkboyd
ACTOR_URL	None	VARCHAR	https://api.github.com/users/domesticmouse
REPO_ID	Unique identifier for the repository involved in the event, joinable to the github_repos table	NUMBER	623971349
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/14940208?
ORG_GRAVATAR_ID	None	VARCHAR	N/A
ORG_ID	Unique identifier for the organization	NUMBER	1759716
ORG_LOGIN	Name of the organization	VARCHAR	taichi-dev
ORG_URL	URL that contains information about the org, including the Github org link	VARCHAR	https://api.github.com/orgs/taichi-dev
PAYLOAD	Request involved in the action	VARIANT	{ "head": "d59e29e5465f5088071fb2cec0dbe0dcc353c707", "push_...
PAYLOAD_ACTION	Type of action taken by the request	VARCHAR	started
PAYLOAD_DESCRIPTION	None	VARCHAR	One webpage for every book ever published!
PAYLOAD_COMMENT	None	VARCHAR	{"_links":{"html":{"href":"https://github.com/portworx/torpedo/p...
PAYLOAD_MASTER_BRANCH	None	VARCHAR	main
PAYLOAD_PULL_REQUEST	None	VARCHAR	{"_links":{"comments":{"href":"https://api.github.com/repos/taic...
PAYLOAD_PUSHER_TYPE	Category of user that made the push	VARCHAR	user
PAYLOAD_PUSH_ID	None	NUMBER	12013409884
PAYLOAD_HEAD	None	VARCHAR	27195542618c9fd3b967c8d5691f68e40767fc19
PAYLOAD_REF	None	VARCHAR	refs/heads/master
PAYLOAD_REF_TYPE	None	VARCHAR	repository
PAYLOAD_ISSUE_ID	None	NUMBER	1700943710
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-12
CREATED_AT	Datetime the event took place	VARCHAR	2022-11-11T13:46:46Z
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	Java