Mammoth core ideas: workspaces, projects, datasets, views
Mammoth organises data work in seven nested levels: a workspace holds projects, a project holds datasets, each dataset holds batches of rows and opens in one or more views, and each view has a pipeline of tasks. Data flows from a source into a dataset, through a view's pipeline, and out to an export or dashboard. Learn views and pipelines first; the rest builds on them. The Quick start shows these ideas at work on a small file.
The seven levels at a glance
| Level | Container | What it holds | Access set by | Roles |
|---|---|---|---|---|
| 1 | Workspace | Projects, users, plan | Workspace membership | Workspace Owner, Workspace Member |
| 2 | Project | Datasets, connections, automations, dashboards | Project membership | Project Admin, Project Editor, Project Viewer |
| 3 | Dataset | Batches and views | The project | Project role |
| 4 | Batch | Rows of data | The project | Project role |
| 5 | View | A pipeline | The project | Project role |
| 6 | Pipeline | Tasks | The project | Project role |
| 7 | Task | One operation | The project | Project role |
Each level in detail: Workspaces and projects, Datasets and batches, and Views, pipelines and tasks.
Worked example with all seven levels
- Workspace: "Acme Corp" (your company)
- Project: "Q4 Sales Analysis" (your team's area)
- Dataset: "Salesforce Opportunities" (imported data)
- Batch: "December import" (this month's data)
- View: "Sales Pipeline Analysis" (where you work on it)
- Pipeline: five tasks transforming the data
- Tasks: Conditional Filter, Remove Duplicate Rows, Join, Math Function, Group & Pivot
Industry examples
These examples are illustrative.
Financial services: monthly regulatory reporting
Workspace: Example Bank
Project: SOX Compliance
Dataset: General Ledger Transactions
Batch: December (Replace mode)
View: Regulatory Report View
Pipeline: Filter → Categorize → Validate → Aggregate
Tasks: Conditional Filter, Label & Insert Values, Data Check, Group & Pivot
Manufacturing: production quality tracking
Workspace: Acme Manufacturing
Project: Quality Control
Dataset: Production Line Data
Batch: Daily production runs (Combine mode)
View: Quality Metrics
Pipeline: Calculate defect rates → Flag outliers → Trend analysis
Tasks: Math Function, Conditional Filter, Window Function
Hospitality: multi-property revenue analysis
Workspace: Example Hotels
Project: Revenue Management
Dataset: Property Management System Data
Batch: Nightly revenue reports (Replace mode)
View: Executive Revenue
Pipeline: Combine properties → Calculate RevPAR → Compare periods
Tasks: Join, Lookup, Math Function, Group & Pivot
How the structure keeps data secure
Workspace isolation keeps each workspace separate from every other. People see a project's data only as members (Marketing doesn't see Finance's data unless they join the Finance project). Connection scoping keeps credentials with their project. Role-based permissions come from workspace roles (Owner, Member) and project roles (Admin, Editor, Viewer), plus custom roles on the Pro plan. Workspace and project actions are recorded in the Activity log. See Security: sign-in, data security, compliance and audit logs.
Common questions about Mammoth concepts
| Question | Answer |
|---|---|
| Where is my data stored? | In Mammoth's cloud, in your workspace, organised by project, dataset and batch. |
| What's the difference between a dataset and a view? | A dataset is the imported data; a view is where you explore and transform it. |
| Why do I need projects? | They decide who can see and change which data. |
| What happens to my pipeline when I add new data? | The new data runs through the existing pipeline. |
| Can I have several pipelines on the same dataset? | Yes: create more views of the dataset, each with its own pipeline. |
Related
- Build your first pipeline: a hands-on pipeline on sample data.
- Members, roles and custom roles: every permission in one matrix.
- How the pipeline works: how tasks run, task previews and Draft mode.
- Glossary: look up any Mammoth term.
Something wrong? support@mammoth.io