assignment_grades

Creates, updates, deletes, gets or lists an assignment_grades resource.

Overview

Name	assignment_grades
Type	Resource
Id	github.classroom.assignment_grades

Fields

The following fields are returned by SELECT queries:

get_assignment_grades

Response

Name	Datatype	Description
assignment_name	string	Name of the assignment
group_name	string	If a group assignment, name of the group the student is in
student_repository_name	string	Name of the student's assignment repository
assignment_url	string	URL of the assignment
github_username	string	GitHub username of the student
points_available	integer	Number of points available for the assignment
points_awarded	integer	Number of points awarded to the student
roster_identifier	string	Roster identifier of the student
starter_code_url	string	URL of the starter code for the assignment
student_repository_url	string	URL of the student's assignment repository
submission_timestamp	string	Timestamp of the student's assignment submission

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_assignment_grades	select	assignment_id		> [!WARNING] > Closing down notice: This operation is closing down and will be removed on August 28, 2026. > For more information, see the GitHub Classroom sunset notice. Gets grades for a GitHub Classroom assignment. Grades will only be returned if the current user is an administrator of the GitHub Classroom for the assignment.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
assignment_id	integer	The unique identifier of the classroom assignment.

SELECT examples

get_assignment_grades

> [!WARNING]
> Closing down notice: This operation is closing down and will be removed on August 28, 2026.
> For more information, see the GitHub Classroom sunset notice.

Gets grades for a GitHub Classroom assignment. Grades will only be returned if the current user is an administrator of the GitHub Classroom for the assignment.

SELECT
assignment_name,
group_name,
student_repository_name,
assignment_url,
github_username,
points_available,
points_awarded,
roster_identifier,
starter_code_url,
student_repository_url,
submission_timestamp
FROM github.classroom.assignment_grades
WHERE assignment_id = '{{ assignment_id }}' -- required
;