Skip to main content

Run your first query

This 5-minute tutorial takes you from opening the console to your first result set. You'll need at least one completed backup run.

1. Open the console and pick a snapshot​

  1. Click Query Console in the sidebar (under Operations).
  2. In the Choose a snapshot dialog, pick the backup, then the run (snapshot) you want to explore — newest first. A readiness badge below the pickers shows whether the run is Prepared for querying.
  3. If it isn't prepared yet, click Prepare data, select the objects you plan to query, and wait for the badge to read Prepared — usually a few minutes, and only needed once per snapshot. See Preparing snapshots.

[SCREENSHOT REQUIRED: Snapshot picker with readiness badges]

The console remembers your last snapshot, so the next visit drops you right back where you were.

2. Explore the schema​

The Tables tree in the left sidebar lists every object captured in the snapshot. Expand a table to see its columns with their types, in the same order as in Salesforce.

Click a table name and the console loads a starter query for it:

SELECT * FROM Account LIMIT 200

3. Run it​

Press ⌘Enter (Mac) or Ctrl+Enter (Windows/Linux), or click Run. Results appear in the grid below the editor.

[SCREENSHOT REQUIRED: Query results grid with data]

4. Try something real​

-- Opportunities won this year, biggest first
SELECT Name, Amount, CloseDate, StageName
FROM Opportunity
WHERE StageName = 'Closed Won'
  AND CloseDate >= '2026-01-01'
ORDER BY Amount DESC

A few things to notice as you go:

  • Autocomplete suggests table and column names as you type.
  • Any Salesforce record Id in the results is a link — click it to open that record in your live org.
  • Click CSV to download the current results.

5. Save it​

Click Save to add the query to your library. It's personal by default; toggle Share with org to make it available to your whole team. See The saved-query library.

Next steps​