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 AnubhavUnable to execute Redshift Script with comments in it using Redshift Execute
Hi All, I am using redshift execute to run a redshift script . While I am able to run the script when every redshift query is enclosed in double quote, but the script is failing when I am adding comments to that. Would like to know how to write comment in redshift script so that it can be acceptable in “Redshift Execute”.Redshift Unload Directly to Parquet
Hi, Has anyone figured out a way to Unload data directly to parquet format from Redshift? The Redshift Unload snap does not have parquet format as an option (just delimited and fixed width files). I have tried to circumvent this by using a Redshift Execute snap and then writing an unload command. The process seems to work on a limited data set but I get an error at the end of the Unload like this (data in brackets redacted from actual values): ERROR: Mismatch in returned vs expected bucket in CompleteMultipartUpload. Expected: returned: [my-bucket-name-only]. Mismatch in returned vs expected key in CompleteMultipartUpload. Expected: [my-bucket-name]/[mypath]/[my-prefix] The path I entered into the redshift unload command was: [my-bucket-name]/[mypath]/[my-prefix]
Redshift and SnapLogic
We are trying to stand up a new Redshift environment and want to be able to connect and run pipelines with SnapLogic. Corporate security rules require us to launch the Redshift cluster in a private subnet, no NAT or Internet Gateway, all access through firewall rules. Do we absolutely have to use a Groundplex, can we do it in a cloudplex? If we have to use a Groundplex, can we use an existing Groundplex already running in our SnapLogic account? Thanks!
Unable to execute stored procedure (Redshift) using Redshift Execute
SQL: CALL get_result_set(1, ‘mycursor’); FETCH ALL FROM mycursor; Failure: SQL operation failed, Reason: A result was returned when none was expected., error code: 0, SQL state: 0100E, Resolution: Please check for valid Snap properties and input data.