| description |
|---|
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.
- 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.
{% @arcade/embed flowId="DwGTnOClvIRVhPVtMg3B" url="https://app.arcade.software/share/DwGTnOClvIRVhPVtMg3B" %}
{% hint style="info" %} 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. {% endhint %}