dbt-clickhouse
dbt-clickhouse copied to clipboard
Asynchronous insert mode with insert into values
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'
);