ClickHouse

ClickHouse is a fast, open-source column-oriented OLAP database designed for real-time analytical queries over large datasets. With BonData, you can connect directly to your ClickHouse database to read, enrich, and act on your data within Agent workflows.

Database Connection

BonData connects to ClickHouse over a secure interface. Both ClickHouse Cloud and self-hosted deployments are supported.

Step 1: Gather Your Connection Details

ClickHouse Cloud
Self-Hosted

Log in to the ClickHouse Cloud console
Select your service and open Connect
Copy the host (e.g., abc123.us-east-1.aws.clickhouse.cloud)
Use port 8443 for the HTTPS interface (or 9440 for the native TLS interface)

Step 2: Create a Read-Only User (Recommended)

For security, create a dedicated read-only user for BonData:

-- Create a user for BonData
CREATE USER bondata_user IDENTIFIED BY 'your_secure_password';

-- Grant read access to your database
GRANT SELECT ON your_database.* TO bondata_user;

Step 3: Gather Connection Details

Collect the following information:

Host: Your ClickHouse server hostname
Port: 8443 (HTTPS) or 9440 (native TLS)
Database: The name of the database to connect to
User: The username created above
Password: The password for the user

Step 4: Connect in BonData

Enter your connection details in BonData to establish the connection.

Required Fields

Field	Description
Host	Database server hostname (e.g., `abc123.us-east-1.aws.clickhouse.cloud`)
Port	HTTPS interface `8443` or native TLS interface `9440`
Database	Name of the database to connect to
User	Database username
Password	Database password

BonData connects to ClickHouse over TLS. ClickHouse Cloud services require a secure connection; for self-hosted deployments, enable the HTTPS or native TLS port before connecting.

Available Data

Once connected, BonData can sync:

Tables - All tables the user has SELECT access to
Views - Standard views accessible to the user
Materialized Views - Materialized views accessible to the user
Custom Queries - Run custom SQL queries to extract specific data

Azure Synapse Analytics

SQLite

Overview

AI & LLM Providers

Databases

Business Applications

Customer Success

Marketing & Sales

HR & People

Developer Tools

Cloud Storage

Notifications

Analytics & BI

Enterprise & Operations

Other

Database Connection

Step 1: Gather Your Connection Details

Step 2: Create a Read-Only User (Recommended)

Step 3: Gather Connection Details

Step 4: Connect in BonData

Required Fields

Available Data

​Database Connection

​Step 1: Gather Your Connection Details

​Step 2: Create a Read-Only User (Recommended)

​Step 3: Gather Connection Details

​Step 4: Connect in BonData

​Required Fields

​Available Data

Database Connection

Step 1: Gather Your Connection Details

Step 2: Create a Read-Only User (Recommended)

Step 3: Gather Connection Details

Step 4: Connect in BonData

Required Fields

Available Data