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 vote265 views1 answer
Apply a created function pandas
Python
2 votes292 views1 answer
Get stats from array
Python
1 vote278 views2 answers
How ro have a incresing variable in python
Python
14 votes246 views2 answers
Tkinter clear canvas
Python
0 vote297 views1 answer
List Get Sublist
Python
0 vote383 views1 answer
How to get SITE_ID in django....shell
Python Django
0 vote289 views1 answer
Python take input without displaying it
Python
0 vote235 views1 answer
Scipy.arange is deprecated and will be removed
Python
16 votes280 views3 answers
How to read the first line in a file python
Python
0 vote294 views1 answer
Deactivate pandas warning copy
Python