When you are setting up a connection to an external data source, Spotfire needs to map the data types in the data source to data types in Spotfire. See below for a list of the different data types that Spotfire supports and the applied data type mappings when working with a Dremio database.
Dremio Data Type |
Spotfire Data Type |
BINARY |
Binary |
BINARY VARYING |
Binary |
VARBINARY |
Binary |
BIT |
Boolean |
BOOLEAN |
Boolean |
DATE |
Date |
TIME WITH TIME ZONE |
DateTime |
TIMESTAMP |
DateTime |
TIMESTAMP WITH TIME ZONE |
DateTime |
DECIMAL |
Currency/Decimal |
DOUBLE |
Real/Double |
REAL |
SingleReal/Float |
INTEGER |
Integer |
SMALLINT |
Integer |
TINYINT |
Integer |
BIGINT |
LongInteger/Long |
ANY |
String |
ARRAY |
String |
CHAR |
String |
CHARACTER |
String |
CHARACTER VARYING |
String |
MAP |
String |
NATIONAL CHARACTER |
String |
NATIONAL CHARACTER VARYING |
String |
NULL |
String |
UNION |
String |
VARCHAR |
String |
WCHAR |
String |
WVARCHAR |
String |
TIME |
Time |
For specific information about what types of data and data sources are supported, and how that data is handled, see the official documentation from Dremio.