Rename snowddl user role

[y-tee]

Is there a way to rename snowddl user role while keeping all the objects that it created intact (without recreating all of them)

In the case where there is no way to just rename the role name, how would you foresee the impact to the underlying objects after they are destroyed and rerun again

[littleK0i]

Renaming is a difficult problem for pure declarative tools without state. The only "clean" soultion would be introduction of internal unique ID of some sort, which is going to complicate other things.

Similar to renaming of other objects, the best approach right now is to maintain SQL files with small "imperative-style" changes which cannot be handled declaratively. These files should be applied manually before deployment, and you may include any commands there.

Beside renaming, another common use-case is data type conversions and data updates. For example, you have a table with one string column, but you need to make two integer columns out of it using some fancy expression. Currently it is not possible to handle such transformations in declarative fashion.

And if we must have small SQL files, we may as well add renames there.

[littleK0i]

Dropping a role does not drop all objects owned by this role. As far as I know, all "owned" objects are re-assigned to another role (e.g. admin role which caused drop).

Also, in my view, dynamically created user roles should not "own" anything of significance. Some temporary objects? Fine. But not object critical for production.

For schema-level objects it is handled by schema owner roles. All schema-level objects created by SnowDDL managed users in SnowDDL managed schemas should be assigned to schema owner roles. In this case drop & re-creation of user role should be safe.

[y-tee]

I have just renamed the snowddl role.
when running snowddl plan or apply, explicitly mention specify it using -r. previously was not specified. and everything worked just fine.