Hi Mina,
How can we leverage ELT pack of an Stored prod call, could you please elaborate.
Regards
Anubhav
Hi Anubhav,
I had tested calling a simple stored proc using Oracle Execute snap, it worked. So I’d think you could try Redshift Execute as well. It may fail when there is a result set returned. Also please check out the sample pipelines for Redshift Multi Execute snap which allows you to execute multiple Redshift SQL statements sequentially inside of a single BEGIN and END transaction for each input document. If none of the above meets your needs, I think you could try having the ELT snaps build the same code for you. When you run the ELT pipeline, you will see it generates the code and sends that code to the db. I’d suggest asking your CSM to enable the snap in your dev org and try it out. What do you think?
