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

3 votes182 views2 answers
For loop python start at 1
Python
2 votes145 views1 answer
Suppres tensorflow warnings
Python
0 vote134 views1 answer
Values missing comparing datasets
Python
0 vote142 views1 answer
Python svg viewing
Python
2 votes128 views1 answer
Pass in queryset as filter django
Python
33 votes149 views6 answers
Bs4 python
Python
0 vote134 views1 answer
Color plt
Python
1 vote159 views1 answer
How to count post by category django
Python Django
1 vote89 views1 answer
Python replace part in large file
Python
0 vote149 views1 answer
How to subset a dataframe in python based on multiple categorical values
Python