Back to directory

Lakehouse Redshift

Agent skill
1 skill

Build a lakehouse on AWS that Redshift Serverless can query - S3 Tables (managed Apache Iceberg) for storage, the Glue federated catalog (s3tablescatalog) for metadata, Lake Formation for access control, and a Redshift Serverless external schema for SQL. Use when the user wants to "build a lakehouse on AWS", "set up a data lake on AWS", "query Iceberg from Redshift Serverless", "wire S3 Tables to Redshift", "set up the Glue federated catalog for S3 Tables", or "let Redshift Serverless read S3-resident Iceberg tables". Covers the highest time-wasted gotchas in this stack: !Ref AWS::S3Tables::TableBucket returning the ARN (not the name), the bucket-nested Glue catalog ARN format, the " @s3tablescatalog" 3-part naming, IAM access control mode versus Lake Formation access control mode, and which Redshift external-schema path to pick. Does NOT cover Firehose-specific authoring (use firehose-iceberg-pipeline) or hot-path Kinesis/Lambda CDC ingestion (use cdc-streaming-pipeline).

Install with
Claude CodeCodexCursorGitHub CopilotGemini CLI

Supported by the Atlas install prompt. Skill-specific requirements vary.

Skill stats

Skills1CategoryDeveloper toolsStars0

About this skill

Build a lakehouse on AWS that Redshift Serverless can query - S3 Tables (managed Apache Iceberg) for storage, the Glue federated catalog (s3tablescatalog) for metadata, Lake Formation for access control, and a Redshift Serverless external schema for SQL. Use when the user wants to "build a lakehouse on AWS", "set up a data lake on AWS", "query Iceberg from Redshift Serverless", "wire S3 Tables to Redshift", "set up the Glue federated catalog for S3 Tables", or "let Redshift Serverless read S3-resident Iceberg tables". Covers the highest time-wasted gotchas in this stack: !Ref AWS::S3Tables::TableBucket returning the ARN (not the name), the bucket-nested Glue catalog ARN format, the " @s3tablescatalog" 3-part naming, IAM access control mode versus Lake Formation access control mode, and which Redshift external-schema path to pick. Does NOT cover Firehose-specific authoring (use firehose-iceberg-pipeline) or hot-path Kinesis/Lambda CDC ingestion (use cdc-streaming-pipeline).

Quick start

  1. Copy the install prompt. Use the green button above this README.
  2. Send it to your agent. Paste it into your coding agent’s chat and send.
  3. Review the setup. Your agent checks the skill’s instructions, requirements, and installation scope.
Review, license & listing details
Review the source before using this skill

This is an imported listing. We haven’t certified its safety, license, or compatibility. Skills may include executable scripts.

Automated security scan: Partial

Only SKILL.md was scanned. Supporting files and scripts were not checked. No safety grade has been assigned.

0 potential findings · Scanned 11/4/2026 · Scanner 0.2.1

Content SHA-256: 952c1f14900a1993437f11d8c8af0bbb666e001d0cc8d3b306dc7d303e02a02c

About scan coverage and limitations

About this listing

Category
Developer tools
Reported license
AGPL-3.0
Listing language (estimated)
English
Review status
Not individually reviewed
Agent compatibility
Atlas installation supports Claude Code, Codex, and Cursor. Skill-specific dependencies and features are checked during setup.
Lakehouse Redshift | Agent Skills Atlas