Alteryx Engine and AMP: Main Differences

Version:
2022.1
Last modified: June 22, 2022

In the Alteryx AMP Engine article we covered the Alteryx Engine and the new Alteryx Multi-threaded Processing (AMP). Now let’s go deeper into the main differences between the 2.

Data Processing Differences

The original Engine architecture allows for mostly single-threaded processing, where your data are processed record-by-record sequentially. On the other hand, the new AMP concept allows for massively multi-threaded processing. Records process in 4 MB packets for a faster run time, and in parallel, which can affect the output record order.

With multiple cores, the AMP architecture allows for multi-threaded processing.

The original engine architecture allows for a single-threaded process, where your data is processed record-by-record.

Input Differences 

CSV file containing a field with quoted newlines will fail if a you don't enable additional option AMP only: quoted fields can have newlines in them.

Output Differences

Several tools might output records in a different order than the original Engine when a workflow runs with the AMP engine. Some of those tools include...

  • Cross Tab
  • Data Cleansing (when removing null rows)
  • Join
  • Join Multiple
  • Multi-Row Formula
  • Poly Build
  • Running Total
  • Sort (an order with special characters differs from the original engine)
  • Summarize (when Group By is used)
  • Tile
  • Union
  • Unique

If your workflow requires records from the above tools to be in a specific order for downstream operations, the Engine Compatibility Mode is available to maintain the same sortation as the original Engine. This should be used after careful consideration of the specific workflow, mainly when migrating workflows that were created with the original Engine to run with AMP Engine.

Specific functionality or configuration that has not been converted to AMP reverts to the original Engine tool in order to work. Therefore workflows that contain both AMP-converted and non-converted tools run seamlessly with AMP.

If you have questions as to which tools might have been converted to AMP, go to Tool Use with AMP.

Read Performance

A YXDB file written with the AMP engine reads in faster than a YXDB written with the original Engine.

The YXDB file written with the original Engine reads slower with AMP enabled. The formats are still compatible with each other.
Use XLSX, CSV, YXDB, and SQLite file formats with AMP—they support multi-threaded, read-in data.

There is a performance cost to converting records and packaging between original Engine and AMP when reading in Zip files. This may cause larger Zip files to read significantly slower with AMP. 

TIP

When opened in a text editor, a YXDB file written with AMP has "Alteryx e2 Database file" at the very beginning of the file content. A file written with the original Engine will just show "Alteryx Database File" at the same place.

Write Performance

To improve the original Engine performance (make AMP write a YXDB file created with the original Engine), go to the Output Data - Configuration menu, where you have the option to create a version of the YXDB file compatible with Designer 18.1 and older.

Performance Profiling

Performance Profiling per tool with AMP is available with Designer version 2021.3 and newer.

Text Input Tool and AutoField

AMP addresses a historic issue where the size of the field might not be large enough when processed by a downstream tool. You don't need to add Select tools to change data types when the resulting data exceeds the length of the original data type. AMP creates the maximum size field for strings and integers so that subsequent operations have the necessary room to hold larger downstream values.

Throttle Tool

Although the Throttle tool was not fully converted to AMP, you can use it together with the Download tool (Throttle first).

Fuzzy Match

Fuzzy Match might have different results between the original Engine and AMP. AMP records are matched using an alternative method. The order of match might be different and the output might be in reverse order as well. There is a known performance issue where Fuzzy Match is less performant with AMP than the original Engine.

RegEx Tool

AMP uses Unicode and Perl encoding standards, where the characters $, +, <, =, >, ^, |, and ~ don't qualify as punctuation. When you use the formula function REGEX_Replace or the RegEx tool to filter punctuation with the RegEx set [[:punct:]], with AMP you need to change the expression.

Example

REGEX_REPLACE([_CurrentField_],'[[:punct:]]|[\$\+<=>\^`\|~]','')

Grouping Tools and Blocking Tools

The Join algorithm with the original Engine is based on a sort-merge join method, where the records always come in a sorted order. The new Join algorithm with AMP is based on a hash join method, so the record order comes out disordered. For example:
The Join algorithm with AMP is based on hash join, so the record order is different.

Left input:
The Join algorithm - left input.

Right input:
The Join algorithm - right input.

If we join by CustomerID with the original Engine, the record order is sorted by the CustomerID field:
Join by CustomerID with the original Engine.

With AMP, records are the same but in a different order:
Join by CustomerID with AMP.

If you need to have sorted order in join output, add the Sort tool after Join or enable the Engine Compatibility Mode setting in Workflow Configuration – Runtime, below the Use AMP Engine setting.

Iterative Macros

The difference between the original Engine and AMP can occur when a tool inside the macro reports an error. Being single-threaded, the original Engine stops if an error occurs in the macro. AMP works until the iterative output is empty or the maximum number of iterations occurs. You can encounter these situations, due to a higher number of iterations:

  • The number of errors (if any) can be higher with AMP.
  • The number of records can be higher with AMP.
  • The output schema can be different with AMP.

Formula Tool

ConvertFromCodePage and ConvertToCodePage functions in the Formula tool accept string as a parameter and return string as a result, so it is not possible to distinguish how the string is encoded. There is a difference in the output of the Formula tool with these functions used with the original Engine and AMP. 

A different binary representation of the input data is caused by AMP's internal use of UTF-8 encoded strings. When the data with a different encoding is imported, there is no way to restore the original data. The original Engine stores strings as Latin-1 or UTF-16 encoded strings that were used as a buffer and allows to convert data back correctly.

Formula Add-Ins

Formula Add-Ins are not yet supported with AMP. If you need to run a workflow that contains Formula Add-In functionality, run it on the original Engine.

Analytic App

Apps that use the Map tool to select from a spatial reference layer in an Analytic App should continue using original Engine. 

Expect Equal

With the original Engine, Expect Equal remains a CReW macro. With AMP it runs as a native tool.

Parallel Branch Execution and Tool Run Order

Some workflows read from a file and then write back to it. This requires sequencing to ensure that the read is complete before the write can start. Similarly, a workflow that wants to write several sheets in one XLSX file needs to write the sheets one at a time. Alteryx Designer provides a Block Until Done (BUD) tool to help partition the work into phases that won’t get in each other’s way.
Same workaround is applicable for Email tool when you use output file(s) from previous branch(es) as attachment. You need to wait once data processing is complete and then add as attachment to the Email tool.

When you work on a workflow with multiple branches (largely separate streams from inputs to outputs), place the BUD tool in the workflow branch with the lowest numbered Input tool ID. This ensures every subsequent branch waits to run until the previous branch is done and the tool works as expected.

Available Functionality

For more information regarding specific tool functionality, go to Tool Use with AMP.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.