Tencent Cloud WeData
- Product Introduction
- Purchase Guide
- Execute Resource Purchase Description
- Preparations
- Add allowlist /security groups (Optional)
- Operation Guide
- Console Operation
- Execution Resource Group Configuration
- Approval Management
- General Configuration
- Project Management
- Project Execution Resource Group
- Data Integration
- Integration resource configuration and management
- Real-time Synchronization Task Configuration and Operation and Maintenance
- Data Sources Supported by Real-time Synchronization
- Data Source List
- Whole Database Synchronization Task Configuration
- Single Table Synchronization Task Configuration
- Real-time synchronization operation and maintenance
- Real-time OPS
- Monitoring and Alarms
- Offline Synchronization Task Configuration and Operation and Maintenance
- Data Sources Supported by Offline Synchronization
- Data Source List
- DataInLong Offline Synchronization Configuration and Operation and Maintenance
- Data Development：Offline Synchronization, Configuration and Ops
- Offline Synchronization and Ops
- Practical Tutorial
- Data Development
- Engine User Guide
- Task Development
- Task Node Type
- General Node
- Task Scheduling Configuration
- Development Space
- Task Operation and Maintenance
- Data Analysis
- Data Assets
- Data Map
- Metadata Collection
- Metadata Management
- My Data
- My Responsibilities
- Managed by Me
- Configuration Management
- Data Security
- Data protection
- API Documentation
- Making API Requests
- Smart Ops Related Interfaces
- Data Development APIs
- Data Operations Related Interfaces
- Metadata Related Interfaces
- Task Operations APIs
- Instance Operation and Maintenance Related Interfaces
- Data Map and Data Dictionary APIs
- Data Quality Related Interfaces
- DataInLong APIs
- Platform management related APIs
- Data Source Management APIs
- Asset Data APIs
- Related Agreement
DocumentationTencent Cloud WeDataOperation GuideData IntegrationReal-time Synchronization Task Configuration and Operation and MaintenanceData Sources Supported by Real-time SynchronizationData Source ListClickHouse Data Source
ClickHouse Data Source
Last updated: 2024-11-01 17:00:28
ClickHouse Single Table Write Node Configuration
Configure ClickHouse Node
1. On the Data Integration page, in the left sidebar, click Real-time Sync.
2. On the real-time sync page, select Single Table Sync at the top, create new (choose between form and canvas mode) and enter the configuration page.
3. Click the left-side Write, click to select the ClickHouse node and configure the node information.
4. You can refer to the following table for parameter configuration.
Parameters | Description |
Type | ClickHouse |
Data Destination | Select the ClickHouse data source to write to. |
Database | Support selection or manual entry of the library name to be written to. By default, the database bound to the data source is used as the default database. Other databases need to be manually entered. If the data source network is not connected, causing the inability to directly pull library information, you can manually enter the database name. Data synchronization can still be performed when the DataInLong network is connected. |
Table | Support selection or manual entry of the table name to be written to. If the data source network is not connected, causing the inability to directly pull table information, you can manually enter the table name. Data synchronization can still be performed when the DataInLong network is connected. |
Primary Key | Select a field as the primary key for the target table. |
Partition Field | Select one or more fields as partition fields. |
Advanced Settings | You can configure parameters according to business needs. |
5. Preview fields and map them to the fields in the write node configuration, click Save.
ClickHouse Log Collection Write Node Configuration
Parameters | Description |
Data Destination | Select the available ClickHouse data source in the current project. |
Database/Table | Select the corresponding database table from this data source. |
Primary Key | Select a field as the primary key for the data table. |
Partition Field | Select one or more fields as partition fields. |
Advanced Settings (optional) | You can configure parameters according to business needs. |
Data type conversion support
Write
Internal Types | ClickHouse Type |
CHAR | String |
VARCHAR | String,IP,UUID |
STRING | String,EnumL |
BOOLEAN | UInt8 |
BYTES | FixedString |
DECIMAL | Decimal,Int128,Int256,UInt64,UInt128,UInt256 |
TINYINT | Int8 |
SMALLINT | Int16,UInt8 |
INTEGER | Int32,UInt16,Interval |
BIGINT | Int64,UInt32 |
FLOAT | Float32 |
DATE | Date |
TIME | DateTime |
TIMESTAMP | DateTime |
TIMESTAMP_LTZ | DateTime |
INTERVAL_YEAR_MONTH | Int32 |
INTERVAL_DAY_TIME | Int64 |
ARRAY | Array |
MAP | Map |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No