Hello - first post, set up Metabase this weekend on Elastic Beanstalk and everything is working great. Love it so far.
I’m wondering if there’s any way to use Python as a source for a chart in Metabase? Idea being I would have my SQL query embedded in Python so I could get the data, do some manipulations / math / forecasting, etc., in Python, and then pass the dataframe to Metabase for visualization.
Wondering if it’s somehow possible to have the python in Metabase, or if anyone else has developed a way possibly where you have your python script outside of Metabase that passes the dataframe to it?
Any help or thoughts would be greatly appreciated!
You would need to create an interface that Metabase can connect to. Current supported databases are:
Otherwise you would need to create your own custom driver.
Thanks @flamber. I guess what I could do is set up is set up a server somewhere that stores a python script that saves to a database, and have Metabase hit that database.
Question: I can SSH into my EC2 instance that’s running Metabase - would you recommend against hosting some python scripts, a database, and maybe even a Jupyter container on this EC2 instance? Just to save me from having to spin up another instance, and so it’s all in one place? I don’t know how updating Metabase works technically and if it just like wipes everything on the server when it updates.
@jbrooks Running on EC2 doesn’t tell me anything. But make sure that you’re not using H2 for the application database:
Just like with any other piece of software - you can run them all in the same environment, or separate them in containers or different hosts - that depends on how you prefer to run things.