Support for flatten arrays

[pcorbel]

Describe the feature Currently, when we got an array, it is stored as a string in Redshift.

Example:

{"hello": "world", "array_of_properties": [10, 20, 30]}

will be stored as

• Table hello

hello	array_of_properties
world	[10, 20 , 30]

Some other redshift-target proposes a flatten feature where the output will be like

• Table hello

hello	array_of_properties_id
world	abcdef

• Table hello__array_of_properties

source_properties_id	level_id	value
abcdef	0	10
abcdef	1	20
abcdef	2	30

It would be nice to have this feature via a property like does_flatten_arrays in the config.json file

[gbachRM]

This would be amazing if it could be implemented!!