Amazon Redshift Data Types
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 type mappings applicable when working with an Amazon Redshift database.
Amazon Redshift Database Type
|
Spotfire Data Type
|
Supported
|
SMALLINT
|
Integer/Int
|
Yes
|
INTEGER
|
Integer/Int
|
Yes
|
BIGINT
|
LongInteger/Long
|
Yes
|
DECIMAL(p,s)
|
When p <= 9 and s = 0: Integer
When 9 < p <= 18 and s = 0: LongInteger
Else: Real
|
Yes
|
REAL
|
SingleReal/Float
|
Yes
|
DOUBLE PRECISION
|
Real/Double
|
Yes
|
FLOAT
|
Real
|
Yes
|
BOOLEAN
|
Boolean/Bool
|
Yes
|
CHAR
|
String
|
Yes
|
VARCHAR
|
String
|
Yes
|
DATE
|
Date
|
Yes
|
TIMESTAMP
|
DateTime
|
Yes
|
I'm very happy to search out this information processing system. I would like to thank you for this fantastic read!!
ReplyDeleteRedShift Training
AWS RedShift Training
Amazon RedShift Online Training