Ad-hoc query reference

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.