Glossary
Definitions of terms used throughout the documentation.
| Term | Definition |
|---|---|
| Pipeline | A sequence of operations applied to your data, shown as cards at the bottom 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 dialog that opens when you select an operation. Set parameters, preview SQL, and click Apply. |
| Column Explorer | The right sidebar that shows visual summaries (histograms, value counts, time-series) for each column. |
| 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: create a new column, overwrite an existing column, or replace inline. |