This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi there
I’m pulling a date time value from SQL Server which is brought into Snaplogic as an local date time object like so
{_snaptype_localdatetime:2019-11-13T06:04:41.424}
this happens to be New York eastern time zone
I want to now convert this to ...
Hi All,
When I am using the Snaplogic Netsuite Snaps facing below issue:
The Snaplex nodes have reached their resource limits and have no more room to execute pipelines. Please try again later or stop some executing pipelines to free up resources. (D...
I’m getting data out of a REST call and I need to check whether or not a certain entry is present or missing. My list of needed entries consists of, example: String1, String2, String3, String4. If only the the first three are present, how do I print ...
I am suddenly unable to write a file on my groundplex; has anyone see this before? Just a straight write, e.g., “file:///Users/rwhite/Development/test.json”. Oddly, I can read that exact file and location. The error I get follows as well some groundp...
I would like to set date format and timestamp format for the session and run the select statement in oracle execute snap like this
Begin
execute immediate ‘alter session set nls_date_format=’‘MM/DD/YYYY’‘’;
execute immediate ‘alter session set nls_ti...
We’re starting a project to move dozens of Oracle warehouse dimension tables to ADLS, and are using parent/child pipelines to pass table names. The pipelines correctly pass and resolve the table name to operate on. The child pipeline uses Oracle E...
I have a child pipeline called from Pipeline Execute which is passing partition name as pipeline parameter
to Oracle-Execute snap
Oracle-Execute has a sql =>
“select * from obia1.sales_invoice_lines partition (” + _partName + “) where rownum < 11”
th...
