SQL Reference
INSERT
Insert rows into append, keyed, and attribute tables with the VALUES form.
Row VALUES
INSERT INTO a VALUES (1, 'x');
INSERT INTO a (seq, v) VALUES (1, 2.0);Multiple rows in one statement:
INSERT INTO trades (id, market, amount) VALUES
(1, 'BTC-USD', 4120),
(2, 'ETH-USD', 2880);Attribute tables
Insert the entity id plus the attributes:
INSERT INTO acct (id, bal, tier) VALUES
(1, 100, 'gold'),
(2, 200, 'silver');
INSERT INTO acct (id, bal) VALUES (3, 300);For high-throughput ingestion, the engine also exposes a binary columnar INSERT path over the wire protocol (ADR-045). See Wire protocol.