---
updatedAt: 2026-10-30T12:01:43.000Z
agentTools:
  projectIndex: https://partner-dwh.readme.io/llms.txt
---

# Operator Lists

Table name: `operator_lists`

One row per list your operator (or one of its sub-operators) has created in Monta, for example the Hub Lists that
group your sites or charge points by product. A list can hold one type of entity (see `list_type`). The members of
each list are in [Operator List Items](operator_list_items.md).

Deleted lists stay in the table with `deleted_at` set. Filter on `deleted_at is null` to get the lists that are in
use.

**SQL:** `operator_lists`

## Schema

| Column Name                 | Data Type      | Description                                                                                                                                                                    |
| :-------------------------- | :------------- | :----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Primary ID**              |                |                                                                                                                                                                                |
| id                          | INTEGER        | Primary key of the list                                                                                                                                                        |
| **Other IDs**               |                |                                                                                                                                                                                |
| operator\_id                | INTEGER        | The operator that owns the list. References `operators.id`                                                                                                                     |
| created\_by\_user\_id       | INTEGER        | The user who created the list, if known                                                                                                                                        |
| **Timestamps**              |                |                                                                                                                                                                                |
| created\_at                 | TIMESTAMP\_NTZ | When the list was created                                                                                                                                                      |
| updated\_at                 | TIMESTAMP\_NTZ | When the list was last updated                                                                                                                                                 |
| deleted\_at                 | TIMESTAMP\_NTZ | When the list was deleted; empty while the list is in use                                                                                                                      |
| **Filters**                 |                |                                                                                                                                                                                |
| is\_main\_operator\_match   | BOOLEAN        | True if the list belongs to your main operator                                                                                                                                 |
| is\_parent\_operator\_match | BOOLEAN        | True if the list belongs to an operator that has your main operator as its parent                                                                                              |
| **Attributes**              |                |                                                                                                                                                                                |
| name                        | VARCHAR        | Name of the list                                                                                                                                                               |
| description                 | VARCHAR        | Free-text description of the list; may be empty                                                                                                                                |
| source                      | VARCHAR        | How the members are managed: `MANUAL` (picked by hand) or `FILTER` (kept in line with a saved filter)                                                                          |
| list\_type                  | VARCHAR        | The one entity type the list can hold: `user`, `team`, `charge_point`, `charge_points_public`, `site`, `charge_key` or `vehicle`. Empty if the list is not limited to one type |
| item\_expiry\_days          | INTEGER        | Default lifetime in days (1-365) of members added to the list; empty means members never expire                                                                                |

## Data inclusion criteria

* Lists owned by your main operator or by one of its sub-operators (`operators.id = operator_id`)

## Data flow

| Upstream tables | Downstream tables     |
| :-------------- | :-------------------- |
| `operators`     | `operator_list_items` |

## Alignment

### Monta API

* Aligns with Monta API [get/operator-lists](https://docs.partner-api.monta.com/reference/get-operator-lists) endpoint
* The table does not include the API's `itemCount` and `itemCounts` (count the rows in `operator_list_items` instead), the saved filter (`filterDefinition`), or the sync fields (`syncMode`, `lastSyncedAt`, `lastSyncStatus`, `pendingSyncRun`)
* The table also returns deleted lists; see `deleted_at`