Amazon Redshift's Compatibility with the SUPER Data Type
Amazon Redshift's Compatibility with the SUPER Data Type
Effective in version 10.5.6, the PowerExchange for Amazon Redshift introduces a data type called SUPER. The SUPER data type stores semi-structured data like JSON and relational data. It accommodates various forms of Amazon Redshift scalar data, such as null, boolean, numbers, such as smallint, integer, bigint, decimal, and floating point. It also supports string values, such as varchar and char along with complex formats including arrays and nested structures.
The supported native transformation data type for SUPER is the Varchar (String) data type. The default precision for the SUPER data type column is 256. Highest precision is 16 MB.
For more information, see the
Informatica® PowerExchange for Amazon Redshift User Guide.