PyAthena
shillelagh
Our great sponsors
| PyAthena | shillelagh | |
|---|---|---|
| 1 | 7 | |
| 447 | 351 | |
| - | - | |
| 9.1 | 8.0 | |
| 17 days ago | 4 days ago | |
| Python | Python | |
| MIT License | MIT License |
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.
shillelagh
-
Apache Superset
It should be possible (have not tried myself):
https://preset.io/blog/accessing-apis-with-superset/
"Shillelagh (ʃɪˈleɪlɪ) is a Python library and CLI that allows you to query many resources (APIs, files, in memory objects) using SQL. It's both user and developer friendly, making it trivial to access resources and easy to add support for new ones"
https://github.com/betodealmeida/shillelagh
- Python: Making it easy to query APIs via SQL (Shillelagh)
-
Need inspo
Shillelagh (https://github.com/betodealmeida/shillelagh) is a wrapper that allows users to query APIs using SQL. You can join weather data with a Google spreadsheet, for example. It always need more help in adding adapters for new data sources.
-
A library for querying APIs and files using SQL
You can read more about it in the architecture document.
-
Easy way of copying web data to excel.
I'm adding this to Apache Superset today!
-
ELIA5: Spark/Hive syntactical SQL
- Shillelagh (https://github.com/betodealmeida/shillelagh): query API's .. using SQL!
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).
superset - Apache Superset is a Data Visualization and Data Exploration Platform
pyodbc - Python ODBC bridge
sqlalchemy-filters-plus - Lightweight library for providing filtering mechanism for your APIs using SQLAlchemy
PyHive - Python interface to Hive and Presto. 🐝
athena-glue-service-logs - Glue scripts for converting AWS Service Logs for use in Athena
fastapi-crudrouter - A dynamic FastAPI router that automatically creates CRUD routes for your models
flask-sqlalchemy - Adds SQLAlchemy support to Flask
q - q - Run SQL directly on delimited files and multi-file sqlite databases
Redash - Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.