Postgresql, Redshift, Etl, Transformation, Data Warehouse.
— and we want to break that array into many columns for the purpose of analysis. We must decide preemptively how many maximum possible values this array can hold and create columns for each value. Similarly, we can get all the array elements stored as columns but we would have to know how many