Running SQL in Jupyter - Nice one

You can run sql and than visualise using pandas and plot....

and it's sooo easy :

!pip install ipython-sql
import sqlalchemy
%load_ext sql
%sql redshift+psycopg2://usr:pass@redshift.amazonaws.com:5439/dwh
%%sql
select * from emp where city = 'Jerusalem'
result = _
df = result.DataFrame()
df.plot(x='user_email',y='sal')

and for Athena:

!pip install PyAthena[SQLAlchemy]
import sqlalchemy
%load_ext sql
region_name='us-east-1'
schema_name='g_calc'
s3_staging_dir='s3://****-****-us-east-1-g-test-data-2/athena/'

%sql awsathena+rest://:@athena.{region_name}.amazonaws.com:443/{schema_name}?s3_staging_dir={s3_staging_dir}

%%sql
select * from g_calc.g_tmp1 limit 100

df = _.DataFrame()

you can specify full credentials as detailed in:

https://pypi.org/project/pyathena/

for more details:

https://towardsdatascience.com/how-to-run-sql-queries-from-a-jupyter-notebook-aaa18e59e7bc