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

6 votes376 views2 answers
Flask docker
Python
0 vote349 views1 answer
Pandas count freq of each value
Python
0 vote307 views2 answers
Python pandas apply function that returns multiple columns
Python
27 votes388 views5 answers
Panda python install
Python
7 votes399 views3 answers
How to display data in ascending order in django
Python Django
0 vote347 views1 answer
Operation that returns True if all values are equal
Python
7 votes336 views3 answers
How to display data in ascending order in django
Python
0 vote363 views1 answer
Exclude last value of an array python
Python
4 votes387 views1 answer
Video streaming flask
Python Flask
1 vote350 views1 answer
Ls.ProgrammingError: permission denied for table django_migrations
Python Django