How can I fetch data about all of my historical sensor ticks?

[dagsir[bot]]

Hi Dagster Team, is there a table in the metadata db that contains data for all sensor ticks? job_ticks and event_logs seem to only contain runs that successfully trigger the job specified in the sensor.

---

The question was originally asked in Dagster Slack.

[alangenfeld]

The job_ticks table stores information for each tick of a sensor/schedule. This information is set-up to be removed over time using these settings https://docs.dagster.io/deployment/dagster-instance#data-retention

So what you see left in the database will reflect your retention settings.