Boolean Data Type in Schema

When importing data in a Schema, I've noticed there is no data type for boolean or bit available.  I know this is a  simple question but have not seen any documentation, questions, or other information this.  When loading data that has a bit column, the data type detected is set as string with values in {0,1}.  Should the data type be set to integer to allow for faster value comparisons or does that not matter in Incorta?  Or is a boolean data type available and I am missing something?

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Joe - Boolean datatype is not available so try and select INT as the datatype as it has a better load performance than string  and see if you get 0 or 1 values.

    • Amit Kothari INT works fine.  I assumed string comparisons were going to be slower which is why I asked.  Just a thought, but if a BIT data type from SQL comes across when creating Schema, perhaps set Incorta up to default to INT instead of STRING.  Not a big deal to change on my side obviously.  Thank you for your response.

    • Joe Steinbrunner  I agree.

Like Follow
  • Status Answered
  • 2 yrs agoLast active
  • 3Replies
  • 156Views
  • 2 Following

Product Announcement

A new community experience is coming! If you would like to have beta access to provide feedback, please contact us at community@incorta.com.