Issue with the "Flatten Variant" component: Invalid argument types for function 'GET': (VARCHAR(2000), VARCHAR(8))

Matillion ETL
1

I have run into an issue with the "Flatten Variant" Transform component

Error in the logs:

Invalid argument types for function 'GET': (VARCHAR(2000), VARCHAR(8)).

 

0694G00000Gx10GQAR_0D54G00007zHgyJSAS
0694G00000Gx10GQAR_0D54G00007zHgyJSAS1029×823 39.5 KB

 

SQL Generated:

SELECT 

“FLATTEN_VARIANT_INPUT”.“workerJson”:“workerID”::variant as “workerID”

FROM 

“$T{STAGE_WORKER_20211014_101000}” “FLATTEN_VARIANT_INPUT”

2

The reason for this error was due to the column not being of type "Variant". The fix for this is to use a Calculator component in front of things and the PARSE_JSON function to put things into Variant which can then be digested by the Flatten Variant component.