Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.5.6
  3. Part 2: Version 10.5.5 - 10.5.5.x
  4. Part 3: Version 10.5.4 - 10.5.4.x
  5. Part 4: Version 10.5.3 - 10.5.3.x
  6. Part 5: Version 10.5.2 - 10.5.2.1.x
  7. Part 6: Version 10.5.1 - 10.5.1.1
  8. Part 7: Versions 10.5 - 10.5.0.1
  9. Part 8: Versions 10.4.1 - 10.4.1.3
  10. Part 9: Versions 10.4 - 10.4.0.2
  11. Part 10: Versions 10.2.2 - 10.2.2 HotFix 1
  12. Part 11: Version 10.2.1
  13. Part 12: Version 10.2 - 10.2 HotFix 2

What's New and Changed (10.5.6)

What's New and Changed (10.5.6)

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.

0 COMMENTS

We’d like to hear from you!