Loading data from Salesforce(Incremental load) to Snowflake

[nabeelaslam1994]

Hello Support Team,

I am getting an error on a table. When I load it as full load only, it loads completely but when I try to enable CDC( store and apply changes), it is giving the following error. I am using BULK API for full load and SOAP API for CDC method.

Unload data handler failed
Failed to create value, table <.User> column: <Email>
Failed to parse, expecting WSTR, but got 1-BYTE POSITIVE INTEGER

Any other column datatype i can use for it?

Thank you

[nabeelaslam1994 · Accepted solution]

I changed the CDC Method to BULK API and the table was loaded without any issue.

Nabeel