Reltio Integration Hub

Hi Team,
In our project, we are loading data from snowflake tables into Reltio. We are receiving complex json data in some of the columns.
We have flatten the json column and able to get the proper result in snowflake but when we use the same query in RIH, we are getting below error because in query we are using ":" to flatten json data which is casuing issue.

Error :
SQL:  Bind variable "Name" is either missing or does not have a value in input field

Sample Query Used:
select id,
b.value:Name as Name from table a,
lateral flatten(input => try_parse_json(a.jsonArray)) b

Can you please let us how to resolve the issue or another way to run the custom SQL without error?
Note: When we use the same query to generate the output schema in RIH, output schema got generated successfully.

Issue is Resolved. Solution is instead of b.value:name , use b.value['name']

Hi Team,
In our project, we are loading data from snowflake tables into Reltio. We are receiving complex json data in some of the columns.
We have flatten the json column and able to get the proper result in snowflake but when we use the same query in RIH, we are getting below error because in query we are using ":" to flatten json data which is casuing issue.

Error :
SQL:  Bind variable "Name" is either missing or does not have a value in input field

Sample Query Used:
select id,
b.value:Name as Name from table a,
lateral flatten(input => try_parse_json(a.jsonArray)) b

Can you please let us how to resolve the issue or another way to run the custom SQL without error?
Note: When we use the same query to generate the output schema in RIH, output schema got generated successfully.