title: Redshift: Table is deleted from the DB with in 5 minutes automatically
body: <p>I'm trying to create the table in the redshift DB using the SQL workbench using the following command. </p>
  
  <pre><code>CREATE TABLE test_table (columnone varchar, columntwo varchar, 
  columnthree varchar,columnfour varchar,columnfive varchar,columnsix 
  varchar,columnseven varchar,columneight varchar);
  </code></pre>
  
  <p>It is created successfully. </p>
  
  <p>I verified the table is created from the following line. and saw the table is present and table_type is BASE TABLE</p>
  
  <pre><code>SELECT * FROM information_schema.tables WHERE table_schema = 'public'; 
  </code></pre>
  
  <p>I was able to insert the data into the table. </p>
  
  <pre><code>INSERT INTO test_table VALUES ('123456', '123456', 
  '123456','123456', '123456','123456','123456','123456');
  </code></pre>
  
  <p>Row insertion is done successfully</p>
  
  <p>After that I performed the query </p>
  
  <pre><code> Select * from test_table 
  </code></pre>
  
  <p>and I'm able to see the results as well for this</p>
  
  <p>But after 5 to 10 mins table is deleted.</p>
  
  <p>I checked that table is not available in the DB by executing the following line</p>
  
  <pre><code>SELECT * FROM information_schema.tables WHERE table_schema = 'public'; 
  </code></pre>
  
  <p>I googled it and was not able to find any. I'm new to redshift and SQL was there any mistake I did while creating the table. The tables that are created in this DB by some other people earlier are available still. I also checked with the people who created tables earlier are not able to figure out what is the issue</p>