I am trying to insert data using dynamic insert option in DB connector operation.
I am using custom DB connection for SNOWFLAKE DATABASE with all jar files placed in my atom userlib folder.
I unable to insert the data using DB connector.
But when I use program command shape it is working fine and the data is getting inserted.
The field names are having spaces(Ex: Document Type) in between and when I run the process, It is throwing error at the field containing space.
I was unable to figure out what is causing error.
Could anyone help where am I going wrong.
Thanks in advance.