Data Deploy | Storing Key Value pair

rohitspathak123

Hi,

We have a requirement in which we need to same metadata of an asset as key value pair in a database table instead of having one to one mapping between metadata field and database column.

For e.g.,
Support there are 10 metadata fields (title, expiration date , author name , approver name ...etc etc ) . We will create database table with just 3 columns (asset_path , metadata_attribute , metadata_value)

Is it possible to configure data deploy, so that we can map different metadata fields name to same database column (metadata_attribute) and metadata field value to same database column (metadata_value) ?

Is someone has implemented this before please let me know your approach?

Regards
~ R

Adam Stoller

Hi, We have a requirement in which we need to same metadata of an asset as key value pair in a database table instead of having one to one mapping between metadata field and database column. For e.g., Support there are 10 metadata fields (title, expiration date , author name , approver name ...etc etc ) . We will create database table with just 3 columns (asset_path , metadata_attribute , metadata_value) Is it possible to configure data deploy, so that we can map different metadata fields name to same database column (metadata_attribute) and metadata field value to same database column (metadata_value) ? Is someone has implemented this before please let me know your approach? Regards ~ R

Read the DD manual - search for the term "narrow tuple"