title: Debug why Firehose is not delivering to Redshift
body: <p>I setup a Firehose stream that delivers data to my Redshift cluster. It was working for a short period but suddenly seemed to stop delivering to redshift. From my </p>
  
  <pre><code>select * from stl_query order by endtime desc limit 10;
  select * from stl_load_errors order by starttime desc;
  select * from stl_connection_log where remotehost like '52%' order by recordtime desc; 
  select * from stl_error where userid!=0 order by recordtime desc;
  </code></pre>
  
  <p>Running those commands does not list the most recent connections or copy. For example I see:</p>
  
  <pre><code>disconnecting session  ... 52.70.63.204  ...         
  initiating session   ...    52.70.63.204      ... 
  </code></pre>
  
  <p>... in my connection logs but it stops after a certain time. I've tried recreating the table and the stream but it still does not list anything. All my data is being recieved in S3 however.<br>
  The other problem is that there are no error manifests in the s3 directory which indicates nothing failed.<br>
  How can I debug this?</p>