Parameters | Description |
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. |
Refresh rate (  ) | Specifies the time until the source file is read in again. Default value is 12 h. |
RAQL query | Input field to enter any RAQL statement. Preset query: SELECT * FROM Dataset Dataset is the selected entry from the Dataset Alias dropdown box. |
Insert parameter (  ) | Inserts user defined input parameters at cursor position. The button is only clickable if at least one user input parameter, for example, Text user input, has already been inserted in the feed definition. See RAQL and SQL statement parameters for details. |
Expand (  ) / Collapse ( ) | Expands or collapses the 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. |