# Renaming Virtual Dataset causes issues when trying to edit SQL

**URL:** <https://community.dremio.com/t/renaming-virtual-dataset-causes-issues-when-trying-to-edit-sql/1255>\
**Category:** Uncategorized\
**Created:** [June 6, 2018, 4:04pm UTC](https://community.dremio.com/t/renaming-virtual-dataset-causes-issues-when-trying-to-edit-sql/1255 "2018-06-06T16:04:41Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alex\_Hancock](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/alex_hancock/32/661_2.png) [@Alex\_Hancock](https://community.dremio.com/u/Alex_Hancock)\
**Post date:** [June 6, 2018, 4:04pm UTC](https://community.dremio.com/t/renaming-virtual-dataset-causes-issues-when-trying-to-edit-sql/1255/1 "2018-06-06T16:04:41Z")

</div>

After renaming a virtual data set, i get an issue when trying to view the SQL code - it looks like the old name is baked into the version history.

dataset “[Folder]”.[OLD NAME] version 0002503999415957 at [/dataset/"[Folder]".[OLD\_NAME]/version/0002503999415957] not found

---

<div class="post-metadata">

**Author:** ![christy](https://avatars.discourse-cdn.com/v4/letter/c/e68b1a/32.png) [@christy](https://community.dremio.com/u/christy)\
**Post date:** [June 6, 2018, 4:33pm UTC](https://community.dremio.com/t/renaming-virtual-dataset-causes-issues-when-trying-to-edit-sql/1255/2 "2018-06-06T16:33:26Z")

</div>

I believe this is the same issue as:

> [@Find original SQL statement after dataset moved](https://community.dremio.com/t/find-original-sql-statement-after-dataset-moved/1253/3):
>
> Yes, I clicked that. Then I got error message shown above.

---

<div class="post-metadata">

**Author:** ![mcotter](https://avatars.discourse-cdn.com/v4/letter/m/7993a0/32.png) [@mcotter](https://community.dremio.com/u/mcotter)\
**Post date:** [April 15, 2020, 6:01pm UTC](https://community.dremio.com/t/renaming-virtual-dataset-causes-issues-when-trying-to-edit-sql/1255/3 "2020-04-15T18:01:37Z")

</div>

We are on version 4.1.0. Does anyone know when this issue will be resolved?

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [April 16, 2020, 10:28pm UTC](https://community.dremio.com/t/renaming-virtual-dataset-causes-issues-when-trying-to-edit-sql/1255/4 "2020-04-16T22:28:55Z")

</div>

@mcotter  
Are you hitting this error in the current version too?

---

<div class="post-metadata">

**Author:** ![mcotter](https://avatars.discourse-cdn.com/v4/letter/m/7993a0/32.png) [@mcotter](https://community.dremio.com/u/mcotter)\
**Post date:** [May 26, 2020, 3:01pm UTC](https://community.dremio.com/t/renaming-virtual-dataset-causes-issues-when-trying-to-edit-sql/1255/5 "2020-05-26T15:01:10Z")

</div>

Yes. we just tested on Dremio 4.3.1. Issue still exists

---

<div class="post-metadata">

**Author:** ![doron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/doron/32/294_2.png) [@doron](https://community.dremio.com/u/doron)\
**Post date:** [May 26, 2020, 3:33pm UTC](https://community.dremio.com/t/renaming-virtual-dataset-causes-issues-when-trying-to-edit-sql/1255/6 "2020-05-26T15:33:34Z")

</div>

Can you provide reproduction steps please.

---

<div class="post-metadata">

**Author:** ![mcotter](https://avatars.discourse-cdn.com/v4/letter/m/7993a0/32.png) [@mcotter](https://community.dremio.com/u/mcotter)\
**Post date:** [May 26, 2020, 7:41pm UTC](https://community.dremio.com/t/renaming-virtual-dataset-causes-issues-when-trying-to-edit-sql/1255/7 "2020-05-26T19:41:22Z")

</div>

We just applied update 4.3.1. This issue has been resolved. There are now two options…Make a copy or Rename. I was hoping the renaming process would update the dependent datasets with the new name…It does not. In summary, renaming disconnects (invalidate) all dependent datasets.

Prior to the fix, renaming the VDS made the VDS invalid
