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

9 votes298 views2 answers
Python write yaml
Python
0 vote279 views1 answer
How to read PDF from link in Python]
Python
0 vote306 views1 answer
One2many add tuple
Python
0 vote261 views1 answer
How to capitalize words in python
Python
42 votes280 views6 answers
Python regex
Python
0 vote314 views1 answer
Alan watts
Python
0 vote291 views1 answer
Find maximum value by if else python
Python
6 votes256 views4 answers
Pandas rename multiple columns
Python
0 vote300 views1 answer
Equal Sides Of An Array python
Python
0 vote341 views1 answer
Case insensitive replace python
Python