Cloudera Lakehouse Optimizer persistence database schema

Cloudera Lakehouse Optimizer stores persisted scheduler and task state in a shared PostgreSQL database. The following tables store state persistence data:

Table 1. Persistence database tables
Table	Purpose
`dispatched_tasks`	Scheduled and in-flight maintenance jobs, including task status.
`simple_triggers`	Event-based trigger schedules.
`cron_triggers`	Static cron trigger definitions. Recreated from configuration on restart.
`trigger_policies`	Policy assignments for triggers.
`clo_fencing_token`	High availability fencing token storage. Used when HA is enabled.
`clo_node_ownership`	Standalone mode node coordination.
`clo_schema_version`	Schema version tracking for automatic database migrations.
`tasks`	Executed tasks
`tasks_actions`	Executed task actions