Press CTRL+K to open search

Ad-hoc query reference

  • Published on Sep 7, 2026
  • 1 minute(s) read
Prev Next

Ad-hoc queries require operators, data types, and other information that you can access in your scripts.

In general, the data type in the column dictates the operators that the column supports. For example:

  • Data type string supports the startsWith and endsWith operations

  • Number columns support the gt and lt operations

Note

The data types and types of columns in a target can be determined using the core.listTables command.

These tables provide these basic elements and examples of their use.