Map Item Attribute Properties

The following interface is displayed when configuring a Map Item attribute:

A Map item attribute allows you to access data within an element contained within a map value and indexed via a key.

A Map item attribute has the following specific properties:

•      Map Column: a mandatory database column, which contains the map data.

•      Key Value: a mandatory key, which is used to access a specific element within the map data.  Key value can be a maximum of length 100 characters in length.

•      Data Type

Map Item attributes can reference data persisted as JSON.  This feature is supported at the following database platforms:

•      AWS Redshift

•      Amazon Aurora (v5.7.x)

•      Azure PostgreSQL

•      Azure Database MySQL

•      Azure SQL Database

•      Cassandra (Compare to List criteria not supported)

•      DB2

•      MySQL

•      MariaDB

•      Oracle (v12.x)

•      PostgreSQL

•      Snowflake

•      SQL Server (2016+ only)

•      Teradata (v15)

•      Vertica