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

13 votes259 views2 answers
Year to datetime python
Python
2 votes373 views1 answer
Pytorch create tensor
Python
0 vote289 views1 answer
Same elements of two sets in python
Python
-1 vote309 views1 answer
How to call a class in python
Python
0 vote311 views1 answer
Convert month weeks days into month days in python pandas
Python
0 vote282 views1 answer
Max of double array python
Python
0 vote326 views1 answer
Flask get uploaded file size
Python
0 vote325 views1 answer
How to remove misspelled words in nltk
Python
2 votes291 views3 answers
Weather today
Python
1 vote316 views1 answer
Matplotlib wrap title
Python