Github Events
Snowflake table name : CYBERSYN.GITHUB_EVENTS
Last updated
Snowflake table name : CYBERSYN.GITHUB_EVENTS
Last updated
Copyright © 2024 Cybersyn
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