title: What are good options for cloud storage of audit data? (written continuously, rarely queried)
body: <p>I'm working on something which wants to store a lot of &quot;audit record&quot; style data. Such as &quot;user created a thing&quot;, &quot;user deleted a thing&quot;, &quot;user had 27 things&quot;.
  We want to store it in the cloud (AWS or possibly Azure). Ideally I'd like to use a cloud-native service such that I don't have to worry about things like scaling up server instances, sharding, etc.</p>
  <p>This kind of data is mostly a continuous stream of writes, and every so often a big &quot;report&quot; style query where we summarize or count a large block of data over a given date range. We need to query individual records approximately never.</p>
  <p>The go-to for &quot;cloud database in AWS&quot; seems to be DynamoDB, however the pricing model, and the articles I've been reading seem to imply it is designed for more of a transactional model. Writes are an order of magnitude more expensive than reads, which is the opposite to my use case.</p>
  <p>Those of you with deep cloud knowledge - please: What service(s) would you use for storing this kind of data and running reports on it? Is DynamoDB a bad choice here?</p>