How to automate athena queries from S3 With Python and Boto3?

[shan_chandra · Accepted solution]

Please run the below steps in an isolated notebook  to connect to Athena

1. Install boto3 

%sh pip install boto3 

2. check if boto3 library is installed 

%python
import boto3
boto3.__version__

3. Run the below code 

%python 
import boto3
client = boto3.client('athena')