title: How to unload data from Redshift to S3?
body: <p>I've been trying to unload some data from Redshift to the S3 bucket.
  Except I've been getting the following error:</p>
  
  <blockquote>
    <p>Amazon Invalid operation: cannot drop active portal; [SQL State=XX000, DB Errorcode=500310]</p>
  </blockquote>
  
  <p>To note the Redshift and S3 are in 2 different buckets so I specified the region within the unload.</p>
  
  <p>I've tried looking it up, it mentions that I can't drop the table.</p>
  
  <p>So I created a "test" table that I am 100% certain is not connected to any view or other but I still get the same error.</p>
  
  <p>I tried also troubleshooting through <a href="https://medium.com/faun/awsquicksolutions-redshift-table-cant-be-dropped-or-drop-table-hangs-1aff3da223e6" rel="noreferrer">AWSQuickSolutions: Redshift Table Can’t Be Dropped or Drop Table Hangs</a> except I do not have access to <code>svv_table_info</code>.</p>
  
  <p>Is there any way to do the unload?</p>