View a markdown version of this page

Creating a configured table – Databricks data source - AWS Clean Rooms

Creating a configured table – Databricks data source

In this procedure, the member does the following tasks:

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

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

The following procedure assumes that:

  • The collaboration member has already prepared their Databricks data by creating a Delta Sharing share and recipient and a service role that AWS Clean Rooms can assume.

To create a configured table – Databricks data source

  1. Sign in to the AWS Management Console and open the AWS Clean Rooms console at https://console.aws.amazon.com/cleanrooms.

  2. In the left navigation pane, choose Tables.

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

  4. For Data source, under Third-party clouds and data sources, choose Databricks.

  5. For Databricks connection details, enter the following information about the Delta Sharing share that you prepared:

    • The Workspace URL for your Databricks workspace.

    • The Delta Sharing endpoint URL for your recipient.

    • The Share name, Schema name, and Table name that you want to bring into the collaboration.

    Note

    AWS Clean Rooms supports Databricks external tables that are backed by data in Amazon S3.

  6. For Databricks table and schema details, enter the Column name for each column that you want to be visible to query runners. AWS Clean Rooms infers the schema automatically, so you don't enter data types.

  7. For Columns allowed in collaborations, choose an option based on your goal.

    Your goal Recommended option
    Allow all columns for use in AWS Clean Rooms (subject to analysis rules) All columns
    Allow one or more of the columns that you entered Custom list

  8. 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.

  9. Choose Configure new table.

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