0Boolean 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?
-
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.
-
