cat operator

Use the cat operator to list all rows in a lookup table.

Syntax

cat <lookup-table-name>

Example

If the lookup table userinfo has a column username, run:

cat userinfo | where username = "john"

This query returns all rows where username equals john.