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

1 vote186 views1 answer
Paradigm meaning in python
Python
31 votes213 views4 answers
Python convert list of strings to list of integers
Python
33 votes153 views3 answers
Python return if else one line
Python
0 vote255 views1 answer
Python how to count number of true
Python
0 vote190 views1 answer
Python3 boto3 put and put_object to s3
Python
1 vote204 views2 answers
Making spark session
Python
0 vote183 views1 answer
Logout redirect url
Python
2 votes206 views1 answer
Covariance matrix python
Python
2 votes205 views5 answers
69
Python
0 vote198 views1 answer
How to split a string with newline in python
Python