Loading...

Data Cube: Schema Field Options

The following options are available for creating or editing the schema of a data source:

Option Description
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:

  • y - year
  • M - month
  • d - day
  • h - hour
  • m - minutes
  • s - seconds
  • S - milliseconds
  • z - time zone

Examples:

  • To format Aug 13, 2015 EST 08:07:37 AM, enter MMM dd, yyyy zz hh:mm:ss.
  • To format 13/08/2015 08:07:37, enter dd/MM/yyyy hh:mm:ss.

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.

Notes:

  • Only the values of the source field are copied to the destination field. No attributes or field type changes of the source field are applied to the destination field.
  • If the destination fields already contain values, then you must configure the destination field(s) as Multi Valued, otherwise the crawl will fail.