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.
Hi @Mark_Smith ,
The above is not working, as it is giving Authentication plugin ‘mongosql_auth’ is not supported
def main(): import mysql.connector try: connection = mysql.connector.connect(user='readonly', password='myreads', host='Mongo Bi host', port='3307', database='insightsdb', auth_plugin='mongosql_auth') cursor = connection.cursor() query = "SELECT * from global_and_us limit 20" cursor.execute(query) for i in cursor: print(i) cursor.close() connection.close() except Exception as e: print(e)
Can you please help?