title: After numerous (error-free) inserts to Aurora (PostgreSQL) RDS serverless cluster with SQLAlchemy I can't see the table. What happened to my data?
body: <p>After changes to some Terraform code, I can no longer access the data I've added into an Aurora (PostgreSQL) database. The data gets added into the database as expected without errors in the logs but I can't find the data after connecting to the database with AWS RDS Query Editor.</p>
  
  <p>I have added thousands of rows with Python code that uses the SQLAlchemy/PostgreSQL engine object to insert a batch of rows from a mappings dictionary, like so:</p>
  
  <pre class="lang-py prettyprint-override"><code>if (count % batch_size) == 0:
      self.engine.execute(Building.__table__.insert(), mappings)
      self.session.commit()
  </code></pre>
  
  <p>The logs from this data ingest show no errors, the commits all appear to have completed successfully. So the data was inserted <em>someplace</em>, I just can't work out where that is, as it's not showing up in the AWS Console RDS Query Editor. I run the SQL below to find the table, with zero rows returned:</p>
  
  <pre><code>SELECT * FROM information_schema.tables WHERE table_name = 'buildings'
  </code></pre>
  
  <p>This has worked as expected before (i.e. I could see the data in the Aurora database via the Query Editor) so I'm trying to work out which of the recently modified Terraform settings have caused the issue.</p>
  
  <p>Where else can I look to find where the data was inserted, assuming that it was actually inserted somewhere? If I can work that out it may help reveal the culprit.</p>