Data360 Analyze

Hello.

I'm trying to insert data to a table in snowflake and I'm getting the following error:

Unexpected error occurred during processAll while running the node: java.lang.IllegalArgumentException: Field "REPORTING_MONTH" already exists in metadata.

the data has 4 columns with different names one of them being "REPORTING_MONTH". Already tried deleting the table and creating again but is not working. Any help would be really appreciate it

I haven't been able to duplicate this issue with the JDBC Store node connecting to Snowflake. In general, the "IllegalArgumentException" error with a reason "Field X already exists in metadata" means that the field specified was already in the node's output pin and couldn't be added again. This error stems from the node itself rather than Snowflake. Usually this is seen with nodes like the Create Data note with duplicate columns.

The only output that the JDBC Store makes by default is a list of the records that errored during the database insert. There's an optional LoadedData property too, which also lists the successful records. I've tried both of these output pins and wasn't able to get that error message.

I created a support ticket so that we can get logs to look at this deeper. Our team will be in contact with you on that ticket shortly.