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 vote288 views1 answer
Integer to boolean numpy
Python
39 votes267 views6 answers
Change column name df
Python
2 votes268 views2 answers
Get title attribute beautiful soup
Python
0 vote246 views1 answer
Textclip python arabic
Python
0 vote292 views1 answer
Reverse relationship in django for one to one field for usage in Django rest serializer
Python Django
0 vote273 views1 answer
Make a bot that spams space bar python
Python
1 vote262 views1 answer
For i in a for j in a loop python
Python
1 vote266 views1 answer
Set ttk combobox to readonly
Python
1 vote261 views1 answer
Array as an input in python
Python
0 vote310 views1 answer
Reading a list in python
Python