Amazon S3 tables integration

Enable Amazon S3 Integration

1. Navigate to the Amazon S3 console. In the left navigation pane, choose Table buckets.

2. Choose Create table bucket.

3. On the Create table bucket page, enter a Table bucket name and select Enable integration.

4. Choose Create table bucket.

5. You will see confirmation when Amazon S3 completes integration of your table buckets with SageMaker Lakehouse.

Onboard S3 Tables in SageMaker Lakehouse

To provide access to S3 tables, complete the following steps:

1. Navigate to the AWS Lake Formation console.

2. In the left navigation pane, choose Catalogs and choose S3tablescatalog.

3. From S3tablescatalog, under Objects, choose the name of your newly created table bucket.

4. From the Actions menu, select Grant.

5. In the Grant permissions, under IAM users and roles, select your Amazon SageMaker Unified Studio Project role. To grant full access, under Catalog Permissions > Grant, select Super user.

Create S3 Table and add data in SageMaker Lakehouse

1. Navigate to Amazon SageMaker Unified Studio, and select the project.

2. From the Build menu, select Query Editor, and ensure you have Athena selected in Connections.

3. Create a database using SQL.

   
   CREATE DATABASE "s3tablescatalog/<Your Bucket Name>".<YourDBName>;
   

4. Create an S3 table using SQL.

   
   CREATE TABLE "s3tablescatalog/<Your Bucket Name>".<YourDBName>.<YourTableName> 
   ( c_salutation string, 
     c_login string, 
     c_first_name string, 
     c_last_name string, 
     c_email_address string)
     TBLPROPERTIES ( 
     'table_type'='ICEBERG'  );
             

5. Add data using SQL.

   
   INSERT INTO "s3tablescatalog/<Your Bucket Name>".<YourDBName>.<YourTableName>
    VALUES('Dr.','1381546','Joyce','Deaton','Joyce.Deaton@qhtrwert.edu');