How can I use constants in the Connection Name with AMP?

[Magne]

Hi, Using Constant in Connection Name for In-DB Input tool does not work with AMP.

I have created a few different ODBC connections that I use directly in the Input tool, and have created the constant User.GFT that I set to "Dev", "Test", and "Prod" depending of the environment of the workflow. 

Without AMP the connection work fine and uses the correct ODBC connection according to the constant value. When using AMP this does not work. If I replace %User.GFT% with Dev directly in the Connection Name, it works with AMP, but then the whole point of constant is gone, and there is also ridiculously much more work each time I switch between the environments. How can I get this work with AMP, and not increasing the work when switching environments?

[TonyaS · Accepted solution]

@Magne 

Thank you for using AMP Engine and for bringing this to our attention. 

I ran this by our Engineers and for now a workaround seems to be to convert the workflow type to a Macro. This appears to fix the issue, but I will also add a defect to our backlog to ensure that constants with In-DB tool connections work in regular workflows with AMP by falling back to the original Engine for this functionality. In-DB tools are not AMP enabled, but that should not prevent the functionality from working in an AMP workflow. 

I also wanted to share the various AMP related resources that we have available: 

•Help Documentation

https://help.alteryx.com/current/designer/alteryx-amp-engine

https://help.alteryx.com/current/designer/Alteryx-Engine-and-AMP-Main-Differences

https://help.alteryx.com/current/designer/AMP-Memory-Use

https://help.alteryx.com/current/designer/tool-use-amp

https://help.alteryx.com/20221/designer/engine-compatibility-mode

https://help.alteryx.com/20221/designer/performance-profiling-amp-engine

https://help.alteryx.com/20221/server/amp-engine-best-practices

•AMP Engine Webinar (32 minutes)

https://community.alteryx.com/t5/Analytics/AMP-Engine-Discover-the-Untapped-Performance-of-Your-Anal...

•AlterEverything Podcast

https://community.alteryx.com/t5/Alter-Everything-Podcast/66-The-Alteryx-AMP-Engine-Explained/ba-p/5...

•Community Blog posts

https://community.alteryx.com/t5/Analytics/Accelerate-Your-Analytic-Processes-with-the-New-AMP-Engin...

https://community.alteryx.com/t5/Engine-Works/AMPlify-your-Workflows/ba-p/617590

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Best-practice-with-the-new-Multi-threa...

https://community.alteryx.com/t5/Engine-Works/AMP-Engine-Technical-Deep-Dive-Part-1-Why-AMP/ba-p/570...  

https://community.alteryx.com/t5/Engine-Works/AMP-Engine-Technical-Deep-Dive-Part-2-Key-concepts-of-...  

[Magne]

@TonyaS 

Thank you for your reply.

I will then conclude that the AMP engine is not mature enough to be used for our cases. I will try the AMP Engine again later when the constant issue is fixed, and I'm looking forward to speeding up the processing of our workflows.  

[shanoopjohnson]

Hi @TonyaS,

I am facing similar issue. 

When I turn on AMP engine, workflow constants doesn't seem to work.
Do we have a solution for this in any latest release?

I am using 2022.1.1.40869.

Appreciate the help. Thank you

[TonyaS]

Thank you for the reminder. I just checked and it looks like the fix for this was Released in the 2022.3 GA Release version, which is available for download from our licensing portal.