Error "Cannot allocate ###### bytes of memory: The `global memory limit` limit of ###### bytes was exceeded" When Attempting to Run a Flow

Option 1

Reduce the complexity and size of the flow:

1. Remove all of the columns you don't need in each input node. 
2. Shrink the field data you don't plan on using (filter using a calculation, selected value, wildcard match, null values).
3. Avoid Custom SQL as it bypasses our query processor which optimizes for performance.
4. If joining static flat files with databases, move the flat file data into the database and do the join there instead of in Prep. 
5. Move filters, aggregates before the join to shrink the table and help performance during the join step.
6. Add aggregate steps when possible to reduce multiple values down to a single value.

Option 2

Option 3

Run the flow manually in Prep Builder and then republish the flow to Tableau Cloud.

Option 4