Cloudera Lakehouse Optimizer persistence configuration properties

Use the following properties to configure state persistence for Cloudera Lakehouse Optimizer.

Table 1. Persistence configuration properties
Property Description Default Example
dlm_db_type Database type for state persistence. Currently, only PostgreSQL is supported. Not set postgres
dlm_db_name Name of the PostgreSQL database that stores persisted scheduler and task state. Not set dlm_persistence
dlm_db_host Hostname or IP address of the PostgreSQL server. Not set postgres.example.com
dlm_db_port Port number of the PostgreSQL server. 5432 5432
dlm_db_user Database user name for the PostgreSQL connection. Not set dlm_user
dlm_db_password Password for dlm_db_user. Not set ********
dlm_db_jdbc_url Alternative to individual host, port, and database properties. When you use a JDBC URL, also set dlm_db_user and dlm_db_password. Not set jdbc:postgresql://postgres.example.com:5432/dlm_persistence