GitHub repository stargazers

Lists every account that has starred a repository, one row per stargazer. Use it to capture a repository's audience before it changes visibility, moves to another owner or is archived: GitHub clears stars when a public repository is made private, and the stargazers_count on the repository record only says how many, not who.

Query

SELECT
login,
html_url,
type
FROM github.activity.repo_stargazers
WHERE owner = '{{owner}}'
AND repo = '{{repo}}';

Notes

The resource also exposes a starred_at column, but the provider requests the plain JSON media type rather than GitHub's star media type, so starred_at is always null. For the star count alone read stargazers_count from github.repos.repos instead of counting rows here. A 403 with the message "Resource not accessible by personal access token" comes from a fine-grained personal access token that does not cover the repository; use a classic token or extend the fine-grained token's repository access and Metadata permission.