Skip to main content
Version: 0.0.37

Clickhouse

Clickhouse is a powerful columnar database management system, particularly designed for online analytical processing (OLAP) tasks. Integrating Clickhouse within Lakehousecat allows you to efficiently manage and query large datasets.

Accessing Clickhouse Connections​

To integrate Clickhouse into your workflow, follow these steps:

Step-by-Step Guide​

  1. Start in the Workspace

    • Navigate to your Lakehousecat workspace where you manage data connections.

  2. Go to the Data Section

    • Click on the 'Data' menu to explore various data-related options within Lakehousecat.

  3. Select "Datasource Types"

    • To view available data sources, select the "Datasource Types" option.

  4. Choose "Clickhouse Datasource Type"

    • Click on the "Clickhouse Datasource Type" to initiate the configuration process.

Configuring Your Connection​

Upon selecting Clickhouse as your datasource type, you can proceed with the following configurations:

  • Name:

    • Enter a unique and descriptive name for your Clickhouse connection that will be easily identifiable.

  • Connection URI:

    • Specify the connection URI, a critical component that designates how Lakehousecat connects to your Clickhouse database.

  • Description (Optional):

    • You can add an optional description or dictate detailed notes related to the connection for future reference.

Creating the Connection​

After filling in the necessary connection details:

  • Click the "Create" Button to establish the connection. Lakehousecat will validate the connectivity parameters and upon successful validation, the connection will be saved and ready for use.