ClickHouse

This guide explains how to connect your ClickHouse database to Jet Admin in a few simple steps.

Before you begin, ensure you have:

  • Access to a running instance of ClickHouse DB.

  • Connection credentials: Host, Port, Username, Password, and the specific Database Name.

Steps to Connect ClickHouse DB

  1. Log in to Jet Admin: Open Jet Admin and navigate to your application.

  2. Add a New Resource: In the left-side menu, go to the Data section and click Add Resource.

  3. Select ClickHouse DB: From the list of data sources, choose ClickHouse DB.

  4. Provide Connection Details: Enter the required credentials, including the Host, Port, Username, Password, and Database Name.

  5. Test the Connection: Click Test Connection to ensure Jet Admin can successfully connect to your ClickHouse database.

  6. Select Tables: Once the connection is established, choose the tables you want to use in Jet Admin.

Troubleshooting Tips

  1. Connection Issues: Double-check the credentials and ensure your ClickHouse instance is accessible.

  2. Firewall Rules: If your ClickHouse DB is hosted in a secure environment, confirm that Jet Admin's IP addresses are whitelisted.

  3. SSL/TLS: If your database requires encrypted connections, ensure SSL/TLS settings are correctly configured in ClickHouse and Jet Admin.

  4. Port Issues: For ClickHouse, you need the native connection type. The default port for the native protocol with SSL/TLS is 9440.

    • Make sure to use native protocol SSL/TLS port.

    • Refer to ClickHouse documentation for more details: ClickHouse Network Ports.

Last updated

Was this helpful?