Data Sources
ClickHouse
Connect AI Squared to ClickHouse
This guide will help you configure the ClickHouse Connector in AI Squared to access and use your ClickHouse data.Prerequisites
Before proceeding, ensure you have the necessary URL, username, and password from ClickHouse.Step-by-Step Guide to Connect to ClickHouse
Step 1: Navigate to ClickHouse Console
Start by logging into your ClickHouse Management Console and navigating to the ClickHouse service.- Sign in to your ClickHouse account at ClickHouse.
- In the ClickHouse console, select the service you want to connect to.
Step 2: Locate ClickHouse Configuration Details
Once you’re in the ClickHouse console, you’ll find the necessary configuration details:-
HTTP Interface URL:
- Click on the “Connect” button in your ClickHouse service.
- In “Connect with” select HTTPS.
- Find the HTTP interface URL, which typically looks like
http://<your-clickhouse-url>:8443. Note down this URL as it will be used to connect to your ClickHouse service.
-
Username and Password:
- Click on the “Connect” button in your ClickHouse service.
- Here, you will see the credentials needed to connect, including the username and password.
- Note down the username and password as they are required for the HTTP connection.
Step 3: Configure ClickHouse Connector in Your Application
Now that you have gathered all the necessary details, enter the following information in your application:- HTTP Interface URL: The URL of your ClickHouse service HTTP interface.
- Username: Your ClickHouse service username.
- Password: The corresponding password for the username.
Step 4: Test the ClickHouse Connection
After configuring the connector in your application:- Save the configuration settings.
- Test the connection to ClickHouse from your application to ensure everything is set up correctly.
- Run a test query or check the connection status to verify successful connectivity.
Supported sync modes
| Mode | Supported (Yes/No/Coming soon) |
|---|---|
| Incremental sync | YES |
| Full refresh | Coming soon |