topic Re: Talend String data type not accepted as Variant Datatype in Snowflake using JDBCOutput component in Talend Studio

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

vidya821 — Mon, 16 Mar 2020 09:25:38 GMT

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

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

manodwhb — Mon, 16 Mar 2020 09:29:21 GMT

@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

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

vidya821 — Mon, 16 Mar 2020 09:51:39 GMT

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.

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

manodwhb — Mon, 16 Mar 2020 09:55:05 GMT

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