Why Calculated Fields missing/deleted after replacing dataset with another dataset of same Columns and values & Structure

[Giridhar.Prabhu]

Hi @Venkat.Metadata

I simulated your case. You are right, we are not able to remove the first table.

It may be because it is a csv? I haven’t done it in a while; but I have had cases where I had to make dataset changes that involved relational tables and I was able to remove them.

An alternative approach is to use CLI commands to update dataset properties

Changing Data Source for a Dataset

Hi @dan.kainz - It sounds like you could be looking for 1 of 2 things. If you need to update the DataSource connection properties you can follow the steps outlined here Editing a database data source. Updating the DataSource used by a DataSet. This is not currently possible in the UI. As a workaround, you can update the DataSet using the QuickSight API. The rough process; DescribeDataset a. Update the property DataSourceArn to your new DataSource Arn UpdateDataset

Personally, I haven’t tried the CLI approach. So if you are familar with CLI commands you may try this option and see if you could replace the Quality_CSV with Quality_Testing_S3 with the CLI command

Regards,
Giri