title: Split a redshift column into multiple columns
body: <p>I have a my table in redshift that contains some aggregation of data</p>
  
  <pre><code>Product_id , options_id
  1,           tag1:value1&amp;tag2:value2
  </code></pre>
  
  <p>I want instead to have a view that displays them as follows:</p>
  
  <pre><code> Product_id , tag1 , tag2
   1 ,           value1 , value 2
  </code></pre>
  
  <p>Is there a way to do this?</p>
  
  <p>I can only find people online that split it into multiple rows instead, like here:</p>
  
  <p><a href="https://www.holistics.io/blog/splitting-array-string-into-rows-in-amazon-redshift-or-mysql/" rel="nofollow noreferrer">https://www.holistics.io/blog/splitting-array-string-into-rows-in-amazon-redshift-or-mysql/</a></p>
  
  <p>but that does not serve my purpose</p>