Importing a Dataset

Loading sample data into your ClickHouse® cluster

The Cluster Explorer makes it easy to import a sample dataset into your ClickHouse® cluster. The IMPORT DATASET button is at the top of the page:

When you click it, you’ll see this dialog:

Select a dataset to import

Figure 1 - The Import Dataset wizard

Select the dataset you want and click NEXT. Next you’ll be asked about the database schema:

Use the database schema

Figure 2 - The Schema tab of the Import Dataset wizard

In this example, three tables will be created when you click the button: central_park_weather_observations, taxi_zones, and tripdata. You can expand each of the entries to look at the CREATE statement and change the engine parameters if you want. Clicking the button restores the original schema.

Click to import the data:

Importing the dataset

Figure 3 - Tracking dataset import progress

Clicking the link in Figure 3 takes you to the Running Queries tab.