Skip to main content

# kater query reorder

Changes the order of the queries in a workspace, which is the order of its tabs.

{/* Written by apps/landing-page/scripts/docs/write_cli_reference.py from the kater CLI's own help and scripts/docs/cli-reference.md. Do not edit it by hand: change those, then run the script. */}

Kater writes the new order into `workspace.sql`, and no query file changes.

## Examples

```bash
# Get the revision of the ad_reporting workspace's query order
revision=$(echo '{"namespace": {"path": "connections/snowflake_prod_connection/workspaces/ad_reporting"}}' | kater query list --request-file - | jq -r .workspace_revision)
# Put spend_by_platform and paid_media_spend_trend first
jq -n --arg revision "$revision" '{namespace: {path: "connections/snowflake_prod_connection/workspaces/ad_reporting"}, names: ["spend_by_platform", "paid_media_spend_trend"], expected_revision: $revision}' | kater query reorder --request-file -
# Send a request that you keep in reorder.json
kater query reorder --request-file reorder.json
```

## Arguments

<div class="cli-options">

| Argument | Description |
| --- | --- |
| `<path>` | Optional. In place of `--request-file`: the workspace, the query file or the chart file the request names. |

</div>

## Options

<div class="cli-options">

| Option | Description |
| --- | --- |
| `--request-file <file>` | The JSON request. `-` reads it from standard input. See [The request](#the-request). |

</div>

It also takes the [global options](https://kater.ai/docs/cli-reference/global-options/) `--json`, `--kater-root`, `--scope` and `--help`.

## The request

| Key | What it holds |
| --- | --- |
| `namespace` | The workspace, by its path from the content root, such as `{"path": "connections/snowflake_prod_connection/workspaces/ad_reporting"}`. |
| `names` | The workspace's queries in their new order, by name. A query that the list leaves out keeps its place, after these. |
| `expected_revision` | The `workspace_revision` that [`kater query list`](https://kater.ai/docs/cli-reference/query/list/) gives. Kater refuses the change when `workspace.sql` changed since. |

## See also

- [`kater query`](https://kater.ai/docs/cli-reference/query/)
- [All commands](https://kater.ai/docs/cli-reference/kater/)

On this page

Examples
Arguments
Options
The request
See also

Kater CLI Build an analysis query

kater query reorder

Changes the order of the queries in a workspace, which is the order of its tabs.

Kater writes the new order into workspace.sql, and no query file changes.

Examples

# Get the revision of the ad_reporting workspace's query order
revision=$(echo '{"namespace": {"path": "connections/snowflake_prod_connection/workspaces/ad_reporting"}}' | kater query list --request-file - | jq -r .workspace_revision)
# Put spend_by_platform and paid_media_spend_trend first
jq -n --arg revision "$revision" '{namespace: {path: "connections/snowflake_prod_connection/workspaces/ad_reporting"}, names: ["spend_by_platform", "paid_media_spend_trend"], expected_revision: $revision}' | kater query reorder --request-file -
# Send a request that you keep in reorder.json
kater query reorder --request-file reorder.json

Arguments

Argument	Description
`<path>`	Optional. In place of `--request-file`: the workspace, the query file or the chart file the request names.

Options

Option	Description
`--request-file <file>`	The JSON request. `-` reads it from standard input. See The request.

It also takes the global options --json, --kater-root, --scope and --help.

The request

Key	What it holds
`namespace`	The workspace, by its path from the content root, such as `{"path": "connections/snowflake_prod_connection/workspaces/ad_reporting"}`.
`names`	The workspace’s queries in their new order, by name. A query that the list leaves out keeps its place, after these.
`expected_revision`	The `workspace_revision` that `kater query list` gives. Kater refuses the change when `workspace.sql` changed since.

See also