Instead you could have your data dropped off in an S3 bucket in CSV format and you could use Athena to query those files the same way you'd query a regular SQL database.Īthena helps you analyze unstructured, semi-structured, and structured data stored in Amazon S3.
This is especially true if you are running large queries on large datasets. For example, if you need to process some data every day, you likely don't need a production server running all day. It will store your data in S3 at S3 prices and only charge you for the queries you execute (time + size of data queried). If you don't need high availablity and speed for your database, you should consider storing your data in a storage solution like Amazon Athena. Why Amazon Athena?ĭatabases cost a lot to run in both time and cash.
#Athena json query code
Serverless services such as AWS Lambda promise to take away that pain and provide you a way to focus on the real thing you care about, the execution of the code you write. However, as great and easy as it is to get rolling, when you're running production services, worrying about the infrastructure and dev ops side of things can catch you off-guard and ruin your day if there is a problem.
Simple, readable and readily available across the web ecosystem. I've used PHP since my Wordpress days back in 2007 and I've enjoyed using it. PHP specifically has been my main tool over the years. Traditionally I've used servers to run ETL jobs.
0 kommentar(er)
