Dataset Lookup tool

The Dataset Lookup tool searches for and retrieves records from a Dataiku dataset.

Configuration

Configure the tool by specifying the dataset to search.

Usage

To use the tool, provide a filter to specify the search criteria. Construct the filter clause programmatically with the DSSSimpleFilter helper class.

The filter clause supports the following operators:

  • EQUALS

  • NOT_EQUALS

  • GREATER_THAN

  • LESS_THAN

  • DEFINED

  • NOT_DEFINED

  • CONTAINS

  • MATCHES (for regular expressions)

  • AND

  • OR

To find the call schema of the tool, use its descriptor. See Using tools for more details.

Limitations

This tool is designed for looking up and returning a small number of records. It does not support aggregations, sorting, or other complex queries. For these use cases, use the SQL Query tool.