Creating a configured table in AWS Clean Rooms - AWS Clean Rooms

Creating a configured table in AWS Clean Rooms

A configured table is a reference to an existing table in the AWS Glue Data Catalog. It contains an analysis rule that determines how the data can be queried in AWS Clean Rooms. Configured tables can be associated to one or more collaborations.

Use the statistic generation provided by AWS Glue to compute column-level statistics for AWS Glue Data Catalog tables. After AWS Glue generates statistics for tables in the Data Catalog, Amazon Redshift Spectrum automatically uses those statistics to optimize the query plan. For more information about computing column-level statistics using AWS Glue, see Optimizing query performance using column statistics in the AWS Glue User Guide. For more information about AWS Glue, see the AWS Glue Developer Guide.

In this procedure, the member does the following tasks:

  • Configures an existing AWS Glue table for use in AWS Clean Rooms. (This step can be done before or after joining a collaboration, unless using Cryptographic Computing for Clean Rooms.)

    Note

    AWS Clean Rooms supports AWS Glue tables. For more information about getting your data in AWS Glue, see Step 3: Upload your data table to Amazon S3.

  • Names the configured table and chooses which columns to use in the collaboration.

The following procedure assumes that:

To create a configured table in AWS Clean Rooms

  1. Sign in to the AWS Management Console and open the AWS Clean Rooms console with your AWS account (if you haven't yet done so).

  2. In the left navigation pane, choose Configured tables.

  3. In the upper right corner, choose Configure new table.

  4. For Configure new table, for Choose AWS Glue table:

    1. Choose the Database that you want to configure from the dropdown list.

    2. Choose the Table that you want to configure from the dropdown list.

    Note

    To verify that this is the correct table, do either one of the following:

    • Choose View in AWS Glue.

    • Turn on View schema to view the schema.

  5. For Columns allowed in collaborations, choose either All columns or Custom list.

    If you choose... Then ...
    All columns All columns are allowed for use in AWS Clean Rooms (subject to analysis rules).
    Custom list Choose one or more columns that you want to allow from the Specify allowed columns dropdown list.

  6. For Configured table details,

    1. Enter a Name for the configured table.

      You can use the default name or rename this table.

    2. Enter a Description of the table.

      The description helps differentiate between other configured tables with similar names.

    3. If you want to enable Tags for the configured table resource, choose Add new tag and then enter the Key and Value pair.

  7. Choose Configure new table.

Now that you have created a configured table, you are ready to: