ipython-sql icon indicating copy to clipboard operation
ipython-sql copied to clipboard

Refreshable credentials for Aurora (PostgreSQL-compatible) with IAM

Open zzFluke opened this issue 3 years ago • 1 comments

Hello, first of all many thanks for this awesome extension!

I'm making a prototype using it and stumbled upon one problem that I haven't solved yet. Can somebody point me at the right place in documentation how I can configure sql magic to work with refreshable credentials. I want to use ipython-sql on AWS to connect to Aurora (PostgreSQL-compatible) using dynamic-temporary credentials which are valid for 15 mins since granted.

I've found that SQLAlchemy has a recommended way to do this - Generating Dynamic Authentication Tokens, but I'm not sure how I can configure ipython-sql to do that or access SQLAlchemy engine to register a hook.

I appreciate any help in advance!

zzFluke avatar Sep 22 '21 16:09 zzFluke

Looks like engine access request has been raised previously in #199. Curious about the timeline and/or available workarounds.

zzFluke avatar Sep 24 '21 11:09 zzFluke