CTSDB InfluxDB Data Source

CTSDB InfluxDB Offline Single Table Read Node Configuration
﻿
﻿
﻿
Parameters
Description
Data Source
Select available CTSDB InfluxDB data source in current project.
Database
Supports selecting or manually entering the database name to be read
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 and the database information cannot be fetched directly, you can manually enter the database name. Data synchronization can still be performed when the Data Integration network is connected.
Measurement
Supports selection or manual input of the logical grouping of time series data to be read.
Time Checkpoint Precision
Precision of the start and end time points:
If hours are selected, reading starts/ends from yyyyMMddHH.
If minutes are selected, reading starts/ends from yyyyMMddHHmm.
If seconds are selected, reading starts/ends from yyyyMMddHHmmss.
Start Time Checkpoint
Start time for reading CTSDB InfluxDB (the time in the CTSDB InfluxDB database is in UTC time). You can enter a specific time value or a time parameter. If the time point precision is specified to the second, the time value could be: 20200101123027, and the time parameter: ${yyyyMMddHHmmss}. Time parameters support operators like "+" and "-", e.g., ${yyyyMMddHHmmss-3H}
End Time Checkpoint
End time for reading CTSDB InfluxDB (the time in the CTSDB InfluxDB database is in UTC time). You can enter a specific time value or a time parameter. If the time point precision is specified to the second, the time value could be: 20200101123027, and the time parameter: ${yyyyMMddHHmmss}. Time parameters support operators like "+" and "-", e.g., ${yyyyMMddHHmmss-3H}
Batch Size
Number of entries read from CTSDB InfluxDB each time. Default is 1000 if not filled
Filter Conditions (Optional)
Fill in the corresponding filter statement based on the data type. This statement will serve as the filter condition for the data to be synchronized.
CTSDB InfluxDB Offline Single Table Write Node Configuration
﻿
﻿
﻿
Parameters
Description
Data Destination
Select available CTSDB InfluxDB data source in current project.
Database
Supports selection or manual input of the database name to write 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 and the database information cannot be fetched directly, you can manually enter the database name. Data synchronization can still be performed when the Data Integration network is connected.
Measurement
Supports selection or manual input of the logical grouping of time series data to be written.
Timestamp Precision
The precision of time data, available precisions include ns (Nanoseconds), u (microseconds), ms (Milliseconds), s (Seconds), m (minutes), h (Hour).
Whether to Clear Table
You can manually choose whether to clear the CTSDB InfluxDB Data Table before writing to it.
Batch Submission Size
The batch size for one-time Batch Submission of records. This value can significantly reduce the Network Interaction between the data synchronization system and Vertica, while enhancing overall Throughput. However, if the value is set too high, it may result in OOM (Out Of Memory) exceptions during the data synchronization process.
Pre-Executed SQL
SQL statements executed before the synchronization task. Fill in the SQL according to the correct SQL syntax corresponding to the data source type.
Pre-Executed SQL
SQL statements executed after the synchronization task. Fill in the SQL according to the correct SQL syntax corresponding to the data source type.
﻿

Was this page helpful?

You can also Contact Sales or Submit a Ticket for help.

Yes

Parameters	Description
Data Source	Select available CTSDB InfluxDB data source in current project.
Database	Supports selecting or manually entering the database name to be read 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 and the database information cannot be fetched directly, you can manually enter the database name. Data synchronization can still be performed when the Data Integration network is connected.
Measurement	Supports selection or manual input of the logical grouping of time series data to be read.
Time Checkpoint Precision	Precision of the start and end time points: If hours are selected, reading starts/ends from yyyyMMddHH. If minutes are selected, reading starts/ends from yyyyMMddHHmm. If seconds are selected, reading starts/ends from yyyyMMddHHmmss.
Start Time Checkpoint	Start time for reading CTSDB InfluxDB (the time in the CTSDB InfluxDB database is in UTC time). You can enter a specific time value or a time parameter. If the time point precision is specified to the second, the time value could be: 20200101123027, and the time parameter: ${yyyyMMddHHmmss}. Time parameters support operators like "+" and "-", e.g., ${yyyyMMddHHmmss-3H}
End Time Checkpoint	End time for reading CTSDB InfluxDB (the time in the CTSDB InfluxDB database is in UTC time). You can enter a specific time value or a time parameter. If the time point precision is specified to the second, the time value could be: 20200101123027, and the time parameter: ${yyyyMMddHHmmss}. Time parameters support operators like "+" and "-", e.g., ${yyyyMMddHHmmss-3H}
Batch Size	Number of entries read from CTSDB InfluxDB each time. Default is 1000 if not filled
Filter Conditions (Optional)	Fill in the corresponding filter statement based on the data type. This statement will serve as the filter condition for the data to be synchronized.

Parameters	Description
Data Destination	Select available CTSDB InfluxDB data source in current project.
Database	Supports selection or manual input of the database name to write 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 and the database information cannot be fetched directly, you can manually enter the database name. Data synchronization can still be performed when the Data Integration network is connected.
Measurement	Supports selection or manual input of the logical grouping of time series data to be written.
Timestamp Precision	The precision of time data, available precisions include ns (Nanoseconds), u (microseconds), ms (Milliseconds), s (Seconds), m (minutes), h (Hour).
Whether to Clear Table	You can manually choose whether to clear the CTSDB InfluxDB Data Table before writing to it.
Batch Submission Size	The batch size for one-time Batch Submission of records. This value can significantly reduce the Network Interaction between the data synchronization system and Vertica, while enhancing overall Throughput. However, if the value is set too high, it may result in OOM (Out Of Memory) exceptions during the data synchronization process.
Pre-Executed SQL	SQL statements executed before the synchronization task. Fill in the SQL according to the correct SQL syntax corresponding to the data source type.
Pre-Executed SQL	SQL statements executed after the synchronization task. Fill in the SQL according to the correct SQL syntax corresponding to the data source type.

tencent cloud

New User Offers

Next-Generation CDN：EdgeOne

Elasticsearch Service free trial

Free Tier

Tencent Cloud Startup Program

Special Offers

Lighthouse Special Offers

Cloud Object Storage Special Offers

Featured Products

New Products

Education

Tencent Cloud Online Education Solutions

Gaming

Gaming Solution

Game Media Solutions

E-commerce

E-commerce retail solutions

Audio & Video

Audio/Video Solution

LVB Recording Solution

Interactive Classroom Solution

Interactive Live Streaming Solution

Audio Chat Social Networking Solution

Financial Services

Financial Services Solution

Compute

Cloud Virtual Machine

Auto Scaling

Batch Compute

CVM Dedicated Host

Database

TencentDB for MySQL

TencentDB for Redis®

TencentDB for CTSDB

TDSQL for MySQL

Data Transfer Service

TencentDB for MongoDB

TencentDB for PostgreSQL

TencentDB for SQL Server

Video Service

Cloud Streaming Services

Video on Demand

Media Processing Service

Cloud Application Rendering

Cloud Contact Center

Game Multimedia Engine

Chat

Real-time Communication

Tencent Effect SDK

AI and Machine Learning

Image Creation Large Model

Face Fusion

eKYC

Optical Character Recognition

Video Creation Large Model

Industry Applications

Tencent HealthCare Omics Platform

Container and Middleware

TDMQ for CKafka

Serverless Cloud Function

Tencent Kubernetes Engine

Tencent Kubernetes Engine for Serverless

Networking

Cloud Load Balancer

Virtual Private Cloud

Direct Connect

Cloud Connect Network

NAT Gateway

VPN Connection

Bandwidth Package

Anycast Internet Acceleration

Elastic Network Interface

Flow Logs

Global Application Acceleration Platform

Security

Captcha

Cloud Workload Protection Platform

Data Security Governance Center

Key Management Service