# What cherry can do

> Everything cherry can read, build and change, grouped by what it does, and which parts depend on your role, your workspace's switches and your edition.

cherry's abilities come in families. Three things decide which of them you get in a given conversation: your role, the switches your workspace has set under **Settings · cherry**, and your edition.

## The short version

- **Everyone who can open the console** can ask cherry questions, have it search text, have it answer how-to questions from these docs, have it take them to a page, and have it remember things.
- **Owners, admins and members** can also have cherry change the semantic fluid, create and change reports, and run learn from my data.
- **Owners and admins** can also have cherry build in the warehouse, start syncs, load rows and schedule report emails.
- **Viewers** get answers and nothing else. cherry changes nothing for a viewer whatever the switches say.

## Reading and answering

These are what a chat is, so they are always on.

| What cherry does | Who |
|---|---|
| Looks things up on your semantic fluid by name: metrics, dimensions, named filters, tables | Everyone |
| Describes a table: its columns, key, and the joins it can reach | Everyone |
| Runs a query composed from your definitions and returns rows (at most 50 at a time) | Everyone |
| Searches the text in your records, when the workspace has an index | Everyone, on Standard, Enterprise and trials |
| Searches sanda's own documentation for how something works, and links the page | Everyone, on every edition |
| Runs read-only SQL of its own when the fluid cannot express the question | Owners, admins and members, if the **sql** switch is on |
| Looks at your connections, their last sync and your warehouses' capacity | Everyone, if the **data** switch is on |

The documentation search has no switch. It is how cherry answers "how do I…", "what does this feature do" and "what does my plan include" from these pages rather than from memory, and it is not used for questions about your own data. It makes no AI call of its own, so it adds nothing to your daily AI limit beyond the reply that quotes it.

cherry prefers a query composed from your definitions over SQL it writes itself. It uses SQL of its own only for things like window functions and cohorts, says why, and shows you the statement.

## Defining things on the semantic fluid

Switch: **semantics**. Owners, admins and members.

- Put landed tables on the map, and mark a table as a fact or a dimension.
- Define a metric, dimension, filter, relationship, alias, category or dataset.
- Accept or reject what learn from my data proposed, singly or in bulk.
- Take tables off the map, and delete a definition. These always ask first.

See [semantic fluid](https://docs.sanda-os.com.au/semantic-fluid) for what each of these is.

## Building in the warehouse

Switch: **modelling**. Owners and admins.

- Write a view or procedure, replace one, rebuild a materialized view, or drop one (drops always ask first).
- Schedule a task, run it now, pause or resume it, and read its history.
- Read tuning advice for a warehouse and apply the findings you choose.

Every build runs on your compute and is billed to your workspace. See [modelling](https://docs.sanda-os.com.au/modelling).

## Reports

Switch: **reports**.

| What cherry does | Who |
|---|---|
| Creates a report, places tiles, charts, tables and written analysis, and changes a report's filters and blocks | Owners, admins and members, on reports they can edit |
| Reads a report, and lists the reports you can open | Everyone |
| Schedules a report to be emailed, changes or pauses a delivery, sends one now, removes one | Owners and admins |

A report shared with you to read cannot be changed by cherry for you. Every change cherry makes to a report is kept as a version you can restore from the report's history. Anything that emails a report always asks first. See [build reports with cherry](https://docs.sanda-os.com.au/reports/build-with-cherry).

## Data

Switch: **data**.

| What cherry does | Who |
|---|---|
| Starts a sync on a connection | Owners and admins |
| Runs learn from my data, which proposes tables, metrics, dimensions and relationships | Owners, admins and members |
| Loads a small table of rows you give it into the warehouse | Owners and admins |

Learn from my data files proposals, and nothing goes live until you accept them. It uses AI, so it counts towards your daily AI limit. cherry runs it only when you ask. See [learn from your data](https://docs.sanda-os.com.au/semantic-fluid/learn).

## Setting up a workspace

cherry reads how far your workspace is set up and draws a checklist under its reply: a warehouse, a source, learn from my data, the review of what it proposed, and a first report. Every step is a button you press, and cherry takes no step you did not ask for. Where a step needs an owner or admin, the checklist says so. See [set up with cherry](https://docs.sanda-os.com.au/get-started/setup-with-cherry).

## Moving you around

cherry can open any console page you ask for, and the conversation goes with you. It can offer next steps as buttons, and hand an unclear ask back to you as a choice.

## Remembering

cherry can keep a fact for later conversations, and search your earlier conversations when you refer back to them. See [memory and conversations](https://docs.sanda-os.com.au/cherry/memory-and-history).

## What decides what you get

**Your role.** cherry acts with your own permissions. It cannot do for you what you could not do yourself in the console.

**The switches.** Owners and admins can turn each of five families off for the whole workspace under **Settings · cherry**: **semantics**, **modelling**, **reports**, **data** and **sql**. A family that is off is not offered to cherry at all. All five are on by default.

**Your edition.** cherry is on every edition. The one part that depends on edition is text search, which is on Standard, Enterprise and trials. On Basic, cherry has no text search to offer.

**Your workspace's state.** In a closed workspace, cherry answers questions and changes nothing.

## What cherry cannot do

cherry has no way to change your plan, billing, team, security settings or integrations, to create or manage search services, to add a connection (credentials go in the wizard), or to run SQL that changes your data. Some of that is available to connected AI assistants under separate permissions. See [MCP permissions](https://docs.sanda-os.com.au/mcp/permissions).

:::links
- [Actions and approvals](https://docs.sanda-os.com.au/cherry/actions-and-approvals): Which of these ask first.
- [Workspace roles](https://docs.sanda-os.com.au/workspace/members-and-roles): What owners, admins, members and viewers can do.
:::
