Product: TIBCO Spotfire®
Can TIBCO Spotfire read "Serial" Data Type from a PostgreSQL data table?
In PostgreSQL, the data types 'smallserial', 'serial' and 'bigserial' are not true data types, but merely a notational convenience for creating unique identifier columns. When a custom query (in Spotfire connector) is used to retrieve data from a PostgreSQL data table that contains column type(s) as serial, Spotfire throws a query verification error as below:
Unable to map the following columns:
– Column <column name> with data type 'serial' This is a product limitation for Spotfire versions 7.13 and below. This can be handled using the below workarounds:
- Using the data table directly instead of writing a custom query.
- Changing the data type of 'Serial' to 'Integer' in the database itself.
- Casting the 'serial' column type to 'varchar'. Inside the custom query dialog box, you can write a type-casted select query like: "select CAST (serial_col AS VARCHAR) from table".
Note: This limitation is addressed in Spotfire version 7.14 and higher. The mapping of serial data types in Spotfire is as follows:
|PostgreSQL data type||Spotfire data type|