Has anyone successfully scheduled a transform that executes Stored Procedures in Postgres?
I’ve made it work with Postgres Functions but problem then is that a function runs in a single transaction. Problem is that I need to run 3 SPs in the correct order AND commit between. I can’t do that using a function as no transaction control. In Metabase, the code works until I try to run it as a job.
Hmmm, this is tricky and I don’t know if we’re going to support SP’s at any point in time… what about a python runner that executes the SP?
python runner in transforms I mean…
Open Source edition doesn’t provide python runners.
My workaround is to use a PG function that just returns a scalar. Works well enough except for having to do it all in 1 transaction. Bigger problem is the time it takes blocking all the alerts. That’s in another thread.