ClickHouse
This guide explains how to connect your ClickHouse database to Jet Admin in a few simple steps.
Last updated
This guide explains how to connect your ClickHouse database to Jet Admin in a few simple steps.
Last updated
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.
Log in to Jet Admin: Open Jet Admin and navigate to your application.
Add a New Resource: In the left-side menu, go to the Data section and click Add Resource.
Select ClickHouse DB: From the list of data sources, choose ClickHouse DB.
Provide Connection Details: Enter the required credentials, including the Host, Port, Username, Password, and Database Name.
Test the Connection: Click Test Connection to ensure Jet Admin can successfully connect to your ClickHouse database.
Select Tables: Once the connection is established, choose the tables you want to use in Jet Admin.
Troubleshooting Tips
Connection Issues: Double-check the credentials and ensure your ClickHouse instance is accessible.
Firewall Rules: If your ClickHouse DB is hosted in a secure environment, confirm that Jet Admin's IP addresses are whitelisted.
SSL/TLS: If your database requires encrypted connections, ensure SSL/TLS settings are correctly configured in ClickHouse and Jet Admin.
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.