I am importing a table from the DB into QuickSight (using the RDS import method). It imports successfully. In the DB, I can see, for example, the id 3853 has status (a col in the table of tinyint type) = 5.
However, when I look at that table in QuickSight, I notice that all the rows with status > 1 have their status value converted to 1. The status col in QS has integer type though I’ve converted to other numerical data types and experience the same issue.
See relevant screenshots attached. Can you please let me know why this would be happening and how I can resolve it? Thanks - any help is appreciated.
The tinytint consider as boolean in data synching. That’s why its value is “1”, it’s set 1 for all the values greater than “0” and consider “0” as zero.
How you can fix it, you need to change Tinytint to smallest/int in your DB.
This will fix it.
It’s fine, I can change the data type from tinyint to int. However, i’d rather QS not implicitly convert what is obviously and explicitly a numerical column to a boolean. Please make modifications that don’t do this implicit conversion.
