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 Teradata database.
Teradata Data Type |
Spotfire Data Type |
Comment |
BLOB |
Binary |
|
BYTE |
Binary |
|
VARBYTE |
Binary |
|
DATE |
Date |
|
PERIOD DATE |
Date |
As two columns, begin/end |
PERIOD TIMESTAMP |
DateTime |
As two columns, begin/end |
PERIOD TIMESTAMP WITH TIME ZONE |
DateTime |
As two columns, begin/end |
TIMESTAMP |
DateTime |
|
TIMESTAMP WITH TIMEZONE |
DateTime |
|
BYTEINT |
Integer |
|
INTEGER |
Integer |
|
SMALLINT |
Integer |
|
BIGINT |
LongInteger |
|
FLOAT |
Real |
|
NUMBER |
Real |
|
CHARACTER |
String |
|
GRAPHIC |
String |
|
JSON |
String |
Because of limitations in the Teradata cast function, you can load JSON columns with a maximum of 32000 characters into Spotfire. The entirety of the JSON code, including tags, is included in the character count.
When you define prompts for JSON columns from Teradata, only the prompt type Manual input is available. |
LONG VARCHAR |
String |
|
LONG VARGRAPHIC |
String |
|
VARCHAR |
String |
|
VARGRAPHIC |
String |
|
XML |
String |
Because of limitations in the Teradata cast function, you can load XML columns with a maximum of 32000 characters into Spotfire. The entirety of the XML code, including tags, is included in the character count. |
PERIOD TIME |
Time |
As two columns, begin/end |
PERIOD TIME WITH TIME ZONE |
Time |
As two columns, begin/end |
TIME |
Time |
|
TIME WITH TIME ZONE |
Time |
|
INTERVAL DAY |
TimeSpan |
|
INTERVAL DAY TO HOUR |
TimeSpan |
|
INTERVAL DAY TO MINUTE |
TimeSpan |
|
INTERVAL DAY TO SECOND |
TimeSpan |
|
INTERVAL HOUR |
TimeSpan |
|
INTERVAL HOUR TO MINUTE |
TimeSpan |
|
INTERVAL HOUR TO SECOND |
TimeSpan |
|
INTERVAL MINUTE |
TimeSpan |
|
INTERVAL MINUTE TO SECOND |
TimeSpan |
|
INTERVAL SECOND |
TimeSpan |
|
DECIMAL(p,s) |
When p <= 9 and
s = 0: Integer |
|
Any other data types are not supported.
Note: User defined data types, including geometry types, are not supported.
Data in Amazon S3 and Microsoft Azure Blob
If your Teradata instance supports Native Object Storage (NOS), you can query and analyze data from files in Amazon S3 and Microsoft Azure Blob in Spotfire. With NOS functionality, you can define foreign tables for files in S3 and Azure Blob. Then in Spotfire, you can access the data by selecting those database tables in your connection.