Tutorial: Getting started with S3 Tables

To create a table namespace and a table

1. Sign in to the Amazon Web Services Management Console and open the Amazon S3 console at https://console.amazonaws.cn/s3/.

2. In the left navigation pane, choose Table buckets.

3. On the Table buckets page, choose the table bucket that you want to create a table in.

4. On the table bucket details page, choose Create table with Athena.

5. In the Create table with Athena dialog box, choose Create a namespace, and then enter a name in the Namespace name field. Namespace names must be 1 to 255 characters and unique within the table bucket. Valid characters are a–z, 0–9, and underscores (_). Underscores aren't allowed at the start of namespace names.

6. Choose Create namespace.

7. Choose Create table with Athena.

8. The Amazon Athena console opens and the Athena query editor appears. The query editor is populated with a sample query that you can use to create a table. Modify the query to specify the table name and columns that you want your table to have.

9. When you're finished modifying the query, choose Run to create your table.

1. Create a new namespace in your table bucket by running the following command:

   aws s3tables create-namespace \
   --table-bucket-arn arn:aws-cn:s3tables:us-east-1:111122223333:bucket/amzn-s3-demo-table-bucket \
   --namespace my_namespace         

   1. Confirm that your namespace was created successfully by running the following command:

      aws s3tables list-namespaces \
      --table-bucket-arn arn:aws-cn:s3tables:us-east-1:111122223333:bucket/amzn-s3-demo-table-bucket

2. Create a new table with a table schema by running the following command:

   aws s3tables create-table --cli-input-json file://mytabledefinition.json

   For the mytabledefinition.json file, use the following example table definition:

   {
       "tableBucketARN": "arn:aws-cn:s3tables:us-east-1:111122223333:bucket/amzn-s3-demo-table-bucket",
       "namespace": "my_namespace",
       "name": "my_table",
       "format": "ICEBERG",
       "metadata": {
           "iceberg": {
               "schema": {
                   "fields": [
                        {"name": "id", "type": "int","required": true},
                        {"name": "name", "type": "string"},
                        {"name": "value", "type": "int"}
                   ]
               }
           }
       }
   }

To query a table

1. Sign in to the Amazon Web Services Management Console and open the Amazon S3 console at https://console.amazonaws.cn/s3/.

2. In the left navigation pane, choose Table buckets.

3. On the Table buckets page, choose the table bucket that contains the table that you want to query.

4. On the table bucket details page, choose the option button next to the name of the table that you want to query.

5. Choose Query table with Athena.

6. The Amazon Athena console opens and the Athena query editor appears with a sample SELECT query loaded for you. Modify this query as needed for your use case.

7. To run the query, choose Run.

To query a table

1. Open the Athena console at https://console.amazonaws.cn/athena/.

2. Query your table. The following is a sample query that you can modify. Make sure to replace the user input placeholders with your own information.

   SELECT * FROM "s3tablescatalog/amzn-s3-demo-table-bucket"."my_namespace"."my_table" LIMIT 10

3. To run the query, choose Run.