> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Magic ETL Tiles: Performance

export const InlineImage = ({src, alt = '', height = '1.6em'}) => {
  return <img noZoom src={src} alt={alt} style={{
    display: 'inline',
    verticalAlign: 'start',
    height: height,
    margin: '0'
  }} />;
};

### Intro

There are two available tiles in the Performance tab of the Magic ETL interface:

* Select and Store Columns
* Restore Columns

<Frame>
  <img alt="Performance_Tab.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/YnZ-qckvNLvJGrb6/images/kb/ka0Vq0000000xsv-00N5w00000Ri7BU-0EM5w000005vNiY.png?fit=max&auto=format&n=YnZ-qckvNLvJGrb6&q=85&s=45e865d5bb8660a49b5d7d10a42ff976" style={{width: 299, height: 164}} width="286" height="157" data-path="images/kb/ka0Vq0000000xsv-00N5w00000Ri7BU-0EM5w000005vNiY.png" />
</Frame>

Learn how to [create a Magic ETL DataFlow](/s/article/360055259234).

<Note>
  **Note:**
  These tiles are available by default to organizations on the Domo Consumption agreement.

  For non-consumption users, the tiles are available
  *on demand*
  and
  *paid*
  .
  To enable Performance tiles, contact your Domo account team. You may need to complete training before you can use a tile.
</Note>

***

### Prerequisites

The Performance tiles are intended for use with either the Python or R Scripting tiles. For more information on the Scripting tiles, see [Magic ETL Tiles: Scripting](/s/article/360045485833).

<Frame>
  <img alt="Performance_Tiles_Configuration.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/YnZ-qckvNLvJGrb6/images/kb/ka0Vq0000000xsv-00N5w00000Ri7BU-0EM5w000005vNim.png?fit=max&auto=format&n=YnZ-qckvNLvJGrb6&q=85&s=d585f6ccd1fb8ce4c7a86acca879aea4" width="793" height="158" data-path="images/kb/ka0Vq0000000xsv-00N5w00000Ri7BU-0EM5w000005vNim.png" />
</Frame>

### Select and Store Columns Tile

<Frame>
  <img alt="Select_and_Store_Columns.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/YnZ-qckvNLvJGrb6/images/kb/ka0Vq0000000xsv-00N5w00000Ri7BU-0EM5w000005vNj1.png?fit=max&auto=format&n=YnZ-qckvNLvJGrb6&q=85&s=dcb1ce5a99f7800d75a7d3cf11e3f7c7" width="116" height="118" data-path="images/kb/ka0Vq0000000xsv-00N5w00000Ri7BU-0EM5w000005vNj1.png" />
</Frame>

The Select and Store Columns tile allows you to store/remove columns that are not used as part of the script inside of a Python or R Scripting tile. Storing columns not applicable to the Scripting tiles transformations prior to the Scripting tile reduces the amount of data being loaded. Following this process will generally decrease the runtime of your Scripting tile as the tile is now only loading the necessary columns for its transformation.

<Frame>
  <img alt="Select_and_Store_Columns_Configuration.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/YnZ-qckvNLvJGrb6/images/kb/ka0Vq0000000xsv-00N5w00000Ri7BU-0EM5w000005vNj3.png?fit=max&auto=format&n=YnZ-qckvNLvJGrb6&q=85&s=ffd71ed76724695de652cdf1d1bb50f3" width="662" height="497" data-path="images/kb/ka0Vq0000000xsv-00N5w00000Ri7BU-0EM5w000005vNj3.png" />
</Frame>

Follow these steps to configure the Select and Store Columns tile:

1. Click the
   **Select and Store Columns** tile in the canvas.
2. (Optional) Rename the tile by clicking
   <InlineImage src="/images/kb/ka05w00000122yV-00N5w00000Ri7BU-0EM5w000005vNgL.png" />, then entering the name you want.
3. Select the columns you want to use in the subsequent Python or R Scripting tile.
4. (Optional) To verify all desired columns have been selected, hide all non-selected columns in the list by clicking
   <InlineImage src="/images/kb/ka0Vq0000000xsv-00N5w00000Ri7BU-0EM5w000005vNj2.png" />.
5. Name the column that you will use to restore the columns to the DataFlow.

<Warning>
  **Important:**
  Do not modify the column you named in this step in any other tile in the DataFlow or the Restore Columns tile will not work as expected.
</Warning>

### Restore Columns Tile

<Frame>
  <img alt="Restore_Columns.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/YnZ-qckvNLvJGrb6/images/kb/ka0Vq0000000xsv-00N5w00000Ri7BU-0EM5w000005vNiX.png?fit=max&auto=format&n=YnZ-qckvNLvJGrb6&q=85&s=5d859c01dff00e7cbcd126887285c4ca" width="118" height="96" data-path="images/kb/ka0Vq0000000xsv-00N5w00000Ri7BU-0EM5w000005vNiX.png" />
</Frame>

The Restore Columns tile allows you to restore/add the stored columns back into your DataFlow after the script in your Python or R Scripting tile has been processed.

<Frame>
  <img alt="Restore_Columns_Configuration.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/YnZ-qckvNLvJGrb6/images/kb/ka0Vq0000000xsv-00N5w00000Ri7BU-0EM5w000005vNj5.png?fit=max&auto=format&n=YnZ-qckvNLvJGrb6&q=85&s=fa78ac158036e991965dd89c6f17b602" width="337" height="274" data-path="images/kb/ka0Vq0000000xsv-00N5w00000Ri7BU-0EM5w000005vNj5.png" />
</Frame>

Follow these steps to configure the Restore Columns tile:

1. Click the
   **Restore Columns** tile in the canvas.
2. (Optional) Rename the tile by clicking
   <InlineImage src="/images/kb/ka05w00000122yV-00N5w00000Ri7BU-0EM5w000005vNgL.png" />, then entering the name you want.
3. Select the column that you named in the Select and Store Columns tile.
4. (Optional) Review the columns that will be restored by hovering over the text that states the number of columns that will be restored.
