Renaming SQL Connection
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
Best Answer
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,209 DataikerOptionsHi,
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 :
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.