title: Redshift. Convert comma delimited values into rows
body: <p>I am wondering how to convert comma-delimited values into rows in Redshift. I am afraid that my own solution isn't optimal. Please advise. I have table with one of the columns with coma-separated values. For example:</p>
  
  <p>I have:</p>
  
  <pre><code>user_id|user_name|user_action
  -----------------------------
  1      | Shone   | start,stop,cancell...
  </code></pre>
  
  <p>I would like to see</p>
  
  <pre><code>user_id|user_name|parsed_action 
  ------------------------------- 
  1      | Shone   | start        
  1      | Shone   | stop         
  1      | Shone   | cancell      
  ....
  </code></pre>