I am creating a Quicksight dashboard that references a postgres table I recently added a connection to. Although I can see all of the columns when I go to “edit data”, the timeSpentOnPhone column is missing when I actually try to work with the dataset. I am not sure why it would be different between those two locations and it is set to direct query. The data type for the column is decimal.
Here is a comparison of what I can see in my analysis vs what is actually there when I use pgadmin:
There are no fields excluded. I have run into this issue for other tables / columns since I originally posted this question.
One detail to mention, the columns I have had issues with were not part of the original schema for these tables and were added in a later migration. Would this matter for the analysis?
Hi @RoboK,
You will need to republish the dataset from the dataset editor screen (The field should show automatically in the editor screen). Once the dataset has been published, the field will show in the Analysis.
Thank you.
Hello @Asem, is there a corresponding API command in AWS SDK v3? I.e. the possibility to perform that republishing programmatically instead of manually…
There’s UpdateDataSetCommand but this one requires to indicate a PhysicalTableMap, which is why I doubt it’s the equivalent of clicking “Save & Publish” for a dataset in QuickSight UI…
