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 votes224 views2 answers
Thread with args python
Python
2 votes204 views1 answer
How to call super class constructor in python two classes
Python
0 vote218 views1 answer
Regex to find ip address python
Python
6 votes230 views2 answers
Python generate dictionary in loop
Python
16 votes200 views5 answers
Convert pandas dataframe/ table to python dictionary
Python
2 votes225 views2 answers
Python format 001
Python
1 vote200 views1 answer
Prevent list index out of range python
Python
9 votes211 views1 answer
How to send get request python
Python
0 vote208 views1 answer
Pandas head sort by colun name
Python
0 vote230 views1 answer
List reverse method in python
Python