How to import data into a Data Warehouse for ClickHouse® deployment

Reviewed on June 03, 2025

Data federation allows you to query and combine data from multiple sources, enabling seamless analytics across different databases or storage systems without the need to move or duplicate data.

Scaleway Data Warehouse for ClickHouse® allows you to quickly import any type of compatible data into bottomless storage with minimal configuration.

Before you start

To complete the actions presented below, you must have:

A Scaleway account logged into the console
Owner status or IAM permissions allowing you to perform actions in the intended Organization
Signed up to the private beta and received a confirmation email.
Created a Data Warehouse deployment

How to import data using the ClickHouse® CLI

Connecting to the ClickHouse® CLI

Click ClickHouse® under Data & Analytics on the side menu. The Data Warehouse deployment page displays.
Click the name of the Data Warehouse deployment you want to connect to. The overview tab of the deployment displays.
Click Connect next to Frameworks in the Connect to your deployment section. The connection wizard displays.
Select Protocols, then copy the command in the ClickHouse® CLI tab.
In a terminal, paste and execute the copied command to connect to your deployment. Make sure to replace the placeholders with the corresponding values.
```
clickhouse client \
--host <YOUR_DEPLOYMENT_URL> \
--port 9440 \
--secure \
--user scwadmin \
--password '<YOUR_DEPLOYMENT_PASSWORD>'
```
You are now connected to your deployments using the ClickHouse® CLI, you can now import data.

Tip

You can connect to your deployment using the ClickHouse® HTTP console directly from the Overview tab.

Importing data into your deployment from an Object Storage bucket

There are several ways to import data into your Data Warehouse for ClickHouse® deployment, depending on how your data is stored. One of the most common ways is to import it from an Object Storage bucket in any format supported by ClickHouse®.

The s3 table function reads data directly from an Object Storage bucket by specifying the URL of the bucket, the file format, and the data structure.

INSERT INTO your_table
SELECT *
FROM s3('https://my-bucket.s3.scaleway.com/data/my_data.csv', 'CSV', 'column1 String, column2 Int32')

The s3 Storage Engine creates a table that points to a data table stored in an Object Storage bucket, then inserts data from the bucket table into the target table in your Data Warehouse for ClickHouse® deployment.

CREATE TABLE your_table_s3
    ENGINE = S3('https://my-bucket.s3.scaleway.com/data/my_data.csv', 'CSV', 'column1 String, column2 Int32')

The clickhouse-client executes an INSERT query to populate a table in your deployment by specifying the URL of the source Object Storage bucket and the file format.

clickhouse-client --query="INSERT INTO your_table FORMAT CSVWithNames" \
--url "https://my-bucket.s3.scaleway.com/data/my_data.csv" \
--input_format_with_names=1