upstack saved

Cache query parameters locally for reuse. Run, list, inspect, and delete saved queries.

Cache query parameters locally for reuse. Saved queries live in ~/.upstack_saved/, one JSON file per query.

Subcommands

create <name>

upstack saved create morning-report --command query --from-file ./params.json

Flag	Description
--command <c>	Required. One of query, query-attribution, query-cohort, query-channel-details.
--from-file <path>	JSON file with the query parameters.
--description <text>	Optional description for the saved query.
--force	Overwrite if a saved query with this name already exists.

You can also pass query parameters inline as flags (e.g. --measures orders.gross_revenue, --date-start 2026-04-01, --filter '{"and":[...]}') — they’re merged with the file values; flags override file values. Every query flag the underlying command accepts works here, including the attribution flags (--dimension, --model, --window, --value-source, --conversion-event) and, for query-channel-details, --limit, --offset, --sort-by, and --sort-direction.

Run upstack filters --detail to discover valid filter fields before constructing a --filter value.

list

upstack saved list

show <name>

Inspect a saved query without running it.

upstack saved show morning-report

run <name>

Re-run a saved query.

upstack saved run morning-report
upstack saved run morning-report --output csv --file ./today.csv   # override output on the fly

Override parts of the saved query without editing it:

Flag	Description
--date-start <date> --date-end <date>	Replace the saved date range (each end is kept independently if only one is passed).
--timezone <tz>	Override the timezone.
--currency <code>	Override the currency.
--output <format>	json, table, or csv.
--file <path>	Write output to a file instead of stdout.

Only the output config default applies to run — the saved parameters are passed through as stored.

delete <name>

upstack saved delete morning-report