This topic was automatically generated from Slack. You can find the original thread here.
Hi there. I’m struggling a bit with this. From within a Python step, I would like to send data to a remote MariaDB. I tried using the mariadb module in Python, but I think that’s not the intended way on how to do it in Pipedream. I think the way to go is to add a MySQL connection/app to the step and use it to execute queries to the DB. And here I’m failing. How do I call that connection? I asked Pi but the answer is confusing me (most probably because of a lack of knowledge . Can someone maybe share an example of a simple implementation on how to execute a query from within a python step? I would highly appreciate it. Thanks in advance and best regards, Stefan
Hi . Thanks for your feedback. Now knowing that I did the right thing, I come up with a follow-up question. I assume the correct module to use for MySQL/MariaDB within python would be import mysql.connector or import mariadb Unfortunately, this throws both of them are throwing an exception which seems to be a missing driver. Could there be an issue with the MySQL module?
The connection I’m trying is db_conn = mysql.connector.connect(pd.inputs['mysql']['$auth'])
. Can someone maybe share an example of a simple implementation on how to execute a query from within a python step? I would highly appreciate it. Thanks in advance and best regards, Stefan
:skin-tone-2: