1. Overview

After configuring the ClickHouse data source, you can use Data Fusion > Task Management function to import its data into the divine data table or entity, easy to use in the report, analysis model, intelligent operations and other modules.

Before configuring a data source, please refer to the following to confirm that your ClickHouse data source meets the requirements:

Data Source TypeData Source NameVersion RequirementUser Permission RequirementOther Requirements
Database ClassClickHouse23.X versionSELECT PermissionNone

2. Add ClickHouse Data Source

  1. Select Data Fusion > Universal Data Access > Data Source Management.
  2. Click All Data Sources Tab page.
  3. Click ClickHouse data source.
  4. Click on the top right corner Create button.
  5. Fill inClickHouse connection information.
    1. Data Source Connection Name: User-defined by you, is the unique identification of the data source connection in the platform.
    2. Server : IP address and port for connecting to the data source. In cluster scenarios, you can configure multiple server addresses. Use commas to separate the IP addresses.
    3. User name: Valid user name for the data source connection.
    4. Password: Specifies the valid password of the user name, optional.
    5. Connection parameters:Optional, you can customize the connection parameters of the data source, please use when multiple parameters& to divide, for example: key1=true&key2=false.
  6. Click Test Connection button.
  7. Click Submit button.

3. Manage Data Sources

  1. Select Data Fusion > Universal Data Access > Data Source Management.
  2. Click Added data source Tab page.
  3. ClickClickHouse data source.
    1. Edit: Support modifying all configuration parameters of data connection.
    2. Delete: Delete the current connection.

If the current data connection is in use by a task, modifying or deleting the connection will cause the task to fail.

4. Mapping rules for data table field types

When importing data from a ClickHouse data source to the Oracle data table, a field type mapping error may result in a content conversion error or a task execution failure. Configure the field mapping according to the following rules, and the data conversion is safe:

Original Field TypeData Table Field Type
UInt8NUMBER / INT / BIGINT
UInt16NUMBER / INT / BIGINT
UInt32NUMBER / BIGINT
UInt64NUMBER / BIGINT
Int8NUMBER / INT / BIGINT
Int16NUMBER / INT / BIGINT
Int32NUMBER / INT / BIGINT
Int64NUMBER / BIGINT
Float32NUMBER
Float64NUMBER
DecimalNUMBER
StringSTRING
FixedStringSTRING
DateTIMESTAMP
DateTimeTIMESTAMP
DateTime64TIMESTAMP
UUIDSTRING
EnumSTRING
DomainSTRING

Instructions

  1. The primitive types mentioned above are currently supported ClickHouse field types
  2. If a task is imported with an unsupported type field, the task fails to be executed