# Lookup transform


Use this transform to add matching columns by looking them up on another catalog table.

**To add a Lookup transform:**

1. Navigate to your visual ETL job in Amazon SageMaker Unified Studio.

1. Choose the plus icon to open the **Add nodes** menu.

1. Under **Transforms**, choose **Lookup**.

1. Select the diagram to add the node to your visual ETL job.

1. Connect the transform node to a data source node.

1. Select the node on the diagram to view details about the transform.

1. Under **Catalog**, select the catalog to use for lookup.

1. Under **Database**, select a database.

1. Under **Table**, select a table.

1. Under **Lookup key columns to match**, enter columns in the lookup table, separated by commas.

1. Under **Lookup columns to take**, enter columns in the lookup table to add to the data when a match is found.