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