Unable to update Snowflake connection details using recipe variables

[Siddharth1316]

We are trying set connections in a DSS flow dynamically using global and local variables. While the override variables feature works perfectly fine in database recipe (e.g. Snowflake connection), we are not able to use the updated connection value in the following SQL recipe (in database) that is connected to it. The SQL recipe still uses the old connection details only.

[ChrisWalter]

I've run into a similar issue before. Double-check that the variables are correctly mapped and that the SQL recipe is indeed set to use the variables for its connection. Also, ensure there are no caching issues causing it to stick with the old details. Sometimes a refresh or re-run can help. Good luck!

[Turribeach]

Why would you need to dynamically change connections at runtime? I believe Dataiku takes a snapshot of the code when it starts a job so any changes after that won't affect the run.