In a mapper, we need to convert all keys of a JSON file at every level to lowercase. Example:{"Id":"600b31dadece310027cdf492","User":{"Id":"5cbf7330263cd09f9445bd90","displayName":"coyote","impersonatedBy":"ldap:123456"}}In this case, we would want t...
Greetings.I'm attempting to perform some operations against a MySQL 8.0.33 server. I created a SnapLogic MySQL database account, and uploaded mysql-connector-j-8.0.33.jar to the JDBC driver property of the account configuration popup. Pressing the v...
How can I trim the date on the left hand side and convert this into a date value?Input Example: 18 May 2016 - 17 Mar 2017Output example: 2016-05-18(using the yyyy-MM-dd format)I've tried using trimLeft() function but the Mapper Snap doesn't recognis...
Hello,I have designed this pipeline that:Generate a month range as $date_1 and $date_2These variables are inserted into a SQL statement in the "Snowflake - Execute" pipeThen this is inserted into SSMSI want the filled SQL statement with the variables...
Hi Community,We are observing the below error in one of our pipelines and would like to know more about this error"TIMED_WAITING on java.util.concurrent.CountDownLatch$Sync@53b449dc at java.base@11.0.10/jdk.internal.misc.Unsafe.park(Native Method)"Ha...
Hello, I am using the Multi file Reader Snap to copy the files from a SFTP source location and write into a Storage blob container.The process is to run every 30 mins to pick any file(s) that are available and write into a storage blob. There could ...
Hi team, I am facing issue while splitting file based on 100mb size. In my case, i have 10 million records of data. i am using sl.range() function along with map() function.For example, if a line consists of 3mb data and i want to split based on 6kb....
Hi team,I m new to snaplogic and I want to split large fil into smaller files and zip them together. Any suggestions and explanations would be helpful.
