Associate tables for Analytics data lake - Amazon Connect

Associate tables for Analytics data lake

Configuration of data sharing creates a RAM invitation to the consumer account. RAM is a service to help you securely share resources across AWS accounts. Ensure that you have the required AWS Identity and Access Management (IAM) permissions to view and accept resource share invitations.

For information about the suggested IAM policies for data lake administrators, see Data lake administrator permissions.

  1. Open the RAM console  at https://console.aws.amazon.com/ram/.

  2. Under Shared with me select Resource shares

    Shared with me - resource shares table.

  3. Select the name of the resource share and Accept resource share

    Shared with me - resource shares table.

  4. Once the resource shares have been accepted, in the consumer account navigate to the AWS Lake Formation console at https://console.aws.amazon.com/lakeformation. To configure access to Amazon Connect analytics data lake tables, be certain the user configuring the following resources has Data lake administrator permissions in Lake Formation. For more information, see the - Lake Formation personas and IAM permissions reference.

  5. Either use an existing lake formation database or create a new database for the Amazon Connect analytics data lake tables. For more information, see Creating a database.

  6. In the AWS Lake Formation console, choose Tables on the left navigation menu.

    AWS Lake Formation console.

  7. Select Create table from the upper right to create a new Resource link.

    AWS Lake Formation console - create table.

  8. In the create table dialog, select the Resource link radio button. Resource link name can be any value you wish to name the linked table. For example, for the contact record data type you may want to define the link name as contact_record.

  9. Specify the Database previously created from step 5.

  10. In the Shared table choose the shared table whose RAM invite was previously accepted and you wish to map to this Resource link name.  For example, select the contact_record shared table to map to the contact record resource link.

  11. Information for the Shared table's database and owner ID will automatically be populated.

  12. Choose Create.

  13. Repeat for all data types shared to the consumer account.

  14. Open the Amazon Athena console, and run a query to check if the data with the shared instance_id is provided in the request file. For example:

    select * from database_name.linked_table limit 10.

    Where:

    • database_name is the name of the database that you created in step 5.

    • linked_table is one of the resource link names you created in step 8.