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

0 vote184 views1 answer
Progressbar time in python
Python
2 votes185 views2 answers
Python greatest common divisor
Python
1 vote199 views1 answer
Django loop index
Python Django
0 vote171 views1 answer
Pydrive set parents
Python
0 vote165 views1 answer
Where to import kivy builder
Python
21 votes193 views6 answers
Python list directories only
Python
12 votes175 views6 answers
Print variable python
Python
0 vote175 views4 answers
Install python in dockerfile
Python
0 vote360 views1 answer
Selenium python get element by type
Python
0 vote312 views1 answer
How to make my discord bot shut down with a command
Python