Is there a way to use Python as a middle layer between the database and Zoho Analytics?
So my company has been using Zoho for everything now for a while.
We have a database connected to Zoho Analytics and I always use the query editor to write sql to join tables, do aggregations, or any necessary steps to prepare the data for analysis and visualizations.
Sometimes there is more complicated operations to be done that SQL alone wouldn't help with.
Is there a way to write Python code and do data manipulations with Pandas in the Zoho Environment just like the sql editor? If there is no way, has anyone figured a workaround?
Thank you.