Save a definition
fastero_save_definitionSave or remove one shared definition, so every teammate's Claude and Fastero's assistant use it. kind is metric (expression: one aggregate SQL expression, e.g. SUM(CASE WHEN status = 'paid' THEN amount END)), dataset (table, fields with descriptions and isTime, primaryKey) or relationship (from and to dataset names, fromColumns and toColumns). Give connectionId when it only holds for one database, where it takes the place of one of its kind and name that holds for all; leave it out when it holds for all. The same kind and name for the same connection replaces the one saved before; remove: true deletes it. Every save is versioned. Save a definition when the user confirms what a number means, not on a guess.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | No | ||
| from | No | ||
| kind | Yes | ||
| name | Yes | ||
| grain | No | ||
| table | No | For a dataset: the table, e.g. public.invoices. | |
| fields | No | ||
| remove | No | ||
| synonyms | No | ||
| toColumns | No | ||
| expression | No | ||
| primaryKey | No | ||
| description | No | ||
| fromColumns | No | ||
| connectionId | No | A data connection’s id, from fastero_list_connections; fastero_create_file_connection makes one of an uploaded CSV or Excel file. | |
| instructions | No | How to use it, e.g. "exclude test accounts". |