Renaming SQL Connection

[DriesB]

Hi Dataiku Community,

My team is currently in the process of migrating to a single Snowflake connection. Next to deprecating the old connection, we would like to rename the single connection we want to keep.

We noticed renaming from the Connection Settings page is not an option. However, it seems like we would be able to override the name from the Python API.

Is there a particular reason the name cannot be changed on the Connection page and what are the considerations before renaming a connection?

Best,

Dries

[AlexT · Accepted solution]

Hi,

Renaming the connection has other implications. Any references to that connection in datasets, user code, etc.  Would also need to be updated and it could be a dangerous operation hence why it's not provided in the UI.

As an alternative, we would usually suggest creating a new connection with the same settings and manually moving the datasets to the new connection, and rebuild the datasets.

If there are many datasets and changing these manually is not feasible using those connections then use the Public API :

https://doc.dataiku.com/dss/latest/python-api/datasets-reference.html#dataikuapi.dss.dataset.DSSData... 

https://doc.dataiku.com/dss/latest/python-api/projects.html#dataikuapi.dss.project.DSSProject.list_d...

You would also need to review your notebooks, plugin for any hardcoded values for the connection. 

Please note once changing the settings of the dataset with the new connection those datasets should also need to be rebuilt.