This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am using an ODBC Connection to connect with Redshift to load the data from Salesforce via Salesforce connector. While running the module it fails to create the table and gives the error that certain column has unsupported type "bit", though the data type for that column is "Boolean". Anybody facing the same kind of issue, please suggest the solution.
I am using the AWS Driver v18.104.22.1681 (64 bit). I tried to load the data by converting the boolean fields to string type, it gave me the error "String data is too big for the driver's buffer size". Also, I tried to change the boolean fields to Integer type, still got the same error.