Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Cannot find Is_Json_Valid function in Calculator Component

Hi,

I am unable to find the IS_VALID_JSON function ( https://docs.aws.amazon.com/redshift/latest/dg/IS_VALID_JSON.html ) in the Calculator Component of Matillion for Redshift. Where can I find this function?

5 Community Answers

Matillion Agent  

Laura Malins —

HI Vijay

You’re correct that function is missing from the documentation in the Calculator Component. I will raise a request to have it added. However you are still about to use this function within a Calculator. You can also use it in a SQL component.

Thanks
Laura


Vijay Reddy —

Hi Laura,

Under JSON functions I cannot this particular function. Can you please post a screenshot of where I can find this?

-Vijay


Vijay Reddy —

I cannot post the screenshot my side here. Is there a way to send you the screenshot?


Matillion Agent  

Laura Malins —

Hi Vijay

Sorry I wasn’t clear. The function isn’t listed in the Calculator component but you can still manually type it in.

Thanks
Laura


Vijay Reddy —

Thanks! I am able to use it

Post Your Community Answer

To add an answer please login