elasticsearch/docs/reference/esql/source-commands/row.asciidoc

[[esql-row]]
=== `ROW`

The `ROW` source command produces a row with one or more columns with values
that you specify. This can be useful for testing.

[source,esql]
----
include::{esql-specs}/row.csv-spec[tag=example]
----

Which looks like:

[%header,format=dsv,separator=|]
|===
include::{esql-specs}/row.csv-spec[tag=example-result]
|===

Use square brackets to create multi-value columns:

[source,esql]
----
include::{esql-specs}/row.csv-spec[tag=multivalue]
----

`ROW` supports the use of <<esql-functions,functions>>:

[source,esql]
----
include::{esql-specs}/row.csv-spec[tag=function]
----