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.
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.
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.
This is how it looks to post the changes done and then save it.