Olambus

DocsAnalyze

Analyze

Query the cleaned table with SQL, Python, or R. Optionally describe what you want in plain English and generate a starter script.

Open Analyze

Choose Analyze in the pipeline (⌘/Ctrl+3). Pick a language with the toggle: SQL, Python, or R.

Analyze editor with language toggle

Write and run a query

  1. Enter your statement or script in the editor.
  2. Run with Run query, Run Python, or Run R (or ⌘/Ctrl+Enter where supported). The button shows Running… while the job is in flight.
  3. Inspect the result table below the editor.

Runtimes: SQL runs on the server with DuckDB. Python and R run as server-side language jobs. Prefer SQL for fast tabular cuts; use Python/R when you need libraries or custom logic.

Describe in plain English

  1. Use the bar labeled something like Describe in plain English…
  2. Choose Generate to draft SQL/Python/R from your prompt.
  3. Read the draft carefully, edit if needed, then run it. Treat generated code like any other code — verify results before exporting.
NL generate bar above the editor

Send results to Visualize

When a result set is ready, use Visualize to open the chart builder with that data. You can also open the Visualize step directly from the pipeline.

Tip: Keep analysis reproducible — leave a short note in Notes (status bar) about the question you answered and the query you trust.

Next

Build charts in Visualize.