Analysis linked to a dataset does not reflect new columns added after dataset refresh

Q&A
, ,
1

Hi Team,

I am using a table from my datasource as a SPICE dataset in Quicksight and creating an analysis using the latter. With any change in the data source table structure (addition/removal of columns), the analysis does not show the added/modified columns after the dataset refresh, however the data within the existing columns is refreshed. Do I have to rebuild my analysis every time there is a change in the data table structure? Or is there a way to refresh the analysis as well?

Example, my current analysis sourced from Table T in the database has 5 columns, A, B, C, D & E. If in the database, I can go and add columns F & G to the Table T, after the refresh in Quicksight, the dataset shows these new columns but my analysis does not. It still displays A, B, C, D & E.

Thanks,
Kartik

2

Hi,

Please note whenever you change the in table structure you need to press “SAVE & PUBLISH”.

This option will refresh the data and update the backend structure change.

image
image934Ă—352 44.9 KB

Regards,
Naveed Ali

3

Thanks for the response Naveed! This should work.

4

Is there any way to do this automatically?

I have dozens of datasets in one of my accounts. Going in one by one and pressing save and publish on all of them is not a practical option.

Please let me know!

6

Same question than @mateoleon210 thanks.