Consumption

In order to monitor usage, the application creates views that give aggregate counts of assignments.

Application Roles

A user must be mapped to one of the following application roles to access assignments:

View: experimentation.assignments_per_day

Field	Description	Data Type
`date_created`	Date the assignment was created	`DATE`
`assignment_count`	Number of assignments created in the given day	`INT`

View: experimentation.assignments_per_experiment

Field	Description	Data Type
`experiment_id`	ID of the experiment	`VARCHAR`
`experiment_name`	Name of the experiment	`VARCHAR`
`lab_id`	ID of the lab the experiment belongs to	`VARCHAR`
`assignment_count`	Number of assignments created in the given experiment	`INT`

Get a daily account of assignments for the month of December 2024

USE <application_name>;

SELECT *
FROM experimentation.assignments_per_day
WHERE date_created >= '2024-12-01' AND date_created < '2025-01-01';