On this page
Kater CLI Explore and try ideas explore card
kater explore card edit
Changes one thing on a card, and gives the card planned again.
A change to its fields works as the same click in the field picker works on a query. Nothing is saved.
Examples
# Make the change in edit.json to its cardkater explore card edit --request-file edit.json# Run the changed card on the warehouse and wait for its chartkater explore card preview --request-file card.jsonOptions
It also takes the global options --json, --kater-root, --scope and --help.
What the request holds
namespaceandcard. The card, as Cards says.bindingsandkind. The card’s fields by role (dimensions,valuesandcolumns), and its chart kind. Both are required. Send the card’s own to keep them. Put another field at the same position to replace one, or send another kind that its fields can draw.change. One change to the card’s fields or to its chart, from the list below.operation. Or a next step over the card’s results: an operation from a field’s menu. Sendchangeoroperation, not both.inputs. The card’s parameter values and filters.
The changes
change has a kind, and the keys that kind takes:
add. Adds a field of the model (field), as it is or with anoperation_idfrom its menu. An example is the sum of a number. It also adds a condition on a field the card does not show, such as a date range.remove. Takes out the item atposition, askater explore card showlists them underpicks.operation. Applies an operation from the menu of a field the card shows (output), with itsparameters. Examples are a date’s grain, Top 10 or a sort.condition. Changes the condition atpositionto anotherfilters.*operation (operation_id), with itsparameters, such as 3 months in place of 12.remove_condition. Takes out the condition atposition.limit. Sets the most rows (limit), ornullfor every row.create_projection. Adds a field made from SQL over the model’s fields, as the field picker’s New Field makes one.presentation. Replaces the chart’s settings: its title, description, style, and each metric’s mark and axis. Withroles, it also sets which fields are on the chart, and in which role. The query does not change.