mirror of
https://github.com/status-im/sqlalchemy_dremio.git
synced 2026-08-31 05:01:15 +00:00
* Add routing_engine to the set of accepted properties. * Make connection options case-insensitive for keys. * Correct the example URI to use ? before query parameters instead of ;
12 lines
306 B
Python
12 lines
306 B
Python
from sqlalchemy import create_engine
|
|
import time
|
|
|
|
|
|
db_uri = "dremio+flight://dremio:dremio123@localhost:32010/dremio?UseEncryption=false"
|
|
engine = create_engine(db_uri)
|
|
sql = 'SELECT * FROM sys.options limit 5 -- SQL Alchemy Flight Test '
|
|
|
|
result = engine.execute(sql)
|
|
|
|
for row in result:
|
|
print(row[0]) |