Talend String data type not accepted as Variant Datatype in Snowflake using JDBCOutput component

[vidya821]

Hi Team,

I have used tJDBCOutput to load data in snowflake DB table with variant column, however i am getting below error

SQL compilation error:
Expression type does not match column data type, expecting VARIANT but got VARCHAR(1) for column <<column name>>

I have used the data type as String in Talend, please suggest

Note: I am using Talend Open source DI.

Thanks

[manodwhb]

@vidya821 , Variant data type would be sting in talend to read it.

please check the below link to know more.

https://help.talend.com/reader/XaAT0btTu0IT_DGcejilJQ/V~4JpyyHUjXFljNQ8N9zDw 

[vidya821]

Thanks @manodwhb , i have already stated that i am using String data type however i am usng JDBC connectors which is not working, but when i tried with snowflake connectors its working with String data type.

[manodwhb]

@vidya821 ,if you have support access please raise a case with Talend support team.