Unable to update Snowflake connection details using recipe variables

Options
Siddharth1316
Siddharth1316 Registered Posts: 5 ✭✭✭✭

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.

Answers

  • ChrisWalter
    ChrisWalter Registered Posts: 11
    Options

    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
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,740 Neuron
    Options

    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.

Setup Info
    Tags
      Help me…