Skip to content

CreateTableCommand (S3Tables) Example syntax omitted some field #7091

Open
@nohraemong

Description

@nohraemong

Describe the issue

Hi, team. This example omitted required fields. (metadata.schema.type field) When I created S3tables with this example, I cannot read table from query engine like Athena. Please modify this like below example, and table that created with below can query from Athena


        "metadata": {
            "iceberg": {
                "properties": {},
                "schema": {
                    "type": "struct",
                    "fields": [
                        {
                            "type": "string",
                            "name": "line_item_usage_account_id"
                        },
                        {
                            "type": "string",
                            "name": "line_item_usage_account_name"
                        },
                        {
                            "type": "string",
                            "name": "line_item_line_item_type"
                        },
                        {
                            "type": "string",
                            "name": "line_item_product_code"
                        },
                        {
                            "type": "string",
                            "name": "line_item_resource_id"
                        },
                        {
                            "type": "string",
                            "name": "product_product_family"
                        },
                        {
                            "type": "double",
                            "name": "line_item_unblended_cost"
                        },
                        {
                            "type": "double",
                            "name": "line_item_usage_amount"
                        },
                        {
                            "type": "string",
                            "name": "line_item_line_item_description"
                        },
                        {
                            "type": "string",
                            "name": "product_region_code"
                        },
                        {
                            "type": "string",
                            "name": "line_item_usage_start_date"
                        },
                        {
                            "type": "string",
                            "name": "line_item_usage_end_date"
                        },
                        {
                            "type": "string",
                            "name": "year"
                        },
                        {
                            "type": "string",
                            "name": "month"
                        }
                    ]
                },
                "partition_spec": {
                    "fields": [
                        {
                            "source": "year",
                            "transform": "identity",
                            "name": "year"
                        },
                        {
                            "source": "month",
                            "transform": "identity",
                            "name": "month"
                        }
                    ]
                }
            }
        }

Links

https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/client/s3tables/command/CreateTableCommand/

Metadata

Metadata

Assignees

Labels

documentationThis is a problem with documentation.p3This is a minor priority issue

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions