Apache Doris

Connect an Apache Doris database to Lakehousecat using a connection URI. Apache Doris is a high-performance, real-time analytical database based on MPP architecture.

Connection Fields

Field	Required	Description
Connection URI	Yes	Full connection string including credentials, host, port, and database name. Example: doris://user:password@host:9030/mydb
Use SSH	No	Enable if the database is behind an SSH bastion host. When enabled, SSH settings fields appear. See SSH Tunneling.

Prerequisites

• Admin or Builder role in Lakehousecat
• An Apache Doris user with SELECT access to the schemas and tables you want to expose
• Network connectivity from the Lakehousecat backend to the Frontend (FE) node (direct or via SSH)
• Apache Doris FE default port: 9030

Notes

• Apache Doris is MySQL-wire-compatible via its Frontend (FE) node — the connection uses the MySQL protocol internally.
• The connection URI scheme doris:// is automatically translated to mysql+pymysql:// for DLT loading.
• Doris uses DUPLICATE KEY model for tables; primary key metadata differs from standard SQL — Merge Key Detection may require manual configuration.
• Incremental Load is supported with manual merge key settings; use a timestamp column (e.g., updated_at) as the incremental column.

Next Steps

After creating the datasource, go to the Operations tab to trigger semantic extraction.