Is there a way to use BI connector inside the python program to write SQL queries… Just curious.
Hi @Prem_Singh - that’s a great question - and the answer is yes. The BI connector emulates a MySQL server, but on top of MongoDB, so you can use any compatible MySQL driver for Python to connect to your data from Python. Here’s an example I wrote for connecting to our open COVID-19 data set.
Let me know if you have any problems.