Fischerd
New Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Viewing SQL generated by a Snap
Is there a way I can view the exact SQL that is generated by a pipeline? I am debugging a pipeline that uses the Oracle - Execute snap. The results from the generated SQL are not what I am expected and I would like to be able to see what statement is being run, so I can fix my mistakes Thank you in advance Dan2.1KViews0likes1CommentSQL Server Stored Procedure Snap hangs when returning data
Hello, I’m working with a Stored Procedure that has no input variables and returns about 4800 rows of data. When I build out my pipeline and validate, the procedure returns the first 50 rows successfully (as expected). However, when I go for an actual execution the pipeline hangs on that particular snap. Given that my pipeline works when validating, I don’t think there is a connectivity issue. I don’t know if there is some action I need to take in order to handle larger data sets? Any information or insight here would be very helpful Thank you Dan Edit: Here is a screen shot of the pipeline execution in the dashboard. It will hang at exactly 1024 docs each time6KViews0likes9CommentsDate Validation using Expression Library
Hi, I’m developing a pipeline that uses date input parameters. I was looking to use an expression library to validate the date format by matching a regex pattern. For example, /^([1-9]|0[1-9]|1[012])/(0[1-9]|[12][0-9]|3[01])/(19\d\d|20\d\d)$/.test(“05/09/2018”) should return ‘true’ Below are the pipeline properties where I am importing the expression library: Here are the contents of the .expr file: { sd_valid: x => (/^([1-9]|0[1-9]|1[012])/(0[1-9]|[12][0-9]|3[01])/(19\d\d|20\d\d)$/.test(x)) } Here is the mapper I am trying to you to call the validation: I am receiving the following error when trying to validate the pipeline in this case: “Failure: RegExp type does not have a method named: test. Perhaps you meant: No Regex Methods, Reason: ‘test’ was not found while evaluating the sub-expression ‘/^([1-9]|0[1-9]|1[012])\/(0[1-9]|[12][0-9]|3[01])\/(19\d\d|20\d\d)$/.test(x)’, Resolution: You can check for the existence of a field with the ‘in’ operator (e.g. ‘abc’ in $obj)” Has anyone else seen this problem and found a solution? Or know a better way to accomplish what I’m trying to do here? Thank you in advance Dan7.1KViews0likes7Comments