PyAthena
dbt-athena
Our great sponsors
PyAthena | dbt-athena | |
---|---|---|
1 | 1 | |
447 | 184 | |
- | 7.6% | |
9.1 | 9.2 | |
17 days ago | 3 days ago | |
Python | Python | |
MIT License | Apache License 2.0 |
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
-
Best Practices for AWS Athena Queries
For python there is PyAthena which is a nice little wrapper around boto3 that tries to adhere to the python DB API.
dbt-athena
-
Is dbt + athena/presto a viable stack? how do you orchestrate creation and maintenance of your athena/presto tables?
Be sure to use the https://github.com/dbt-athena/dbt-athena connector.
What are some alternatives?
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