I want to parse the JSON in snowflake database, can you please provide the steps and code? 

how to use javascript in transactional messaging templates and how to provide the data in seed address for a dynamic transactional message? 

When I put the date in the mm/dd/yyyy in the data type text its working properly but when I reupload the later date type yyyy-mm-dd its throwing the error as "The field 'Month' with value '2023-07-11' in '2023-07-11' is too long. Maximum of 2 characters." Why am I getting this error?