Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run. | A fully managed extract, transform, and load (ETL) service that makes it easy for customers to prepare and load their data for analytics. | A lightweight ETL framework with a focus on transparency and complexity reduction. |
| - | Easy - AWS Glue automates much of the effort in building, maintaining, and running ETL jobs. AWS Glue crawls your data sources, identifies data formats, and suggests schemas and transformations. AWS Glue automatically generates the code to execute your data transformations and loading processes.; Integrated - AWS Glue is integrated across a wide range of AWS services.; Serverless - AWS Glue is serverless. There is no infrastructure to provision or manage. AWS Glue handles provisioning, configuration, and scaling of the resources required to run your ETL jobs on a fully managed, scale-out Apache Spark environment. You pay only for the resources used while your jobs are running.; Developer Friendly - AWS Glue generates ETL code that is customizable, reusable, and portable, using familiar technology - Scala, Python, and Apache Spark. You can also import custom readers, writers and transformations into your Glue ETL code. Since the code AWS Glue generates is based on open frameworks, there is no lock-in. You can use it anywhere. | Data integration pipelines as code: pipelines, tasks and commands are created using declarative Python code.; PostgreSQL as a data processing engine.; Extensive web ui. The web browser as the main tool for inspecting, running and debugging pipelines.; GNU make semantics. Nodes depend on the completion of upstream nodes. No data dependencies or data flows.; No in-app data processing: command line tools as the main tool for interacting with databases and data.; Single machine pipeline execution based on Python's multiprocessing. No need for distributed task queues. Easy debugging and and output logging.; Cost based priority queues: nodes with higher cost (based on recorded run times) are run first. |