skills.rest
mreferre
mreferreCOMMUNITY
Explore all skills by this author →
Website𝕏@mreferreGitHub

creating-data-lake-table

Create managed Iceberg tables on Amazon S3 Tables with Glue catalog registration.

Updated May 12, 2026
Search Tags:#iceberg#s3tables#glue catalog#athena ddl#data lake provisioning#iam access control#partitioning strategy
One-click install
npx skills add https://github.com/mreferre/aws-agent-toolkit-skills --skill creating-data-lake-table
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: creating-data-lake-table
Source: https://github.com/mreferre/aws-agent-toolkit-skills/tree/main/.kiro/skills/creating-data-lake-table
Command: npx skills add https://github.com/mreferre/aws-agent-toolkit-skills --skill creating-data-lake-table

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

It streamlines the creation of managed Iceberg tables on Amazon S3 Tables by coordinating bucket setup, namespace/table creation, schema definition, Glue catalog registration, partitioning, and least-privilege access control.

Core Features & Use Cases

  • End-to-end table provisioning: Creates the table bucket, namespace, Glue catalog integration, and the Iceberg table with partitioning and schema validation.
  • Multi-approach creation: Supports the default S3 Tables API workflow, an Athena DDL path for SQL-driven creation and schema evolution, and a Glue ETL Spark DDL path for pipeline-based deployments.
  • Safety-first guardrails: Checks for existing databases/tables and handles compatibility decisions to prevent accidental duplication or schema mismatches, while enforcing naming constraints required by Glue.

Quick Start

Create an S3 Tables managed Iceberg table by confirming your target region and inputs (bucket name, namespace, table name, columns/types, and partitioning strategy) with this skill.

Frequently Asked Questions about creating-data-lake-table

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I provision a secure Iceberg table on Amazon S3 Tables for Athena?▼

Provisioning a secure Iceberg table on S3 Tables requires creating the table bucket, namespace, and Glue catalog integration with schema validation and least-privilege IAM access control for Athena analytics.

Can I create Iceberg tables using Athena DDL instead of the S3 Tables API?▼

Yes, Iceberg tables can be created using Athena DDL for SQL-driven creation and schema evolution, or via the default S3 Tables API and Glue ETL Spark DDL paths for pipeline-based deployments.

What IAM access control and partitioning strategy do I need for S3 Tables?▼

S3 Tables require least-privilege IAM access control for Athena queries alongside a defined partitioning strategy, ensuring structured data storage and optimized analytics access patterns.

Does creating an Iceberg table with Glue catalog check for existing databases to prevent duplication?▼

Yes, table creation checks for existing databases and tables to handle compatibility decisions, preventing accidental duplication or schema mismatches while enforcing Glue naming constraints.

What prerequisites are needed to set up an S3-backed Iceberg data lake?▼

Setting up an S3-backed Iceberg data lake requires validating AWS CLI or MCP availability, target region, and credentials before executing namespace, Glue catalog, and table provisioning steps.

Related Skills

Explore More Data & Analytics Skills→
ryancnelsonryancnelson
34

Delegating to AWS Agent

Delegate AWS queries to a sub-agent for EC2, S3, IAM, ECS, and Lambda.

Community
Advanced
TeiNamTeiNam
12

aws-lakehouse

Construct and query AWS lakehouses with Apache Iceberg and Amazon Athena.

Community
Advanced
wesleyosantos91wesleyosantos91
6

spark-data-engineering

Build Apache Spark batch and streaming ETL pipelines with explicit schemas and partitioned Parquet writes.

Community
Advanced
AndreKuraitAndreKurait

creating-data-lake-table

Automate Iceberg table creation in AWS S3 Tables with IAM access control.

Community
Advanced