Renaming a field in a parent dataset breaks the child dataset

Question & Answer
, ,
1

This isn’t really a question but more like feedback for the QS team.

I found that renaming a field in a parent dataset breaks any child dataset that contains that field. Here’s a simple test to illustrate the issue:

  1. I have 2 parent datasets in SPICE - Parent Dataset 1 and Parent Dataset 2.

image
image702×360 17.8 KB

image
image719×366 19.5 KB

  1. I have a child dataset that joins the 2 parents.

image
image1134×413 24.3 KB

  1. I rename “Organization” to “Organization Name” in Parent Dataset 2.

image
image719×366 23.5 KB

  1. The next refresh of the child dataset fails because of the renamed field.

image
image1102×652 90.9 KB

For the refresh to work again, I have to open the child dataset and click on “Save and Publish”. This can be a big hassle when the same parent dataset is used in many child datasets. Isn’t the name in QuickSight just an alias? I feel like if the underlying database column is still the same, changing the alias shouldn’t affect the dataset.

2

@David_Wong : Glad you have highlighted this issue. We observed the same issue as well and looking forward a quick fix on this so that any change in child data set should have cascade effect to parents.

Regards - San

3

@Sanjeeb2022
Have you noticed that sometimes the renamed field also gets excluded from the child dataset? Before I save the child dataset again, I have to find the renamed field from the list of excluded fields and include it again. I have to do some more testing to see when it gets excluded and when it doesn’t but that has been my experience.

1 Like
4

@David_Wong : Good point, hopefully it will be fixed in down the line.

Regards - San

5

@Max - Need your advise on this please.

Regards - San

6

@SeanBoon @emilyzhu for visibility.

8

passing it to @Gil_Raviv