OriginChain docs
dashboard · insert

Insert via the dashboard.

Insert your first row from the dashboard. You will need a running instance, the engine bearer token shown on instance creation (or rotated from /app/keys), and a registered schema — see Schemas in dashboard if you have not registered one yet.

  1. 1. Open /app/query — the query playground.
  2. 2. Pick your instance from the Instance dropdown.
  3. 3. Paste the engine bearer (ocd_…) into Bearer token.
  4. 4. Click the SQL tab.
  5. 5. Paste the INSERT statement below into the editor.
  6. 6. Click Run →. The result panel shows row-affected count and the WAL LSN.
OriginChain CONSOLE DATA Schema Query Backups Logs ACCOUNT Instances Keys Billing DATA / QUERY Query playground INSTANCE prod · ap-south-1 BEARER ocd_•••••••••••••• ASK SQL VECTOR FULL-TEXT GRAPH SQL INSERT INTO shop.customers (id, email) VALUES ( 'c_1', 'a@b.com' ); RUN → 2 3 4 5 6
query playground · sql tab · run button highlighted

SQL samples

basic insert
INSERT INTO shop.customers (id, email)
VALUES ('c_1', 'a@b.com');
idempotent insert
-- Idempotent insert: skips rows whose primary key already exists.
INSERT INTO shop.customers (id, email)
VALUES ('c_1', 'a@b.com')
ON CONFLICT (id) DO NOTHING;

Common errors

  • unknown table 'shop.customers' — register the schema first; see Schemas in dashboard.
  • 401 unauthorized — bearer wrong, expired, or pasted with a stray newline. Rotate from /app/keys.
  • syntax error near … — SQL grammar mismatch. The SQL surface covers SELECT/INSERT/DELETE/JOIN/GROUP BY; UPDATE and multi-statement transactions are not in scope.
  • duplicate primary key — use the ON CONFLICT (id) DO NOTHING form for at-least-once retries.
  • instance not running — resume the instance from /app/instances.