# Extract JSON path transform


Use this transform to extract new columns from a string column with JSON data.

**To add an Extract JSON path 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 **Extract JSON Path**.

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 **JSON column**, select a column from the data source.

1. Under **JSON paths**, enter a JSON path or multiple paths separated by commas to specify the location to extract the data from.

1. Under **Output columns**, enter the names of the columns to create from each of the JSON paths.

1. (Optional) If desired, use the toggle to drop the JSON column.