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

1 vote154 views2 answers
Adding numbers in python
Python
0 vote172 views1 answer
Django require_POST body
Python
7 votes162 views1 answer
How to slicing dataframe using two conditions
Python
0 vote140 views1 answer
Pdfkit supress output
Python
0 vote167 views1 answer
Pandas recognize type from strings
Python
20 votes100 views3 answers
Python reload module
Python
0 vote169 views1 answer
Bouon arrondi tkinter
Python
2 votes156 views1 answer
Check if image is empty opencv python
Python
0 vote159 views1 answer
Save impt
Python
19 votes174 views2 answers
Learn python 3
Python