I have found this and will turn to aws glue to transform and create multiple rows - Split values from a field and create rows for each value
I have found this and will turn to aws glue to transform and create multiple rows - Split values from a field and create rows for each value