mina
Employee
Joined 9 years ago
User Profile
User Widgets
Contributions
Re: Calling a Redshift Stored procedure in Snaplogic
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?3.1KViews0likes0CommentsRe: How to make a generic pipeline Oracle => SQL Server
Awesome. For the Timestamp issue, I found the answer in SQLServer Insert snap doc. It called out: TIMESTAMP datatype in SQL Server is not supported. According to the Microsoft official document, "The timestamp syntax is deprecated.1.4KViews0likes2CommentsRe: How to make a generic pipeline Oracle => SQL Server
You are welcome, Christophe. On the Select snap>Views>add a 2nd output view and connect it with the 2nd input view of the Insert snap. That will create the target table using source datatypes. I haven’t tested SqlServer but it should work. The Execute snap does not expose source ddl as an output. In that case, you could try a Structure or Mapper snap prior to the insert (mapping just one column passing the rest) but you may need to check the data types you got in the target. That’s my 2 cents and I hope more people will share their experiences.3.1KViews0likes0Comments