Tables

sim tables is also spelled sim table.

Every command below also accepts the global options.

Add column

sim tables columns create <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--column <json\|@file>`	Yes	Column definition to add. (JSON, or @path / @- to read a file or stdin).

Delete column

sim tables columns delete <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--column-name <value>`	Yes	Name of the column to delete.
`-y, --yes`	No	Skip the confirmation.

Run a column’s workflow

sim tables columns run <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--group-ids <value...>`	Yes	Workflow or enrichment groups to run. (space-separated, or @path / @- with one value per line).
`--run-mode <value>`	No	Whether to run all or only incomplete cells. Accepted values: `all`, `incomplete`.
`--row-ids <value...>`	No	Explicit row subset to run. (space-separated, or @path / @- with one value per line).
`--filter <json\|@file>`	No	Predicate: {"all":[{"field":"status","op":"eq","value":"active"}]}; groups use all/any. Operators: eq, ne, gt, gte, lt, lte, in, nin, contains, ncontains, startsWith, endsWith, like, ilike, nlike, nilike, isEmpty, isNotEmpty, isNull, isNotNull (JSON, or @path / @- to read a file or stdin).
`--exclude-row-ids <value...>`	No	Rows excluded from a select-all run scope. (space-separated, or @path / @- with one value per line).
`--limit <json\|@file>`	No	Optional cap on eligible rows to run. (JSON, or @path / @- to read a file or stdin).

Update column

sim tables columns update <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--column-name <value>`	Yes	Current name of the column to update.
`--updates <json\|@file>`	Yes	Mutable column fields. (JSON, or @path / @- to read a file or stdin).

Add workflow group

sim tables groups create <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--group <json\|@file>`	Yes	Workflow or enrichment producer definition. (JSON, or @path / @- to read a file or stdin).
`--output-columns <json\|@file>`	Yes	Columns created for producer outputs. (JSON, or @path / @- to read a file or stdin).
`--auto-run`	No	Whether to schedule existing rows after group creation.
`--no-auto-run`	No	Send --auto-run as false.

Delete workflow group

sim tables groups delete <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--group-id <value>`	Yes	Workflow group to delete.
`-y, --yes`	No	Skip the confirmation.

List workflow groups

sim tables groups list <tableId>

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Update workflow group

sim tables groups update <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--group-id <value>`	Yes	Workflow group to update.
`--workflow-id <value>`	No	Replacement backing workflow identifier.
`--name <value>`	No	Replacement workflow-group display name.
`--dependencies <json\|@file>`	No	Replacement input dependencies. (JSON, or @path / @- to read a file or stdin).
`--outputs <json\|@file>`	No	Replacement producer outputs. (JSON, or @path / @- to read a file or stdin).
`--new-output-columns <json\|@file>`	No	Columns to add for new outputs. (JSON, or @path / @- to read a file or stdin).
`--mapping-updates <json\|@file>`	No	Existing output-column mapping changes. (JSON, or @path / @- to read a file or stdin).
`--input-mappings <json\|@file>`	No	Replacement workflow input mappings. (JSON, or @path / @- to read a file or stdin).
`--deployment-mode <value>`	No	Replacement workflow execution mode. Accepted values: `live`, `deployed`.
`--type <value>`	No	Workflow-group producer type. Must match the group's stored type — a group's producer cannot be changed after creation. Accepted values: `manual`, `enrichment`.
`--auto-run`	No	Replacement automatic-run setting.
`--no-auto-run`	No	Send --auto-run as false.

Cancel table export

sim tables exports cancel <exportId>

Arguments

Argument	Required	Description
`exportId`	Yes	Unique table-export identifier.

Create table export

sim tables exports create <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--format <value>`	No	Export file format. Accepted values: `csv`, `json`.

Get table export

sim tables exports get <exportId>

Arguments

Argument	Required	Description
`exportId`	Yes	Unique table-export identifier.

Get the download URL for a finished export

sim tables exports download <exportId>

Arguments

Argument	Required	Description
`exportId`	Yes	Unique table-export identifier.

Cancel table import

sim tables imports cancel <importId>

Arguments

Argument	Required	Description
`importId`	Yes	Unique table-import identifier.

Get table import

sim tables imports get <importId>

Arguments

Argument	Required	Description
`importId`	Yes	Unique table-import identifier.

Stop every running column job

sim tables cancel-runs <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--scope <value>`	Yes	Whether to cancel across the table or one row. Accepted values: `all`, `row`.
`--row-id <value>`	No	Row whose runs should be canceled for row scope.
`--filter <json\|@file>`	No	Predicate: {"all":[{"field":"status","op":"eq","value":"active"}]}; groups use all/any. Operators: eq, ne, gt, gte, lt, lte, in, nin, contains, ncontains, startsWith, endsWith, like, ilike, nlike, nilike, isEmpty, isNotEmpty, isNull, isNotNull (JSON, or @path / @- to read a file or stdin).
`--exclude-row-ids <value...>`	No	Rows excluded from an all-scope cancellation. (space-separated, or @path / @- with one value per line).

Create table

sim tables create [options]

Options

Option	Required	Description
`--name <value>`	Yes	Identifier: letters, numbers, and underscores; cannot start with a number.
`--description <value>`	No	Optional table description.
`--schema <json\|@file>`	Yes	Table schema: {"columns":[{"name":"email","type":"string"}]} (JSON, or @path / @- to read a file or stdin).
`--folder <value>`	No	Folder path; the leading / is optional.

Create a table folder at a path

sim tables folders create <path>

Arguments

Argument	Required	Description
`path`	Yes	Folder path; the leading / is optional

Delete folder

sim tables folders delete <path> [options]

Arguments

Argument	Required	Description
`path`	Yes	Folder path; the leading / is optional

Options

Option	Required	Description
`--recursive`	No	Delete the folder and its descendants.
`-y, --yes`	No	Skip the confirmation.

List folders

sim tables folders list [options]

Also available as sim tables folders ls.

Options

Option	Required	Description
`--parent <value>`	No	Direct parent folder path.
`--search <value>`	No	Case-insensitive substring match against the folder name.
`--sort-by <value>`	No	Field used to sort the result. Sorting by `name` is case-sensitive and follows the storage collation, so do not rely on a case-insensitive order. Accepted values: `name`, `createdAt`, `updatedAt`.
`--sort-order <value>`	No	Sort direction. Accepted values: `asc`, `desc`.

Rename or move a table folder

sim tables folders move <path> <destination>

Also available as sim tables folders mv.

Arguments

Argument	Required	Description
`path`	Yes	Folder path; the leading / is optional
`destination`	Yes	Folder path; the leading / is optional

Create rows

sim tables rows create <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--data <json\|@file>`	No	One row keyed by column name (JSON, or @path / @-; choose exactly one body flag).
`--rows <json\|@file>`	No	Several rows keyed by column name (JSON, or @path / @-; choose exactly one body flag).

Delete row

sim tables rows delete <tableId> <rowId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.
`rowId`	Yes	Unique table row identifier.

Options

Option	Required	Description
`-y, --yes`	No	Skip the confirmation.

Delete rows matching a filter, or an explicit list of ids

sim tables rows batch-delete <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--filter <json\|@file>`	No	Predicate: {"all":[{"field":"status","op":"eq","value":"active"}]}; groups use all/any. Operators: eq, ne, gt, gte, lt, lte, in, nin, contains, ncontains, startsWith, endsWith, like, ilike, nlike, nilike, isEmpty, isNotEmpty, isNull, isNotNull (JSON, or @path / @- to read a file or stdin).
`--limit <n>`	No	Maximum items to return (0 for everything). Defaults to `100`.
`--row <value...>`	No	Explicit row identifiers to delete. (space-separated, or @path / @- with one value per line).
`-y, --yes`	No	Skip the confirmation.

Find rows matching a predicate

sim tables rows find <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--q <value>`	Yes	Value to find.
`--filter <json\|@file>`	No	Predicate: {"all":[{"field":"status","op":"eq","value":"active"}]}; groups use all/any. Operators: eq, ne, gt, gte, lt, lte, in, nin, contains, ncontains, startsWith, endsWith, like, ilike, nlike, nilike, isEmpty, isNotEmpty, isNull, isNotNull (JSON, or @path / @- to read a file or stdin).
`--sort <json\|@file>`	No	Ordered sort keys: [{"field":"createdAt","direction":"desc"}] (direction: asc or desc) (JSON, or @path / @- to read a file or stdin).

Get row

sim tables rows get <tableId> <rowId>

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.
`rowId`	Yes	Unique table row identifier.

List rows

sim tables rows list <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--limit <n>`	No	Maximum items to return (0 for everything). Defaults to `100`.

Query rows

sim tables rows query <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--filter <json\|@file>`	No	Predicate: {"all":[{"field":"status","op":"eq","value":"active"}]}; groups use all/any. Operators: eq, ne, gt, gte, lt, lte, in, nin, contains, ncontains, startsWith, endsWith, like, ilike, nlike, nilike, isEmpty, isNotEmpty, isNull, isNotNull (JSON, or @path / @- to read a file or stdin).
`--sort <json\|@file>`	No	Ordered sort keys: [{"field":"createdAt","direction":"desc"}] (direction: asc or desc) (JSON, or @path / @- to read a file or stdin).
`--limit <n>`	No	Maximum items to return (0 for everything). Defaults to `100`.

Run one row’s enrichment group

sim tables rows enrich <tableId> <rowId> <groupId>

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.
`rowId`	Yes	Unique table row identifier.
`groupId`	Yes	Workflow or enrichment group to run.

Update every row matching a filter

sim tables rows batch-update <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--filter <json\|@file>`	Yes	Predicate: {"all":[{"field":"status","op":"eq","value":"active"}]}; groups use all/any. Operators: eq, ne, gt, gte, lt, lte, in, nin, contains, ncontains, startsWith, endsWith, like, ilike, nlike, nilike, isEmpty, isNotEmpty, isNull, isNotNull (JSON, or @path / @- to read a file or stdin).
`--data <json\|@file>`	Yes	Row-data patch applied to every matching row. (JSON, or @path / @- to read a file or stdin).
`--limit <n>`	No	Maximum items to return (0 for everything). Defaults to `100`.
`-y, --yes`	No	Skip the confirmation.

Update row

sim tables rows update <tableId> <rowId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.
`rowId`	Yes	Unique table row identifier.

Options

Option	Required	Description
`--data <json\|@file>`	Yes	Partial row-data patch keyed by column name. (JSON, or @path / @- to read a file or stdin).

Create view

sim tables views create <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--name <value>`	Yes	Saved-view display name.
`--config <json\|@file>`	Yes	Saved filter, sort, and column-layout configuration. (JSON, or @path / @- to read a file or stdin).

Delete view

sim tables views delete <tableId> <viewId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.
`viewId`	Yes	Unique saved-view identifier.

Options

Option	Required	Description
`-y, --yes`	No	Skip the confirmation.

Get view

sim tables views get <tableId> <viewId>

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.
`viewId`	Yes	Unique saved-view identifier.

List views

sim tables views list <tableId>

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Update view

sim tables views update <tableId> <viewId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.
`viewId`	Yes	Unique saved-view identifier.

Options

Option	Required	Description
`--name <value>`	No	Replacement saved-view display name.
`--config <json\|@file>`	No	Complete replacement saved-view configuration. (JSON, or @path / @- to read a file or stdin).
`--config-patch <json\|@file>`	No	Saved-view configuration fields to shallow-merge. (JSON, or @path / @- to read a file or stdin).
`--is-default`	No	Whether to promote this view to the table default.
`--no-is-default`	No	Send --is-default as false.

Delete table

sim tables delete <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`-y, --yes`	No	Skip the confirmation.

Get table

sim tables get <tableId>

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

List tables

sim tables list [options]

Options

Option	Required	Description
`--folder <value>`	No	Folder path; the leading / is optional.
`--search <value>`	No	Case-insensitive substring match against the resource name.
`--sort-by <value>`	No	Field used to sort the result. Sorting by `name` is case-sensitive and follows the storage collation, so do not rely on a case-insensitive order. Accepted values: `name`, `createdAt`, `updatedAt`.
`--sort-order <value>`	No	Sort direction. Accepted values: `asc`, `desc`.
`--limit <n>`	No	Maximum items to return (0 for everything). Defaults to `100`.

Count rows

sim tables count create <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--predicate <json\|@file>`	No	Recursive predicate tree. Each group node is exactly one non-empty `all` or `any` array whose members are further groups or `{ field, op, value }` conditions; the root must be a group, not a bare condition. At most 100 members per group, 10 levels of nesting, and 500 nodes in total. The negating operators include nulls: `ne`, `nin`, `ncontains`, `nlike`, and `nilike` match rows whose column is null or absent, so "not X" is not the complement of "X" over a nullable column. That holds for every column type, multi-select included. To exclude nulls, `all`-combine the negation with `isNotEmpty` (multi-select) or `isNotNull`. Comparison: `eq`, `ne`, `gt`, `gte`, `lt`, `lte`. Membership: `in`, `nin` (array operand). Emptiness: `isEmpty`, `isNotEmpty`, `isNull`, `isNotNull` (no operand). Substring, always case-insensitive, operand matched literally: `contains`, `ncontains`, `startsWith`, `endsWith`. Pattern: `like`/`nlike` (case-sensitive), `ilike`/`nilike` (case-insensitive). *`` is the only wildcard** and stands for any run of characters; `%`, `_`, and backslash match themselves. Use `like: "Hi*"`, not `like: "Hi%"`. A `select` column compares by option id and restricts its operators: single-select accepts `eq`, `ne`, `in`, `nin`; multi-select accepts `contains`, `ncontains`. Option names are accepted as operands and resolved to ids. (JSON, or @path / @- to read a file or stdin).

Update table

sim tables update <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--name <value>`	No	Identifier: letters, numbers, and underscores; cannot start with a number.
`--description <value>`	No	Replacement table description, or null to clear it.
`--folder <value>`	No	Folder path; the leading / is optional.

Move a table to a folder

sim tables mv <tableId> <folder>

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.
`folder`	Yes	Folder path; the leading / is optional

Insert a row, or update the one that conflicts on a unique column

sim tables upsert <tableId> [options]

Arguments

Argument	Required	Description
`tableId`	Yes	Unique table identifier.

Options

Option	Required	Description
`--data <json\|@file>`	Yes	Complete set of row cells keyed by column name. On the update branch this REPLACES the matched row: any column not present here is cleared, unlike the merging `PATCH /api/v2/tables/{tableId}/rows/{rowId}`. (JSON, or @path / @- to read a file or stdin).
`--on <value>`	No	Unique column to resolve the conflict against.

Import a CSV, into a new table by default

sim tables import [path] [options]

Arguments

Argument	Required	Description
`path`	No	Local CSV file to import; omit when using --file-id

Options

Option	Required	Description
`--name <name>`	No	Identifier for the new table: letters, numbers, and underscores; defaults to the sanitized file name.
`--table-id <id>`	No	Import into this existing table instead of creating one.
`--mode <append\|replace>`	No	How to write into --table-id (default: append). Accepted values: `append`, `replace`.
`--folder <path>`	No	Folder path for the new table.
`--file-id <id>`	No	Import a file already in the workspace instead of a local path.
`--mapping <json\|@file>`	No	Column mapping (--table-id only).
`--create-columns <json\|@file>`	No	Columns to create (--table-id only).
`--timezone <iana>`	No	Timezone for date parsing, e.g. America/New_York.
`--no-wait`	No	Return once the import is queued instead of watching it.

List table resources and child folders together

sim tables ls [path] [options]

Arguments

Argument	Required	Description
`path`	No	Folder path to list; defaults to the root folder

Options

Option	Required	Description
`--search <text>`	No	Filter folders and resources by name.
`--limit <n>`	No	Maximum combined items to return (0 for everything). Defaults to `100`.

Create a table directory at a path

sim tables mkdir <path>

Arguments

Argument	Required	Description
`path`	Yes	Folder path to create; the leading / is optional

Tables

On this page