Data Cube: Schema Field Options
The following options are available for creating or editing the schema of a data source:
|Field Name||The name of the field in the schema.|
|Field Type||The type of data in the field.|
|Boolean||Values are either True or False.|
|Date||Values are dates formatted as year, month, and day (YYYY-MM-DD).
Note: By default, the date data format is yyyy-MM-dd HH:mm:ss as in 2016-01-01 01:00:00. If a data source contains a date field with a different format, use the Custom Date option to specify the format.
|Custom Date||Select to enter a custom format for the date data type.
The following are the acceptable date format symbols:
Note: After you enter a custom date format, you can use the custom date format on other data fields in the same data source. You do not need to re-enter the same custom date format for different fields in the same data source.
|Double||Values are double-precision floating point formatted decimal numbers.|
|Float||Values are single-precision floating point formatted decimal numbers.|
|Integer||Values are integer numbers between -32,768 and 32,767.|
|UNIX Timestamp||Values are UNIX time (the number of seconds that have elapsed since 00:00:00 UTC on January 1, 1970).|
|Long||Values are integer numbers between -2,147,483,648 and 2,147,483,647.|
|Long String||Values are a string with a maximum length of 4,294,967,295 characters.|
|Lowercase String||Values are a string with all lowercase characters.|
|String||Values are a string with a maximum length of 32,766 characters.|
|Text||Values are a text string with a maximum length of 255 characters.|
|Text_general||Only available for the file system data connector. Values are a text string.|
|Indexed||Select to crawl the schema field and its value. When selected, the relationship of the schema field its values are stored in the index. This option is useful if you want to create a facet-search functionality for your data source.|
|Multi Valued||Select to indicate that multiple values might be stored in the schema field.|
|Show in search results||Select when the value of the field should be made visible when displaying results of a search query. For example, search results typically only display metadata information, such as titles or location information, and not longer content.|
|Search By Default||Select when you want to perform a search query on the value of the field. When selected, the value of the field will be stored in a separate location for more efficient searches.|
|Index for Autocomplete||Select when you want to use the value of the schema field as a suggested search term when the user is typing a search query. Only select schema fields with shorter values for autocomplete.|
|Copy to field(s)||Select to copy the selected values to an existing field.