Member since
09-23-2022
5
Posts
0
Kudos Received
0
Solutions
11-12-2025
07:22 PM
I am trying to read a json field from mySQL using executeSQLRecord and insert into snowflake VARIANT field type using PutDataBaseRecord in NiFi 2.6.0. its giving me this error " 03:20:05 UTC ERROR 1695731e-9b6f-3cb8-5a9a-98ab38589597 PutDatabaseRecord[id=1695731e-9b6f-3cb8-5a9a-98ab38589597] Failed to put Records to database for FlowFile[filename=c6087904-71a5-479c-9301-2c99883f5f59]. Routing to failure.: net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error: Expression type does not match column data type, expecting VARIANT but got VARCHAR(2) for column JSON_STORE " how do I fix this?
... View more
Labels:
- Labels:
-
Apache NiFi