Salesforce object with value True and False is creating as Bit data type

why the Salesforce object with value True and False is creating as Bit data type as default instead of boolean , which is causing the issue while creating theĀ  snowflake targetĀ  object.

Beginner Asked on December 17, 2020 in Diyotta Admin.
Add Comment
1 Answer(s)

The salesforce database itself is having bit datatype, as part of import in Diyotta, it is coming as a bit.

The DDL which you have provided is from the Diyotta data object which will have a bit anyway. In salesforce, we create a column with a checkbox data type which will accommodate both true and false data in it. It creates a bit of datatype when we try to import the table in Diyotta.

 

In order to map all the bit columns in salesforce map to Boolean in snowflake target follow the below approach.

Login to the admin module and traverse to the Datatype mapping option/tab.

RE: Salesforce object with value True and False is creating as Bit data type

Then select the source database as Salesforce, and [target] Map to would be snowflake by default. In the dropdown select the Boolean datatype in snowflake target to map the bit datatype in salesforce source.

RE: Salesforce object with value True and False is creating as Bit data type

This is how it looks to post the changes done and then save it.

RE: Salesforce object with value True and False is creating as Bit data type

Expert Answered on December 22, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.