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	1472745773
CREATED_AT_TIMESTAMP	Datetime the event took place	TIMESTAMP_TZ	2014-07-15 16:00:10-07:00
TYPE	Category of event logged	VARCHAR	PushEvent
ACTOR_AVATAR_URL	Avaatar of the user or actor	VARCHAR	https://avatars.githubusercontent.com/u/510328?
ACTOR_DISPLAY_LOGIN	Display name of the user or actor involved in the event	VARCHAR	awslitvit
ACTOR_GRAVATAR_ID	None	VARCHAR	N/A
ACTOR_ID	Unique identifier of the user or actor involved in the event	NUMBER	270710
ACTOR_LOGIN	Login name of the user or actor involved in the event	VARCHAR	wtask
ACTOR_URL	None	VARCHAR	https://api.github.com/users/KangHayeonn
REPO_ID	Unique identifier for the repository involved in the event, joinable to the github_repos table	NUMBER	65617947
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/37784886?
ORG_GRAVATAR_ID	None	VARCHAR	N/A
ORG_ID	Unique identifier for the organization	NUMBER	3019853
ORG_LOGIN	Name of the organization	VARCHAR	theupdateframework
ORG_URL	URL that contains information about the org, including the Github org link	VARCHAR	https://api.github.com/orgs/theupdateframework
PAYLOAD	Request involved in the action	VARIANT	{ "action": "created", "pull_request": { "_links": { ...
PAYLOAD_ACTION	Type of action taken by the request	VARCHAR	added
PAYLOAD_DESCRIPTION	None	VARCHAR	One webpage for every book ever published!
PAYLOAD_COMMENT	None	VARCHAR	{"_links":{"html":{"href":"https://github.com/Agaxia-Poland/agni...
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	16003461866
PAYLOAD_HEAD	None	VARCHAR	d59e29e5465f5088071fb2cec0dbe0dcc353c707
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-10
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	PHP