Dataset alias

List of available Terracotta DB datasets for the configured connection aliases.

Only Dataset aliases for that you have the Usage privilege are available. Select a Dataset alias. See Manage Terracotta DB connections for details.

Specifies the time to live for a cached query result before it expires. Default value is 12 h.

RAQL query

Input field to enter any RAQL statement. See example BigMemory data source below.

Preset query: SELECT * FROM Dataset

with Dataset being the selected entry from the Dataset Alias dropdown box.

Inserts user defined input parameters at cursor position. The button is only clickable if at least one user input parameter, e.g., Text user input, has already been inserted in the feed definition.

Enables you to set input parameter options

Expands or collapses the RAQL query input box.

Configure columns

Configures the columns of the dataset.

When selecting a dataset, schema guessing is used to derive its columns. Using 1000 records, the guessing mechanism derives the set of all unique cell definitions of those records and defines corresponding columns. Use Configure columns to display or modify that schema.

Unselect a column to exclude it from processing. Select or enter a (positive) Sample size and click Derive columns to re-run the schema guessing with a larger sample size, thereby omitting the current configuration. Note that the larger the sample size is, the longer the schema guessing takes.

Click Add column to manually add a new column. Enter a unique column name and select a data type for the new column. Note that the combination of name and type has to fit to the cell definition in the store. If not, the corresponding values will always be null. For example, if the cell definition is age with type INT and you specify age with type DOUBLE, the column definition does not fit to the cell definition and the values are null.