This topic describes how to purchase and use an ApsaraDB ClickHouse cluster. This helps new users get started with ApsaraDB ClickHouse.

After you complete the operations in this tutorial, a data table named ontime_local is generated. You can query and analyze data in this table.

In this tutorial, you perform the following operations: 总流程图
  1. Grant permissions: describes how to use an Alibaba Cloud account to grant permissions to a Resource Access Management (RAM) user. A RAM user must be granted the AliyunClickHouseFullAccess permission before the RAM user follows the instructions that are provided in this tutorial to use ApsaraDB ClickHouse.
  2. Create a cluster: describes how to create an ApsaraDB ClickHouse cluster. In this example, a subscription cluster of the Double-replica Edition is created.
  3. Create an account: describes how to create a database account for an ApsaraDB ClickHouse cluster. In this example, a database account is created and granted the required DML and DDL permissions.
  4. Configure a whitelist: describes how to configure a whitelist for an ApsaraDB ClickHouse cluster to allow access from external devices.
  5. Connect to a cluster: describes how to connect to an ApsaraDB ClickHouse cluster. In this example, Data Management (DMS) is connected to the ApsaraDB ClickHouse cluster.
  6. Create a database: describes how to use DMS to create a database for an ApsaraDB ClickHouse cluster.
  7. Create a table: describes how to use DMS to create a local table and a distributed table in an existing database. In this example, a table whose data type corresponds to the type of the On Time dataset is created.
  8. Import data: describes how to use the client named clickhouse-client to import data to ApsaraDB ClickHouse. In this example, the On Time dataset is imported to an existing distributed table.