Domain Integration

ClickHouse clusters by default have security restrictions preventing egress traffic but can be integrated with public domains to enable access.

Once a domain is integrated, the cluster will be able to use the URL table functions to read and write data to that domain.

Clusters on the Netapp Instaclustr managed platform are secured through egress firewall rules to protect against data exfiltration. Integrating with Domains adds a whitelist rule to the firewall enabling access. Consider the security risk before enabling a Domain integration.

How To Enable

The following steps explain how to integrate a ClickHouse cluster with a Domain.

1. First select the “Integrations” option in console. The page will show existing integrations.

2. Select “Add New Integration” to configure a new
3. For type select “Domain” then specify the domain to integrate with.
4. Finally press “Add” to configure the integration.
5. The Integrations table now shows the newly configured integration. An integration can be deleted by pressing the “Delete” button, disabling access to the region.

How To Use ClickHouse URL Table Engine

ClickHouse’s URL table engine provide robust mechanisms for working with large datasets stored on the web. By leveraging these engines, you can efficiently manage and query your data directly from ClickHouse.  Brief examples regarding usage are included below.

For detailed information, refer to the official documentation:

• URL TABLE ENGINE DOCUMENTATION

URL Table Engine

The URL table engine allows you to create tables that read from and write to online data, in a range of formats.

Creating an S3 Table

To create a table using the S3 engine, you need to specify the URL and the format of the data. Here is an example:

 Loading Data

Load data into the table by inserting data directly:

Querying Data

Query data from the URL table as you would with any other table: