[GitHub] [incubator-superset] semantiDan edited a comment on issue #7969: Not able to connect superset with BQ

[GitBox <gi...@apache.org>]

semantiDan edited a comment on issue #7969: Not able to connect superset with BQ
URL: https://github.com/apache/incubator-superset/issues/7969#issuecomment-517965761
 
 
   Superset uses [SQLAlchemy ](https://www.sqlalchemy.org/) to manage database connections.
   
   Currently, SQLAlchemy does not have an official dialect for BigQuery :(
   
   If SQLAlchemy had a dialect and connector for BigQuery, it would have worked seamlessly for you as you expect it.
   
   In order to make it work you need to either write a dialect and connector for BigQuery in SQLAlchemy by yourself or use an existing solution and integrate it.
   
   Here is an existing solution (I haven't used it yet):
   https://github.com/mxmzdlv/pybigquery
   
   Then integrate the dialect into your SQLAlchemy module which according to your screenshot should be in the following folder:
   `/usr/local/lib/pythong3.6/site-packages/sqlalchemy/dialect/`
   
   You would also need to create a connector for BigQuery. You can see existing samples or follow the[ SQLAlchemy repository](https://github.com/sqlalchemy) or [documentation ](https://docs.sqlalchemy.org/en/13/contents.html) for more information.
   
   Hope this helps!
   
   
   
   
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org