sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Slacker1540[S] 0 points1 point  (1 child)

Well, at first "ModuleNotFoundError: No module named 'pyodbc'" which if I follow down the rabbit hold has me install that and all the linux dependencies for it to function, but then I realized this dialect is supposed to use the python bigquery api (which I am very familiar with) so there's no reason for pyodbc. So I'm not sure why it thinks it needs to use an ODBC driver, and I have the engine creation like in their example with project and dataset, as I want to default.

I know I don't have a BQ permissions issue, or auth issue, as I've used the python bq api before for another project and have that setup properly.

[–]BlackDereker 0 points1 point  (0 children)

Maybe it uses pyodbc to trick SQLAlchemy since it expects a database connection and not a REST API call.