Magic sql with dremio dialect?

Hi there,
I’d like to use magic sql, %%sql, in a jupyter notebook. See Jupyter Magics with SQL. Jupyter/IPython notebooks can be used… | by Sayat Satybaldiyev | Towards Data Science

I cannot get it to work with dremio’s sqlalchemy dialect: dremio+flight… It doesn’t seem to be compatible with ipython-sql.
Are there any dialects I can use instead of dremio+flight? Or are there any workaround?

Hello!!
I made it work installing sqlalchemy_dremio python library and then
*"SERVER=“HOST:PORT”
DRIVER=“Arrow Flight SQL ODBC Driver”
DATABASE=“DB”
USERNAME=“username”
PASSWORD=“pwd”
DB_CONNECTION=f’dremio+flight://{USERNAME}:{PASSWORD}@{SERVER}/{DATABASE}?driver={DRIVER}&useEncryption=false’

SQL_QUERY= 'select statement '*
engine = create_engine(DB_CONNECTION)
connection=engine.connect()
pd.read_sql_query(SQL_QUERY,connection)
"
However I would also like to use magics (%%sql) and couldn´t make it work yet
Please let me know if you figure it out

I found this url GitHub - narendrans/sqlalchemy_dremio: SQLAlchemy for Dremio via the ODBC and Flight interface.
And tested this in jupyterlab notebook
%%sql
dremio+flight://user:password@host:port/mydb
/ run SQL /
select * from myquery

It raises
AttributeError: ‘DremioDialect_flight’ object has no attribute ‘driver’
Error