Glossary
Definitions of terms used throughout the documentation.
| Term | Definition |
|---|
| Pipeline | A sequence of operations applied to your data, shown as cards in the sidebar on the left of the screen. Each card is one transformation step. |
| Operation | A data transformation (filter, join, pivot, etc.) that generates SQL and adds a step to the pipeline. |
| Function Panel | The configuration panel that opens when you select an operation. Set parameters, preview SQL, and click Apply. |
| Column Explorer | The strip of cards above the grid that shows visual summaries (histograms, value counts, time-series) for the columns you open. |
| Explore Card | A card in the Column Explorer showing the distribution of a single column. |
| View | An independent pipeline and grid state within a file. Each file can have multiple views, like worksheets in Excel. |
| Condition Builder | A visual interface for building WHERE conditions. Compose rules with AND/OR logic without writing SQL. |
| Intent | The AI-powered feature that converts natural language descriptions into SQL expressions. Requires an API key. |
| DuckDB | The SQL engine that powers ExploreMyData. Runs entirely in your browser via WebAssembly (WASM). |
| Apply Results Into | Choose where an operation's output goes: New Column, where you pick the name and type, or Existing Column, which overwrites a column you select. An existing column keeps its own type, so values that cannot be converted land as empty. |