ContributionsMost RecentMost LikesSolutionsRe: Calling a Redshift Stored procedure in Snaplogic Hi Mina, How can we leverage ELT pack of an Stored prod call, could you please elaborate. Regards Anubhav Calling a Redshift Stored procedure in Snaplogic Hi All, Has anyone been able to call a redshift stored proc using Snaplogic, couple of items which I read on the community mentioned they were not able to do so and there is an enhancement request for the same. If anyone one has an idea regarding how to achieve this, please let me know in the comments. Thanks and Regards Anubhav Re: Joining hierarchical data well in that case you might have to write a script Re: Joining hierarchical data Hi Kiran, I have attached a pipeline to achieve this, hope this helps. result: AN new pipeline 1_2020_06_29.slp (8.2 KB) Regards Anubhav Re: Architecture: Pipeline Execution Mechanism - Some Questions Thanks for the detailed Explanation. 🙂 Re: Architecture: Pipeline Execution Mechanism - Some Questions Hi I have a query on this, if we have two Snaplexes in our org say Snaplex A and Snaplex B. I have a pipeline which calls a child pipeline, so if a parent pipline in running in one of the nodes of Snaplex A, could child pipeline run on a node of Plex B? or will it always run on a node of Plex A? Please note we are using pipe.plexpath in Snaplex property of PE snap Regards Anubhav Re: Router expressions - Need help! could you please attach the slp file having Json Generator, tried to copy the JSON but it fails while validating. Re: How to get path of a file Directory browser can list all your files from a particular location with the filepath Re: Load sql query data to csv file and send this file in email as an attachment Do you get any data when you validate the pipeline? or you dont get the output in validation too Re: Load sql query data to csv file and send this file in email as an attachment are you getting an error?, you have to write the file in sldb, also I believe the attachment size should be less than 25 MB, after your file writer snap use an email sender snap and set the attachment property to $filename, This should work fine. file writer output : email sender: Regards Anubhav