Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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.
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!