Join data that you've imported into SageMaker Canvas - Amazon SageMaker
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Join data that you've imported into SageMaker Canvas

Note

You can only make joins for tabular datasets in SageMaker Canvas.

You can use Amazon SageMaker Canvas to join multiple datasets into a single dataset. A join combines the two datasets. By default, SageMaker Canvas automatically joins the datasets on their matching column names. The option to combine multiple datasets might give you the ability to get more insight from the models that you build.

You can make the following joins for your datasets:

  • Inner – Returns a dataset with matching values in both datasets.

  • Left – Returns a dataset that has:

    • All the rows from the dataset to the left of the join.

    • All the rows from the dataset to the right of the join that have matching values with the columns to the left of the join.

  • Right – Returns a dataset that has:

    • All the rows from the dataset to the right of the join.

    • All the rows from the dataset to the left of the join that have matching values with the columns to the right of the join.

  • Outer – Returns all the rows when there is a match in either the left or the right dataset. The dataset from an outer join might have null values that SageMaker Canvas might impute when you build a model.

Use the following procedure to join your datasets.

To join datasets, do the following.

  1. Navigate to the Datasets page.

  2. Choose Join data.

  3. Drag and drop the datasets that you're joining into the Drag and drop datasets to join box.

  4. Configure the join. Amazon SageMaker Canvas shows you a preview of the joined data after you configure it.

  5. Choose Save joined data to save the output of the join.

The following images show the workflow of the preceding procedure.