SourceJDBCParameters - EventBridge - Alibaba Cloud Documentation Center

Parameter	Type	Description
	object
JdbcUrl	string	The JDBC connection URL. ClickHouse example: `jdbc:clickhouse://host:8123/database`; MySQL example: `jdbc:mysql://host:3306/database`. The system automatically identifies the database type.
Username	string	The database username.
Password	string	The database password.
QueryMode	string	The query mode. Valid values: `bulk` (full query); `incrementing` (incrementing column tracking); `timestamp` (timestamp tracking); `timestamp_incrementing` (timestamp and incrementing column dual tracking).
TableName	string	The target table name. This parameter is mutually exclusive with CustomQuery. Required when custom SQL is not used.
IncrementingColumn	string	The incrementing column name. Required when QueryMode is set to `incrementing` or `timestamp_incrementing`.
TimestampColumn	string	The timestamp column name. Required when QueryMode is set to `timestamp` or `timestamp_incrementing`.
PollingInterval	integer	The polling interval, in seconds. Minimum value: 10. Default value: 60.
BatchSize	integer	The maximum number of rows returned per query. Default value: 1000. Maximum value: 10000.
QueryTimeout	integer	The SQL query timeout period, in seconds. Default value: 30. Maximum value: 300.
CustomQuery	string	The custom SQL query statement (advanced mode). This parameter is mutually exclusive with TableName.
Network	string	The network type. Valid values: `PublicNetwork` (public network); `PrivateNetwork` (VPC private network, requires VpcId, VSwitchIds, and SecurityGroupId to be configured).
VpcId	string	The VPC ID. Required when Network is set to PrivateNetwork.
VSwitchIds	string	The vSwitch ID. Required when Network is set to PrivateNetwork.
SecurityGroupId	string	The security group ID. Required when Network is set to PrivateNetwork.

object

JdbcUrl

string

The JDBC connection URL. ClickHouse example: jdbc:clickhouse://host:8123/database; MySQL example: jdbc:mysql://host:3306/database. The system automatically identifies the database type.

Username

string

The database username.

Password

string

The database password.

QueryMode

string

The query mode. Valid values: bulk (full query); incrementing (incrementing column tracking); timestamp (timestamp tracking); timestamp_incrementing (timestamp and incrementing column dual tracking).

TableName

string

The target table name. This parameter is mutually exclusive with CustomQuery. Required when custom SQL is not used.

IncrementingColumn

string

The incrementing column name. Required when QueryMode is set to incrementing or timestamp_incrementing.

TimestampColumn

string

The timestamp column name. Required when QueryMode is set to timestamp or timestamp_incrementing.

PollingInterval

integer

The polling interval, in seconds. Minimum value: 10. Default value: 60.

BatchSize

integer

The maximum number of rows returned per query. Default value: 1000. Maximum value: 10000.

QueryTimeout

integer

The SQL query timeout period, in seconds. Default value: 30. Maximum value: 300.

CustomQuery

string

The custom SQL query statement (advanced mode). This parameter is mutually exclusive with TableName.

Network

string

The network type. Valid values: PublicNetwork (public network); PrivateNetwork (VPC private network, requires VpcId, VSwitchIds, and SecurityGroupId to be configured).

VpcId

string

The VPC ID. Required when Network is set to PrivateNetwork.

VSwitchIds

string

The vSwitch ID. Required when Network is set to PrivateNetwork.

SecurityGroupId

string

The security group ID. Required when Network is set to PrivateNetwork.