https://dagster.io/ logo
#ask-ai
Title
# ask-ai
a

Andrea Montes

03/11/2024, 1:56 PM
@Scout which table does store data of the schedules run?
s

Scout

03/11/2024, 1:56 PM
The data for schedule runs in Dagster is stored in the
job_ticks
table within the Dagster instance's metadata database. This table stores information for each tick of a schedule, which includes whether the schedule resulted in a run being launched, skipped, or failed, along with other metadata about the tick. The
job_ticks
table is part of the system that manages the execution and tracking of schedules in Dagster.
a

Andrea Montes

03/11/2024, 2:05 PM
@Scout what is the selector_id in table job_ticks for?
s

Scout

03/11/2024, 2:05 PM
The
selector_id
in the
job_ticks
table is used to associate a tick with a specific schedule or sensor within the Dagster instance. Each schedule or sensor has a unique identifier, and the
selector_id
is a reference to this identifier. When a tick is recorded in the
job_ticks
table, the
selector_id
helps to identify which schedule or sensor the tick is associated with, allowing you to query and filter the tick data based on the specific schedule or sensor. This is useful for tracking the execution history and status of individual schedules or sensors over time.
a

Andrea Montes

03/11/2024, 2:11 PM
@Allison Stuckey_
keanu thanks 1
@Tong Dong Hello 🙂
2 Views