CrateDB

Connect a CrateDB distributed SQL database to Lakehousecat using a connection URI.

Connection Fields

Field	Required	Description
Connection URI	Yes	Full connection string using the PostgreSQL wire port. Example: cratedb://user:password@host:5432/database
Use SSH	No	Enable if the database is behind an SSH bastion host. See SSH Tunneling.

Prerequisites

• Admin or Builder role in Lakehousecat
• Access to the CrateDB PostgreSQL wire port (default: 5432)
• A CrateDB user with SELECT access to the target tables

Notes

• CrateDB exposes a PostgreSQL-compatible wire protocol — use the cratedb:// URI scheme in Lakehousecat.
• The default schema in CrateDB is doc (not public).
• Incremental Load is supported; use a timestamp column (e.g., updated_at) as the merge key.
• CrateDB columns are always nullable by design, which is handled automatically by Lakehousecat.

Next Steps

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