Amazon Athena vs Teiid
Amazon Athena
aws.amazon.comTeiid
teiid.ioSide by side
| Figure | Amazon Athena | Teiid |
|---|---|---|
| Price from | $0.30/mo | Free |
| Free plan | — | Yes |
| Free trial | — | — |
| Open source | — | — |
| Web | Yes | — |
| Linux | — | Yes |
| API | Yes | Yes |
| Self-hosted | — | Yes |
| Plans published | 3 | 1 |
| Spec score · Query Engine Software | 7.8 (#13) | 8.0 (#11) |
| Purpose | Amazon Athena is a serverless interactive query service for analyzing data in Amazon S3 with standard SQL. | Teiid is a Java data virtualization query engine that integrates data from multiple sources through a uniform API. |
| Security | Access to data can be controlled with IAM policies, access control lists, and S3 bucket policies, and Athena supports querying encrypted S3 data and writing encrypted results. | The site describes Teiid as providing secure data access and says Spring Boot projects can select security integration among their dependencies. |
Plans
Amazon Athena
- SQL queries with Capacity Reservations$0.30 a month
- Apache Spark$0.35 a month
- SQL queries$5 a month
In their own words
Amazon Athena
Amazon Athena has no write-up on Specifiction yet; its figures are above.
Teiid
Teiid is a free, open-source data virtualization project that gives applications a uniform way to query multiple underlying sources. It works as a gateway rather than storing the data, and virtual databases can present separate sources together so applications can join or union their results. Access is available through JDBC, ODBC, OData, and REST. Built-in translators are listed for Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files; custom translators can also be made. Its optimizer uses source capability information to send query work to underlying systems where possible. Documented runtimes include Spring Boot, WildFly, embedded Java, and OpenShift, with Spring Boot noted as less feature-complete than WildFly. Teiid is aimed especially at Java developers integrating enterprise data sources. Connecting to sources commonly requires third-party drivers that are not included. The FAQ cautions that big-data, LDAP-style, and primarily streaming workloads may not be a good fit. Teiid Designer is deprecated, with no further releases expected.