Athena connector python

from pyathena import connect
from pyathena.util import as_pandas

cursor = connect(aws_access_key_id="YOUR_ACCESS_KEY_ID",
                 aws_secret_access_key="YOUR_SECRET_ACCESS_KEY",
                 s3_staging_dir="s3://YOUR_S3_BUCKET/path/to/",
                 region_name="us-west-2").cursor()
cursor.execute("SELECT * FROM many_rows")
df = as_pandas(cursor)
print(df.describe())

Source: pypi.org

Similar codes

2 votes256 views1 answer
Python project tutorial
Python
0 vote191 views1 answer
How to convert a axis label to non scientific notation in matploltlib
Python
1 vote196 views3 answers
Pyqt5 change button color
Python
1 vote192 views1 answer
Determine the sum of al digits of n
Python
0 vote184 views1 answer
Pytorch cuda tensor in module
Python
0 vote187 views1 answer
Forbidden (CSRF token missing or incorrect.): /extension/stripe-pay/ WARNING 2021-06-01 13:45:22,532 log 408 140165573588736 Forbidden (CSRF token missing or incorrect.): /extension/stripe-pay/
Python
6 votes192 views2 answers
How to sort a list randomly in python
Python
11 votes260 views2 answers
Yesterday in python
Python
0 vote251 views2 answers
Blog in django
Python Django
5 votes181 views2 answers
My django template doesnt want to load the static file
Python