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 vote205 views1 answer
Export python pandas dataframe as json file
Python
0 vote199 views1 answer
Python time function duration and memory usage
Python
6 votes262 views1 answer
Django desc order
Python Django
0 vote192 views1 answer
Max sum slice python 1 - autopilot
Python
0 vote144 views1 answer
Django trim string whitespace
Python
37 votes285 views4 answers
Python To find the sum of all the elements in a list.
Python
0 vote150 views1 answer
Pandas summary
Python
0 vote200 views1 answer
Assert integer python
Python
0 vote161 views1 answer
Python3 delete file
Python
3 votes235 views2 answers
Django postgres connection
Python Django