· 6 years ago · Apr 07, 2019, 09:46 PM
1from pyathena import connect
2import pandas as pd
3import seaborn
4import os
5
6#environment vars
7access_key = os.environ['AWS_ACCESS_KEY_ID']
8secret_key = os.environ['AWS_SECRET_ACCESS_KEY']
9staging = os.environ['AWS_S3_STAGING']
10region = os.environ['AWS_REGION']
11
12conn = connect(aws_access_key_id=access_key,
13 aws_secret_access_key=secret_key,
14 s3_staging_dir=staging,
15 region_name=region)