Forum Discussion

amardeep2021's avatar
amardeep2021
New Contributor III
4 years ago

Issue while adding days to date field in mapper

Hi, I have a scenario where I am trying to increment a date field by 7 days in loop till it reaches another date value. I see data type as date for the field I am working, still while using plusDay...
davidm's avatar
davidm
New Contributor
6 years ago
Copy LinkReport

Please note, I’m going to JIRA Search snap. Using JQL, I am able to return json documents and bulk uploading them to Snowflake using Snowflake Bulk Upload. Format Type: JSON. The table we are loading contains only 1 column that is data type VARIANT.

Please note: I did try adding JSON Formatter and JSON Parser before loading it to Snowflake. It only worked for Snowflake Insert but instead of VARIANT (JSON) it was looking at JIRA as text.