Boolean for Aurora PostgreSQL Data

Question & Answer
, , ,
1

Hello All,

If I have researched correctly, it is currently not possible to use Boolean fields for data that is used from an Aurora PostgreSQL. Should this change in the near future?

Best Regards,
Michael

2

@MSC ,

If I understand correctly, you are looking at “True” or “False” values. QuickSight as today promotes them to integers and this is similar for other datasources (I tested on PostgreSQL , Athena ) ( Supported data types and values - Amazon QuickSight ) . I don’t know if this will change, but if you are looking at having “True” or “False” , you can create a calculated field ( How to create Boolean calculated field - #4 by Sanjeeb2022 )

Kind regards,
Koushik

1 Like
3

@Koushik_Muthanna

Many thanks for the feedback and the suggested solution.
Of course I can use the workaround and insert a calculated field as a string. However, in my input from my Aurora database that would be over 30 calculated fields that I would have to create. In addition, the advantage of boolean values would have been that they automatically adapt to the user language.

Best regards,
Michael

4

Thanks for providing additional details. I will tag this question as a feature request.

Kind regards,
Koushik