Help Center/Admin Operations/Use Write mode: dry run first, then commit
Admin Operations•Last updated: 2026-10-20•4 min read

Use Write mode: dry run first, then commit

In Write mode "Dry run" executes your script and rolls it back so you can see its effect; "Commit…" applies it for real after a reason and a typed phrase.

Have questions or need step-by-step guidance on this topic?

Ask AI Copilot

Step-by-Step Procedure

1

Switch to Write

In the SQL Editor click "Write" in the "Mode" switch. It is disabled when writes are off for the environment.

2

Dry run

Enter the SQL and click "Dry run". The result is badged "DRY RUN — rolled back" and the banner says "Dry run complete. Nothing was changed."

3

Give a reason

Fill "Reason (required, recorded in the audit ledger)" with at least 5 characters.

4

Commit

Click "Commit…", read the list of statements, and type COMMIT (or DESTRUCTIVE COMMIT when it contains DROP, TRUNCATE, or DELETE/UPDATE without WHERE) in the box, then click "Commit now".

5

Check the result

The banner reads "Committed." and the result is badged "COMMITTED"; the data grid reloads.

Expected Operational Outcome

The script is applied only after a dry run, a reason and a typed confirmation; the statements are audited.

Troubleshooting & Failure Modes

Symptom: "Add a reason (5+ characters) first; it goes in the audit ledger."
Likely Cause: Commit was clicked with no reason.
Resolution: Fill in the reason field.

Was this guide helpful?

Help us refine our platform documentation