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 vote238 views1 answer
Find different between list
Python
0 vote210 views1 answer
How to set up flash message in html template in flask app
Python
6 votes218 views2 answers
Migrate data django
Python
0 vote224 views1 answer
Get the time of 1 minute later in python
Python
3 votes228 views4 answers
Replit
Python
0 vote238 views1 answer
Pandas add two string columns
Python
-1 vote212 views2 answers
How to find a square root of a number using python
Python
12 votes253 views6 answers
How to print a variable in python
Python
0 vote221 views1 answer
Could not find a version that satisfies the requirement psycopg2>=2.8 (from pgcli) (from versions: 2.7.5, 2.7.6, 2.7.6.1, 2.7.7)
Python
2 votes233 views2 answers
Conditional row delete pandas
Python