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 vote160 views1 answer
Filter directory in python
Python
0 vote141 views1 answer
Python filter timestamp
Python
1 vote120 views1 answer
Creating an interface tkinter
Python
0 vote125 views1 answer
Flat numpy array
Python
1 vote156 views1 answer
Matplotlib get rid of gridlines
Python
0 vote117 views1 answer
Set a random seed
Python
2 votes149 views1 answer
Run flask application in development mode stack overflow
Python Flask
0 vote124 views1 answer
Get os info in python
Python
0 vote120 views1 answer
Python search list of lists for value return index
Python
3 votes115 views1 answer
Sum of any numbers in python
Python