Alteryx AMP Engine
2021.4.2 Patch Update
Alteryx now gives you the ability to patch your installation of Designer or Server without the need to perform a full uninstall and reinstall.
The 21.4.2 Patch and all subsequent releases contain an important security fix for AMP Engine.
- If you previously installed the base version 2021.4.2.02731, please apply the patch.
- For all other versions, please install the full 2021.4.2.07064 version (this version already includes the patch).
You can download both items from the Downloads & Licences portal.
When you run your workflows, you might have wondered what’s under the hood providing the functionality. This article gives you an overview of the Alteryx Engine and the new Alteryx Multi-threaded Processing (AMP) engine.
What’s Alteryx Engine
Alteryx Engine is an operator which processes each record of the workflow. It uses the machine’s cores and RAM (memory) to run your workflows.
Alteryx Multi-threaded Processing (AMP) is a new architecture of the Alteryx engine. As the name implies, AMP is a multi-threaded concept of processing your data in parallel packets. In contrast, the original engine architecture processes your data record-by-record and sequentially to run a workflow.
Why Use AMP
AMP is designed to work with larger volumes of data at a higher velocity and typically executes workflows faster, with efficient usage of machine resources.
The AMP engine is available from Designer version 20.2+.
AMP is the default Engine for all new workflows starting with Designer version 22.1.
Debug mode for Analytic Apps or Macros is available with AMP Engine starting with Designer version 2022.1.1 Patch 1.
The AMP engine must have at least 400 MB of memory available to process one thread of a workflow. For example, with 8 threads, there must be at least 3.2 GB of memory available at runtime. If there are only 2.5 GB available at runtime, AMP will use 6 threads to satisfy the 400 MB minimum.
Align Memory Limit settings with the thread utilization. To learn more about AMP memory use, go to AMP Memory Use.
AMP can greatly increase the processing speed of your data. Using AMP might, however, have limitations in available memory and tools usage. You can decide based on the following steps:
- Run an existing workflow a few times in the original Engine, then run the workflow a few times with the AMP Engine.
- Compare the Results Pane (messages, warnings, errors, duration of the run) as well as any resulting data to check for differences.
- To identify whether a workflow ran with the AMP Engine, check the Results Pane for a message stating "This is AMP Engine; running [N] worker threads."
How to Switch AMP Off
The default setting for all new workflows is AMP.
You can cancel the selection to use AMP engine in user or workflow settings. Navigate through the following steps to switch between the original and AMP engines.
To cancel the selection of AMP engine for all new workflows:
- Go to Options > User Settings > Edit User Settings.
- On the Defaults tab, clear the selection from the Use AMP Engine for all new workflows check box.
- Select Save.
AMP supports networking via proxy. SFTP over http proxy is supported for both AMP and the original Engine, as same as the ability to bypass proxy.
You can specify Proxy Protocol Type (HTTP and SOCKS5h) in Options > User Settings > Advanced > Proxy Settings - Configure. The default Proxy Protocol Type is HTTP.
Admins can configure a proxy in System Settings. Go to Options > Advanced Options > System Settings > Engine > Proxy.
To cancel the selection of a workflow run with the AMP engine:
- Select a point on the white space of the canvas to display the Workflow - Configuration window.
- Go to the Workflow - Configuration window and select the Runtime tab.
- Clear the selection from the Use AMP Engine check box.
- Run the workflow.
There is a maximum of 32 allowed connections for any tool when AMP is enabled to prevent deadlocks.
Learn More about AMP
This is just a quick overview of the Alteryx Engine and AMP. If you want to learn more, check out these articles: