Hi all, I would want to update a schema in the dataset (REDSHIFT, database view as source) , since QuickSight doesn’t provide a UI screen for this, I am using the Update Dataset API. I was able to update the schema but I am loosing all other changes like renamed columns, folders created, calculated columns. I have tried below steps ;
- describe dataset , extract only the physical-table -map section from the JSON and save as a new JSON.
- update the schema details in physical-table-map JSON
- Execute Update dataset command with newly created JSON as parameter to this command.
As described, schema is changing in the dataset but other changes are lost.
Please let me know the detailed steps to solve this.