Tableau Hyper User Attributes

The type of a column in a table. The valid values for the column type are listed below:

boolean

Boolean fields store true/false data. Data that is read from or written to these fields must always have a value of either true or false.

char, varchar (string)

String fields store variable-length character data up to a length of 32767 characters.

Values larger than 32767 are truncated.

date

This type is used to represent date data from January 1, 1000 to December 31, 9999. The date values are represented as MM/DD/YYYY in Tableau. For example, January 10, 1000 would be represented as 1/10/1000.

Date values must also be valid days according to the Georgian calendar. For example, April 31 and February 29, 2015 are not valid date values.

Parameters:

• year – the year (value must be a 4-digit year)
• month – the month (value must be 1-12)
• day – the day (values must be 1-31)

See Standard FME Date/Time Format for information about the formatting of FME date and time as input produced by the reader for date cells. See the Formatting section below for the options for custom number formatting, which also applies to date types.

time

This type is used to represent time data from 0:00:00 (midnight) to 23:59:59. The time values are represented as hh/mm/ss.ss in Tableau. For example, 8:30:05pm would be represented as 20:30:05.00

Time values must be valid 24-hour clock times. For example, 25:20 and 4:64 are not valid time values.

Parameters:

• hour – the hour (values must be 0-23)
• minute – the minute (values must be 0-59)
• second – the second (values must be 0-59)
• fraction – the fraction of a second in tenths of a millisecond (values must be 0-9999)

See Standard FME Date/Time Format for information about the formatting of FME date and time as input produced by the reader for date cells. See the Formatting section below for the options for custom number formatting, which also applies to time types.

interval

This type is used to represent a span of time that can represent a few seconds to a period of years. The interval values would be represented as MM/DD/YYYY HH:MM:SS (AM/PM) in Tableau.

Parameters:

• year – the year (value must be a 4-digit year)
• month – the month (value must be 1-12)
• day – the day (values must be 1-31)
• hour – the hour (values must be 0-23)
• minute – the minute (values must be 0-59)
• second – the second (values must be 0-59)
• fraction – the fraction of a second in tenths of a millisecond (values must be 0-9999)

The fraction of a second (fraction parameter) is used to round the interval data type to the appropriate value in seconds. If the fraction parameter is between 5001-9999, the Interval data is rounded up a second. For example, the Interval data 1/1/5 10:00:05with a fractional second value of 5001-9999 will be displayed as 1/1/5 10:00:06.

See Standard FME Date/Time Format for information about the formatting of FME date and time as input produced by the reader for date cells.

timestamp, timestamptz

This type is used to represent date and time data from January 1, 1000 to December 31, 9999 with an accuracy of 0.1 millisecond. The date time values would be represented as MM/DD/YYYY HH:MM:SS (AM/PM) in Tableau.

Parameters:

• year – the year (value must be a 4-digit year)
• month – the month (value must be 1-12)
• day – the day (values must be 1-31)
• hour – the hour (values must be 0-23)
• minute – the minute (values must be 0-59)
• second – the second (values must be 0-59)
• fraction – the fraction of a second in tenths of a millisecond (values must be 0-9999)
• offset (timestamptz only) – The offset in hours:minutes from UTC (values must be -12:00 - 12:00)

The fraction of a second (fraction parameter) is used to round the Datetime data type to the appropriate value in seconds. If the fraction parameter is between 5001-9999, the Datetime data is rounded up a second. For example, the Datetime data 1/1/2010 10:00:05 AM with a fractional second value of 5001-9999 will be displayed as 1/1/2010 10:00:06 AM.

See Standard FME Date/Time Format for information about the formatting of FME date and time as input produced by the reader for date cells.

double

Double fields store double-precision floating-point values.

numeric

Numeric fields store fixed-precision decimal values specified by width and precision. Width is the total number of significant figures in the value, and precision is the number of digits to the right of the decimal. Width must not exceed 18, and precision must be less than width.

Specifying a precision of 0 causes the numeric type to act nearly equivalently as bigint.

smallint, int, bigint

Number fields that can store 16, 32, and 64-bit signed integers.