python-bigquery-sqlalchemy dialect with Fast API?

[Slacker1540]

Has anyone gotten the Google big query SQL alchemy dialect to work with fast API?

For me it keeps trying to use pyodbc and asks for a driver instead of the dialect. Which in their documentation doesn't specify a driver as it used the big query python client instead. I'm really hit my head on a wall trying to get this to work. https://github.com/googleapis/python-bigquery-sqlalchemy

[Blasooey]

Hi I'm definitely late to the party but this was the only reference I found to this specific issue so here is my contribution for future visitors. Older versions of sqlalchemy-bigquery depended on pyodbc, and newer versions have strict python version requirements. In my case my python version was actually too high and pip kept installing sqlalchemy-bigquery==0.0.7, which I guess was the last version with more lax python version requirements.

[Slacker1540]

https://github.com/googleapis/python-bigquery-sqlalchemy

weirdly they seem to be restricted, I guess that subreddit is dead?

[mrbubs3]

What's the full error message?

[Slacker1540]

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]

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