a month ago
Hi 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(Reltio Integration Hub), we are getting below error.I guess in query we are using ":" to flatten json data which is causing 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 if anyone has come across the issue and any suggestion is appreciated
Note: When we use the same query to generate the output schema in RIH, output schema got generated successfully.
Solved! Go to Solution.
4 weeks ago
This is resolved. Need to use b.value['Name'] in custom sql instead of b.value:Name
4 weeks ago
This is resolved. Need to use b.value['Name'] in custom sql instead of b.value:Name