7 ms·
Author here—this article was meant to highlight how you can optimize writes to CH with streams. If you want to directly insert data into ClickHouse with MooseS
by oatsandsugar 1y ago
Author here—this article was meant to highlight how you can optimize writes to CH with streams.
If you want to directly insert data into ClickHouse with MooseStack, we have a direct insert method that allows you to use ClickHouse's bulkload methods.
Here's the implementation: https://github.com/514-labs/moosestack/blob/43a2576de2e227437251ea398af653d878d2ec5b/packages/ts-moose-lib/src/dmv2/sdk/olapTable.ts#L920 https://github.com/514-labs/moosestack/blob/43a2576de2e22743...
Documentation is here: https://docs.fiveonefour.com/moose/olap/insert-data#performance-optimization https://docs.fiveonefour.com/moose/olap/insert-data#performa...
Would love to hear your thoughts on our direct insert implementation!