PyAthena vs dbt-athena

Our great sponsors

WorkOS - The modern identity platform for B2B SaaS

InfluxDB - Power Real-Time Data Analytics at Scale

SaaSHub - Software Alternatives and Reviews

Our great sponsors

PyAthena		dbt-athena
	Project
1	Mentions	1
447	Stars	184
-	Growth	7.6%
9.1	Activity	9.2
17 days ago	Latest Commit	4 days ago
Python	Language	Python
MIT License	License	Apache License 2.0

The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

PyAthena

Posts with mentions or reviews of PyAthena. We have used some of these posts to build our list of alternatives and similar projects.

Best Practices for AWS Athena Queries
1 project | /r/dataengineering | 15 Aug 2021

For python there is PyAthena which is a nice little wrapper around boto3 that tries to adhere to the python DB API.

dbt-athena

Posts with mentions or reviews of dbt-athena. We have used some of these posts to build our list of alternatives and similar projects.

Is dbt + athena/presto a viable stack? how do you orchestrate creation and maintenance of your athena/presto tables?
1 project | /r/dataengineering | 7 Apr 2023

Be sure to use the https://github.com/dbt-athena/dbt-athena connector.

What are some alternatives?

When comparing PyAthena and dbt-athena you can also consider the following projects:

AWS Data Wrangler - pandas on AWS - Easy integration with Athena, Glue, Redshift, Timestream, Neptune, OpenSearch, QuickSight, Chime, CloudWatchLogs, DynamoDB, EMR, SecretManager, PostgreSQL, MySQL, SQLServer and S3 (Parquet, CSV, JSON and EXCEL).

pyodbc - Python ODBC bridge

aws-data-wrangler - pandas on AWS - Easy integration with Athena, Glue, Redshift, Timestream, Neptune, OpenSearch, QuickSight, Chime, CloudWatchLogs, DynamoDB, EMR, SecretManager, PostgreSQL, MySQL, SQLServer and S3 (Parquet, CSV, JSON and EXCEL). [Moved to: https://github.com/aws/aws-sdk-pandas]

PyHive - Python interface to Hive and Presto. 🐝

athena-glue-service-logs - Glue scripts for converting AWS Service Logs for use in Athena

shillelagh - Making it easy to query APIs via SQL

Redash - Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.

aws-incident-response-playbooks-workshop

flask-sqlalchemy - Adds SQLAlchemy support to Flask

Mage - 🧙 The modern replacement for Airflow. Mage is an open-source data pipeline tool for transforming and integrating data. https://github.com/mage-ai/mage-ai