dbt-clickhouse icon indicating copy to clipboard operation
dbt-clickhouse copied to clipboard

Asynchronous insert mode with insert into values

Open ikeniborn opened this issue 1 year ago • 0 comments

I propose to implement the insertion parameter via insert into values. When inserting through this method, you can use the parameters of asynchronous insertion into the database, which can effectively affect the utilization of resources. When the parameter is enabled, the insert block is generated as SQLInsert format

insert INTO table ( dttm, coinmarketcap_token_id, median, low, high, updated_dttm ) VALUES ( '2024-01-14 11:00:00', 22197, 4.992018277588e -12, 4.992018277588e -12, 4.992018277588e -12, '2024-01-14 11:17:20' );

ikeniborn avatar Jan 14 '24 11:01 ikeniborn