Skip to main content

ClickHouse

Squid can connect to a ClickHouse database to serve as the data source for your Squid application.​

ClickHouse is a column-oriented database that enables its users to generate powerful analytics in real-time using SQL queries.

To integrate your ClickHouse database with Squid, complete the following steps:

  1. Open the Squid Console and select your application to use with ClickHouse.
  2. Click the Integrations tab, and then click Available integrations to view all integrations.
  3. Select the ClickHouse integration.
  4. Provide the following configuration information:
  • Integration ID - Choose an ID that is brief and helps identify the integration.
  • Database URL - The URL of the ClickHouse database you want to connect. For example, https://your-clickhouse-server-host:8123.
  • Database username - The username of your ClickHouse account.
  • Database password - The password of your ClickHouse account. The password is securely stored using Squid Secrets.
  • Database name - The name of the ClickHouse database you want to connect.
  • SSL enabled - Toggle to indicate if your ClickHouse database is SSL enabled.

Once you've entered the connection information, click Test connection to confirm that the connection is configured properly, then click Add integration.

Clickhouse integration

Securing your database​

By default, security rules are required, and in a production environment, it's essential to never allow access to the integration without them. Learn more about securing your database data in the security rules documentation.

To learn how to work with ClickHouse data in Squid, view the Client SDK documentation.