Script Development / ClickHouse

The ClickHouse connector operation object primarily provides some data methods.

DFF.CONN(...) parameters are as follows:

Parameter	Type	Required / Default	Description
`connector_id`	str	Required	Connector ID
`database`	str	`None`	Specify database

`.query(...)`

Execute SQL statement, parameters are as follows:

Parameter	Type	Required / Default	Description
`sql`	str	Required	SQL statement, which can contain parameter placeholders. `?` represents parameters that need escaping; `??` represents parameters that do not need escaping
`sql_params`	list	`None`	SQL parameters

Example
sql = 'SELECT * FROM ?? WHERE age > ?'
sql_params = ['demo_table', 50]
result = helper.query(sql, sql_params=sql_params)

query(...) and non_query(...) internally use DFF.SQL(...) to construct SQL statements and support constructing complex dynamic SQL statements.

Such as WHERE IN (...) with an uncertain number of values, or INSERT INTO ... VALUES ... for batch data writing, etc.