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
-
Length: only displayed when Data Type is set to “String”.
Map Item attributes can reference data persisted as JSON. This feature is supported at the following database platforms:
-
Azure Database MySQL
-
Azure PostgreSQL
-
Azure SQL Database
-
Google BigQuery
-
PostgreSQL
-
SQL Server
-
Teradata