ipython-sql: How to connect hive/presto with connect_args?

Question

Note: I posted the question at https://github.com/catherinedevlin/ipython-sql/issues/149

I can connect hive/presto using create_engine like this

from sqlalchemy.engine import create_engine
conn = create_engine(
    'presto://user@host:port',
    connect_args={'protocol': 'https',
                  'requests_kwargs': {
    'auth': HTTPBasicAuth('user', 'pw'),
    'verify': '/cert.pem',
    }}
)
df = pd.read_sql("SELECT * FROM dw.my_table", conn)

However, if I use ipython-sql, how should I connect?

From the doc, it seems only support string passed to create_engine, something like this

%%sql postgresql://will:longliveliz@localhost/shakes
select * from character
where abbrev = 'ALICE

How can I specify additional configs in connect_args?

score 0 · Answer 1 · answered Jan 19 '23 at 15:50

ipython-sql does not support this, as it expects a connection string. However, you can use JupySQL (an actively maintained fork that keeps 100% compatibility).

You can do something like this:

%%sql conn
select * from character
where abbrev = 'ALICE

Documentation

ipython-sql: How to connect hive/presto with connect_args?

1 Answers1