shillelagh
PyAthena
shillelagh | PyAthena | |
---|---|---|
7 | 1 | |
354 | 448 | |
- | - | |
8.0 | 9.0 | |
6 days ago | 6 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.
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!
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.
What are some alternatives?
superset - Apache Superset is a Data Visualization and Data Exploration Platform
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).
sqlalchemy-filters-plus - Lightweight library for providing filtering mechanism for your APIs using SQLAlchemy
pyodbc - Python ODBC bridge
PyHive - Python interface to Hive and Presto. 🐝
fastapi-crudrouter - A dynamic FastAPI router that automatically creates CRUD routes for your models
athena-glue-service-logs - Glue scripts for converting AWS Service Logs for use in Athena
q - q - Run SQL directly on delimited files and multi-file sqlite databases
flask-sqlalchemy - Adds SQLAlchemy support to Flask
Redash - Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.