Atlas Testing
dataset csv
dataset.csv attributes
| Name and description | Required | Value |
|---|---|---|
Maximum number of rows written per statement. Defaults to 1000. | false | int |
Skip the dataset tables matching the glob patterns. | false | List of strings |
Load only the dataset tables matching the glob patterns ( | false | List of strings |
Mask the columns that top-level | false | List of object reference to |
Load a sample of each table, taken by a top-level | false | Object reference to |
The source of the snapshot: a directory, or an object-store URL ( | true | string |
dataset rds_snapshot
dataset.rds_snapshot attributes
| Name and description | Required | Value |
|---|---|---|
Maximum number of rows written per statement. Defaults to 1000. | false | int |
Skip the dataset tables matching the glob patterns. | false | List of strings |
Load only the dataset tables matching the glob patterns ( | false | List of strings |
Mask the columns that top-level | false | List of object reference to |
Load a sample of each table, taken by a top-level | false | Object reference to |
The source of the snapshot: a directory, or an object-store URL ( | true | string |
dataset synthetic
Generate the rows of the tables its table blocks name, the same rows for the same seed. Keys take distinct values, foreign keys reference generated rows, and the database fills the columns with a default, unless a column block sets their values.
dataset "synthetic" "seed" {
table "users" {
rows = 100
}
table "orders" {
rows = 1000
}
}
dataset.synthetic attributes
| Name and description | Required | Value |
|---|---|---|
Maximum number of rows written per statement. Defaults to 1000. | false | int |
Selects other generated values. Defaults to 0. | false | int |
dataset.synthetic blocks
dataset.table
Generate rows for the table, named <table> or <schema>.<table>.
dataset.table attributes
| Name and description | Required | Value |
|---|---|---|
The number of rows to generate. | true | int |
The number of rows the generated rows stand for, as the table holds in production. With | false | int |
dataset.table blocks
dataset.table.column
Set the values of the column, in place of the generated values or the column default. A value is refused on a column of a foreign key of several columns, or a generated column, and the values of a key column keep the key distinct unless another of its columns can.
column "name" {
value = format("user %d", row.index)
}
column "plan" {
value = random::element(["free", "pro", "team"])
}
column "updated_at" {
value = random::time(row.created_at, "2026-01-01")
}
dataset.table.column attributes
| Name and description | Required | Value |
|---|---|---|
The value of the column, evaluated for each row with | true | Any value |
dataset.table.column constraints
| Constraint | Value |
|---|---|
| Required | false |
Require Name (e.g., dataset.table.column "name" ) | true |
| Repeatable | true |
dataset.table constraints
| Constraint | Value |
|---|---|
| Required | true |
Require Name (e.g., dataset.table "name" ) | true |
| Repeatable | true |
expect profile
Bound the metrics of what a command does to the database.
expect.profile blocks
expect.metric.db.cpu.time
The CPU time the server spent on the statements of the command, as measured.
expect.metric.db.cpu.time attributes
| Name and description | Required | Value |
|---|---|---|
Each value compared equals it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is at least it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is more than it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is at most it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is less than it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared differs from it: a duration, e.g. | false | A duration or 0 can be one of:
|
expect.metric.db.cpu.time constraints
| Constraint | Value |
|---|---|
| Required | true |
| Repeatable | true |
expect.metric.db.io
The bytes the statements of the command read from disk or wrote to it, as measured. Reads the cache served are not counted.
expect.metric.db.io attributes
| Name and description | Required | Value |
|---|---|---|
Compare the bytes read ( | false |
|
Each value compared equals it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is at least it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is more than it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is at most it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is less than it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared differs from it: a size, e.g. | false | A size or 0 can be one of:
|
expect.metric.db.io constraints
| Constraint | Value |
|---|---|
| Required | true |
| Repeatable | true |
expect.metric.db.lock.time
The time a lock blocks other sessions from reading or writing a table. It is projected to the totals of the tables the statements under it work on the rows of if the profile projects it, up to the projection if the profile scales a statement too short to tell what the rows took of its time, or one over the rows of tables of more than one sample, at least the measured time if it grows with the table and is not projected, and up to the gaps between the samples that saw the lock. A lock on a partition is a lock on the tables above it too.
expect.metric.db.lock.time attributes
| Name and description | Required | Value |
|---|---|---|
Compare the locks that block other sessions from writing the table ( | false |
|
Each value compared equals it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is at least it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is more than it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is at most it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is less than it: a duration, e.g. | false | A duration or 0 can be one of:
|
Compare the locks of the mode, as the report or the database names it ( | false | string |
Each value compared differs from it: a duration, e.g. | false | A duration or 0 can be one of:
|
Compare the values of the tables matching the name, or | false | string |
expect.metric.db.lock.time constraints
| Constraint | Value |
|---|---|
| Required | true |
| Repeatable | true |
expect.metric.db.log.written
The bytes written to the write-ahead, redo or binary log while the command ran, as measured.
expect.metric.db.log.written attributes
| Name and description | Required | Value |
|---|---|---|
Each value compared equals it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is at least it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is more than it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is at most it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is less than it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared differs from it: a size, e.g. | false | A size or 0 can be one of:
|
expect.metric.db.log.written constraints
| Constraint | Value |
|---|---|
| Required | true |
| Repeatable | true |
expect.metric.db.memory.usage
The most memory a statement of the command held, or the session where statements tell none, apart from what every session shares, as measured.
expect.metric.db.memory.usage attributes
| Name and description | Required | Value |
|---|---|---|
Each value compared equals it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is at least it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is more than it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is at most it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is less than it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared differs from it: a size, e.g. | false | A size or 0 can be one of:
|
expect.metric.db.memory.usage constraints
| Constraint | Value |
|---|---|
| Required | true |
| Repeatable | true |
expect.metric.db.rows
The rows the command inserted, updated, deleted or read in a table. Writes are projected to its total if the profile projects them, and those of a partition up to its table's. Other rows, a hundredth of the rows loaded or more, of a table whose dataset counts more rows or does not tell its total, are at least as measured. The rows of a partitioned table include those of its partitions.
expect.metric.db.rows attributes
| Name and description | Required | Value |
|---|---|---|
Each value compared equals it. | false | int |
Each value compared is at least it. | false | int |
Each value compared is more than it. | false | int |
Each value compared is at most it. | false | int |
Each value compared is less than it. | false | int |
Each value compared differs from it. | false | int |
Compare the rows of the operation: | false |
|
Compare the values of the tables matching the name, or | false | string |
expect.metric.db.rows constraints
| Constraint | Value |
|---|---|
| Required | true |
| Repeatable | true |
expect.metric.db.statement.time
The time the statements of the command ran, as measured.
expect.metric.db.statement.time attributes
| Name and description | Required | Value |
|---|---|---|
Each value compared equals it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is at least it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is more than it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is at most it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is less than it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared differs from it: a duration, e.g. | false | A duration or 0 can be one of:
|
expect.metric.db.statement.time constraints
| Constraint | Value |
|---|---|
| Required | true |
| Repeatable | true |
expect.metric.db.table.copy
The size of the second copy of a table a rewrite keeps until it ends. It is projected to the total of the table if the profile projects it, at most the projected copy of the table above a partition, and at least the measured size if the total of the table is unknown.
expect.metric.db.table.copy attributes
| Name and description | Required | Value |
|---|---|---|
Each value compared equals it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is at least it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is more than it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is at most it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is less than it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared differs from it: a size, e.g. | false | A size or 0 can be one of:
|
Compare the values of the tables matching the name, or | false | string |
expect.metric.db.table.copy constraints
| Constraint | Value |
|---|---|
| Required | true |
| Repeatable | true |
expect.metric.db.table.rewrites
The table rewrites the profile finds: all rows copied into new storage. The rewrites of a partitioned table include those of its partitions.
expect.metric.db.table.rewrites attributes
| Name and description | Required | Value |
|---|---|---|
Each value compared equals it. | false | int |
Each value compared is at least it. | false | int |
Each value compared is more than it. | false | int |
Each value compared is at most it. | false | int |
Each value compared is less than it. | false | int |
Each value compared differs from it. | false | int |
Compare the values of the tables matching the name, or | false | string |
expect.metric.db.table.rewrites constraints
| Constraint | Value |
|---|---|
| Required | true |
| Repeatable | true |
mask
The mask block masks the values of the text columns it selects before a dataset referencing it loads them, as the masks of script queries do, or groups other masks with use.
mask "email" {
columns = ["users.email"]
method = HASH
salt = var.mask_salt
}
mask "pii" {
use = [mask.email, mask.phone]
}
dataset "rds_snapshot" "prod" {
src = "s3://backups/snapshot-rds?region=us-east-1"
masks = [mask.pii]
}
mask attributes
| Name and description | Required | Value |
|---|---|---|
| false | string |
The columns to mask: | false | List of strings |
Mask the entities found in a value, each on its own, instead of the whole value, as Presidio does: | false | List of |
| false | int |
| false | int |
| false | int |
| false | string |
Masking method ( | false |
|
| false | string |
| false | string |
The top-level masks this one groups, applied in order, e.g. | false | List of object reference to |
| false | string |
mask constraints
| Constraint | Value |
|---|---|
| Required | false |
Require Name (e.g., mask "name" ) | true |
| Repeatable | true |
| Mutually exclusive sets | [use, columns], [use, method], [use, entities], [use, token], [use, keep], [use, keep_left], [use, keep_right], [use, char], [use, salt], [use, match], [use, with] |
| One of required sets | [columns, use] |
sampler composite
Sample each table by the sampler of the first table block matching it, and load all rows of the tables none matches.
sampler "composite" "prod" {
table {
match = ["events", "clicks", "audit_*"]
use = sampler.random.large
}
table {
match = ["countries", "currencies"]
all = true
}
table {
match = ["*"]
use = sampler.head.small
}
}
sampler.composite blocks
sampler.table
Sample the tables matching the glob patterns, unless a table block before it matches them.
sampler.table attributes
| Name and description | Required | Value |
|---|---|---|
Set to | false | bool |
The glob patterns matching the tables, as | true | List of strings |
The | false | Object reference to |
sampler.table constraints
| Constraint | Value |
|---|---|
| Required | true |
| Require Name | false |
| Repeatable | true |
| Mutually exclusive sets | [use, all] |
| One of required sets | [use, all] |
sampler filter
Take the rows whose columns hold all the operators of their column blocks: eq, ne, in, lt, le, gt, ge and match, and the and, or and not blocks combining them. Numbers compare by value, the text of a decimal column included, and strings as text, which orders ISO dates and times. As in SQL, a NULL matches no operator, ne and not included. The other tables take no row of their own, only the rows the sample references, and with related, the rows referencing it.
sampler "filter" "one_customer" {
column "billing.tenants.id" {
eq = 42
}
related = true
}
sampler.filter attributes
| Name and description | Required | Value |
|---|---|---|
Also load the rows referencing the sampled ones, in the same table or another loaded one: one level down, as these rows load the rows they reference, but not the rows referencing them. The tables referencing a related sample are read whole. | false | bool |
sampler.filter blocks
sampler.column
Match the rows whose column holds all of its operators and blocks. The label names the column with its table: <table>.<column> or <schema>.<table>.<column>.
sampler.column attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column blocks
sampler.column.and
Match the values holding all of its operators and blocks.
sampler.column.and attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.and blocks
sampler.column.and.and
Match the values holding all of its operators and blocks.
sampler.column.and.and attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.and.and constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.and.not
Match the values not holding all of its operators and blocks.
sampler.column.and.not attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.and.not blocks
sampler.column.and.not.and
Match the values holding all of its operators and blocks.
sampler.column.and.not.and attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.and.not.and constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.and.not.not
Match the values not holding all of its operators and blocks.
sampler.column.and.not.not attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.and.not.not constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.and.not.or
Match the values holding any of its operators and blocks.
sampler.column.and.not.or attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.and.not.or blocks
sampler.column.and.not.or.and
Match the values holding all of its operators and blocks.
sampler.column.and.not.or.and attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.and.not.or.and constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.and.not.or.not
Match the values not holding all of its operators and blocks.
sampler.column.and.not.or.not attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.and.not.or.not constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.and.not.or.or
Match the values holding any of its operators and blocks.
sampler.column.and.not.or.or attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.and.not.or.or constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.and.not.or constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.and.not constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.and.or
Match the values holding any of its operators and blocks.
sampler.column.and.or attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.and.or blocks
sampler.column.and.or.and
Match the values holding all of its operators and blocks.
sampler.column.and.or.and attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.and.or.and constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.and.or.not
Match the values not holding all of its operators and blocks.
sampler.column.and.or.not attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.and.or.not blocks
sampler.column.and.or.not.and
Match the values holding all of its operators and blocks.
sampler.column.and.or.not.and attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.and.or.not.and constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.and.or.not.not
Match the values not holding all of its operators and blocks.
sampler.column.and.or.not.not attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.and.or.not.not constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.and.or.not.or
Match the values holding any of its operators and blocks.
sampler.column.and.or.not.or attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.and.or.not.or constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.and.or.not constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.and.or.or
Match the values holding any of its operators and blocks.
sampler.column.and.or.or attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.and.or.or constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.and.or constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.and constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.not
Match the values not holding all of its operators and blocks.
sampler.column.not attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.not blocks
sampler.column.not.and
Match the values holding all of its operators and blocks.
sampler.column.not.and attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.not.and blocks
sampler.column.not.and.and
Match the values holding all of its operators and blocks.
sampler.column.not.and.and attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.not.and.and constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.not.and.not
Match the values not holding all of its operators and blocks.
sampler.column.not.and.not attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.not.and.not constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.not.and.or
Match the values holding any of its operators and blocks.
sampler.column.not.and.or attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.not.and.or blocks
sampler.column.not.and.or.and
Match the values holding all of its operators and blocks.
sampler.column.not.and.or.and attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.not.and.or.and constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.not.and.or.not
Match the values not holding all of its operators and blocks.
sampler.column.not.and.or.not attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.not.and.or.not constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.not.and.or.or
Match the values holding any of its operators and blocks.
sampler.column.not.and.or.or attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.not.and.or.or constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.not.and.or constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.not.and constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.not.not
Match the values not holding all of its operators and blocks.
sampler.column.not.not attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.not.not constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.not.or
Match the values holding any of its operators and blocks.
sampler.column.not.or attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.not.or blocks
sampler.column.not.or.and
Match the values holding all of its operators and blocks.
sampler.column.not.or.and attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.not.or.and blocks
sampler.column.not.or.and.and
Match the values holding all of its operators and blocks.
sampler.column.not.or.and.and attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.not.or.and.and constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.not.or.and.not
Match the values not holding all of its operators and blocks.
sampler.column.not.or.and.not attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.not.or.and.not constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.not.or.and.or
Match the values holding any of its operators and blocks.
sampler.column.not.or.and.or attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.not.or.and.or constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.not.or.and constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.not.or.not
Match the values not holding all of its operators and blocks.
sampler.column.not.or.not attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.not.or.not constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.not.or.or
Match the values holding any of its operators and blocks.
sampler.column.not.or.or attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.not.or.or constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.not.or constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.not constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.or
Match the values holding any of its operators and blocks.
sampler.column.or attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.or blocks
sampler.column.or.and
Match the values holding all of its operators and blocks.
sampler.column.or.and attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.or.and blocks
sampler.column.or.and.and
Match the values holding all of its operators and blocks.
sampler.column.or.and.and attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.or.and.and constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.or.and.not
Match the values not holding all of its operators and blocks.
sampler.column.or.and.not attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.or.and.not blocks
sampler.column.or.and.not.and
Match the values holding all of its operators and blocks.
sampler.column.or.and.not.and attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.or.and.not.and constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.or.and.not.not
Match the values not holding all of its operators and blocks.
sampler.column.or.and.not.not attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.or.and.not.not constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.or.and.not.or
Match the values holding any of its operators and blocks.
sampler.column.or.and.not.or attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.or.and.not.or constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.or.and.not constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.or.and.or
Match the values holding any of its operators and blocks.
sampler.column.or.and.or attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.or.and.or constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.or.and constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.or.not
Match the values not holding all of its operators and blocks.
sampler.column.or.not attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.or.not blocks
sampler.column.or.not.and
Match the values holding all of its operators and blocks.
sampler.column.or.not.and attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.or.not.and blocks
sampler.column.or.not.and.and
Match the values holding all of its operators and blocks.
sampler.column.or.not.and.and attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.or.not.and.and constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.or.not.and.not
Match the values not holding all of its operators and blocks.
sampler.column.or.not.and.not attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.or.not.and.not constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.or.not.and.or
Match the values holding any of its operators and blocks.
sampler.column.or.not.and.or attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.or.not.and.or constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.or.not.and constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.or.not.not
Match the values not holding all of its operators and blocks.
sampler.column.or.not.not attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.or.not.not constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.or.not.or
Match the values holding any of its operators and blocks.
sampler.column.or.not.or attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.or.not.or constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.or.not constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.or.or
Match the values holding any of its operators and blocks.
sampler.column.or.or attributes
| Name and description | Required | Value |
|---|---|---|
Match the values equal to it. | false | A number, a string or a bool can be one of:
|
Match the values greater than or equal to it. | false | A number or a string can be one of:
|
Match the values greater than it. | false | A number or a string can be one of:
|
Match the values equal to one of the list. | false | List of values, where each can be one of:
|
Match the values less than or equal to it. | false | A number or a string can be one of:
|
Match the values less than it. | false | A number or a string can be one of:
|
Match the text values matching it, a regular expression in the RE2 syntax. | false | string |
Match the values differing from it. | false | A number, a string or a bool can be one of:
|
sampler.column.or.or constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column.or constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler.column constraints
| Constraint | Value |
|---|---|
| Required | true |
Require Name (e.g., sampler.column "name" ) | true |
| Repeatable | true |
| One of required sets | [eq, ne, in, lt, le, gt, ge, match, and, or, not] |
sampler head
Take the first rows of each table, in the snapshot order.
sampler.head attributes
| Name and description | Required | Value |
|---|---|---|
Also load the rows referencing the sampled ones, in the same table or another loaded one: one level down, as these rows load the rows they reference, but not the rows referencing them. The tables referencing a related sample are read whole. | false | bool |
The number of rows each table takes, or all its rows if it has fewer. The rows these reference, in the same table or another loaded one, are loaded on top, so no foreign key is left dangling. | true | int |
sampler random
Take rows drawn uniformly at random, the same ones on every run over the same snapshot, and a larger sample keeps the rows of a smaller one. The rows of each table are counted first.
sampler.random attributes
| Name and description | Required | Value |
|---|---|---|
Also load the rows referencing the sampled ones, in the same table or another loaded one: one level down, as these rows load the rows they reference, but not the rows referencing them. The tables referencing a related sample are read whole. | false | bool |
The number of rows each table takes, or all its rows if it has fewer. The rows these reference, in the same table or another loaded one, are loaded on top, so no foreign key is left dangling. | true | int |
Selects another random draw. Defaults to 0. | false | int |
sampler tail
Take the last rows of each table, in the snapshot order. The rows of each table are counted first.
sampler.tail attributes
| Name and description | Required | Value |
|---|---|---|
Also load the rows referencing the sampled ones, in the same table or another loaded one: one level down, as these rows load the rows they reference, but not the rows referencing them. The tables referencing a related sample are read whole. | false | bool |
The number of rows each table takes, or all its rows if it has fewer. The rows these reference, in the same table or another loaded one, are loaded on top, so no foreign key is left dangling. | true | int |
test migrate
The test "migrate" "name" block describes a migrate test case.
test "migrate" "20240613061102" {
migrate {
to = "20240613061046"
}
exec {
sql = "INSERT INTO users (name) VALUES ('Ada Lovelace')"
}
migrate {
to = "20240613061102"
}
exec {
sql = "SELECT first_name,last_name FROM users"
output = "Ada, Lovelace"
}
}
test.migrate attributes
| Name | Required | Value |
|---|---|---|
skip | false | bool |
test.migrate blocks
test.assert
The assert block executes an SQL statement and expects a single-row, single-column result with a true value.
test.assert attributes
| Name | Required | Value |
|---|---|---|
error_message | false | string |
sql | true | string |
test.assert constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
test.catch
The catch block executes one or more SQL statements and expects an error to occur.
test.catch attributes
| Name and description | Required | Value |
|---|---|---|
error | false | string |
Set to | false | bool |
sql | true | string |
test.catch blocks
test.catch.expect.profile
Bound the metrics of what the command does to the database.
test.catch.expect.profile attributes
| Name and description | Required | Value |
|---|---|---|
The top-level | false | List of object reference to |
test.catch.expect.profile blocks
test.catch.expect.metric.db.cpu.time
The CPU time the server spent on the statements of the command, as measured.
test.catch.expect.metric.db.cpu.time attributes
| Name and description | Required | Value |
|---|---|---|
Each value compared equals it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is at least it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is more than it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is at most it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is less than it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared differs from it: a duration, e.g. | false | A duration or 0 can be one of:
|
test.catch.expect.metric.db.cpu.time constraints
| Constraint | Value |
|---|---|
| Required | false |
| Repeatable | true |
test.catch.expect.metric.db.io
The bytes the statements of the command read from disk or wrote to it, as measured. Reads the cache served are not counted.
test.catch.expect.metric.db.io attributes
| Name and description | Required | Value |
|---|---|---|
Compare the bytes read ( | false |
|
Each value compared equals it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is at least it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is more than it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is at most it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is less than it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared differs from it: a size, e.g. | false | A size or 0 can be one of:
|
test.catch.expect.metric.db.io constraints
| Constraint | Value |
|---|---|
| Required | false |
| Repeatable | true |
test.catch.expect.metric.db.lock.time
The time a lock blocks other sessions from reading or writing a table. It is projected to the totals of the tables the statements under it work on the rows of if the profile projects it, up to the projection if the profile scales a statement too short to tell what the rows took of its time, or one over the rows of tables of more than one sample, at least the measured time if it grows with the table and is not projected, and up to the gaps between the samples that saw the lock. A lock on a partition is a lock on the tables above it too.
test.catch.expect.metric.db.lock.time attributes
| Name and description | Required | Value |
|---|---|---|
Compare the locks that block other sessions from writing the table ( | false |
|
Each value compared equals it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is at least it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is more than it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is at most it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is less than it: a duration, e.g. | false | A duration or 0 can be one of:
|
Compare the locks of the mode, as the report or the database names it ( | false | string |
Each value compared differs from it: a duration, e.g. | false | A duration or 0 can be one of:
|
Compare the values of the tables matching the name, or | false | string |
test.catch.expect.metric.db.lock.time constraints
| Constraint | Value |
|---|---|
| Required | false |
| Repeatable | true |
test.catch.expect.metric.db.log.written
The bytes written to the write-ahead, redo or binary log while the command ran, as measured.
test.catch.expect.metric.db.log.written attributes
| Name and description | Required | Value |
|---|---|---|
Each value compared equals it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is at least it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is more than it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is at most it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is less than it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared differs from it: a size, e.g. | false | A size or 0 can be one of:
|
test.catch.expect.metric.db.log.written constraints
| Constraint | Value |
|---|---|
| Required | false |
| Repeatable | true |
test.catch.expect.metric.db.memory.usage
The most memory a statement of the command held, or the session where statements tell none, apart from what every session shares, as measured.
test.catch.expect.metric.db.memory.usage attributes
| Name and description | Required | Value |
|---|---|---|
Each value compared equals it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is at least it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is more than it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is at most it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is less than it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared differs from it: a size, e.g. | false | A size or 0 can be one of:
|
test.catch.expect.metric.db.memory.usage constraints
| Constraint | Value |
|---|---|
| Required | false |
| Repeatable | true |
test.catch.expect.metric.db.rows
The rows the command inserted, updated, deleted or read in a table. Writes are projected to its total if the profile projects them, and those of a partition up to its table's. Other rows, a hundredth of the rows loaded or more, of a table whose dataset counts more rows or does not tell its total, are at least as measured. The rows of a partitioned table include those of its partitions.
test.catch.expect.metric.db.rows attributes
| Name and description | Required | Value |
|---|---|---|
Each value compared equals it. | false | int |
Each value compared is at least it. | false | int |
Each value compared is more than it. | false | int |
Each value compared is at most it. | false | int |
Each value compared is less than it. | false | int |
Each value compared differs from it. | false | int |
Compare the rows of the operation: | false |
|
Compare the values of the tables matching the name, or | false | string |
test.catch.expect.metric.db.rows constraints
| Constraint | Value |
|---|---|
| Required | false |
| Repeatable | true |
test.catch.expect.metric.db.statement.time
The time the statements of the command ran, as measured.
test.catch.expect.metric.db.statement.time attributes
| Name and description | Required | Value |
|---|---|---|
Each value compared equals it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is at least it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is more than it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is at most it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared is less than it: a duration, e.g. | false | A duration or 0 can be one of:
|
Each value compared differs from it: a duration, e.g. | false | A duration or 0 can be one of:
|
test.catch.expect.metric.db.statement.time constraints
| Constraint | Value |
|---|---|
| Required | false |
| Repeatable | true |
test.catch.expect.metric.db.table.copy
The size of the second copy of a table a rewrite keeps until it ends. It is projected to the total of the table if the profile projects it, at most the projected copy of the table above a partition, and at least the measured size if the total of the table is unknown.
test.catch.expect.metric.db.table.copy attributes
| Name and description | Required | Value |
|---|---|---|
Each value compared equals it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is at least it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is more than it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is at most it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared is less than it: a size, e.g. | false | A size or 0 can be one of:
|
Each value compared differs from it: a size, e.g. | false | A size or 0 can be one of:
|
Compare the values of the tables matching the name, or | false | string |
test.catch.expect.metric.db.table.copy constraints
| Constraint | Value |
|---|---|
| Required | false |
| Repeatable | true |
test.catch.expect.metric.db.table.rewrites
The table rewrites the profile finds: all rows copied into new storage. The rewrites of a partitioned table include those of its partitions.
test.catch.expect.metric.db.table.rewrites attributes
| Name and description | Required | Value |
|---|---|---|
Each value compared equals it. | false | int |
Each value compared is at least it. | false | int |
Each value compared is more than it. | false | int |
Each value compared is at most it. | false | int |
Each value compared is less than it. | false | int |
Each value compared differs from it. | false | int |
Compare the values of the tables matching the name, or | false | string |
test.catch.expect.metric.db.table.rewrites constraints
| Constraint | Value |
|---|---|
| Required | false |
| Repeatable | true |
test.catch.expect.profile constraints
| Constraint | Value |
|---|---|
| Required | false |
| Repeatable | true |
test.catch constraints
| Constraint | Value |
|---|---|
| Required | false |
| Require Name | false |
| Repeatable | true |
| Mutually exclusive sets | [profile, expect] |