NOTE: This example code is fictional and meant for illustration purpose only. DuckDB Version: 1.1.2
We have the following scenario. We receive sales transaction data in batches:
transaction_id,trx_ts,item_id,total
0, "2024-07-31 20:00:00",i0_04_00,2
1, "2024-08-01 11:10:00",i0_01_00,2
2, "2024-08-01 11:20:00",i0_02_00,1