Lakehouse Redshift
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 "<bucket>@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).
Security AStatic scan found no risk patternsHow grading works ›
From the source SKILL.md
A high-level entry point for "I want a lakehouse on AWS that Redshift Serverless can query." This skill picks the architecture, names every ARN format you will hit, and steers you past the gotchas that have eaten hours of debugging time.
What this skill does
Lakehouse Redshift is a community-contributed Claude Code skill in the tools-misc sub-category. It ships as a SKILL.md file that Claude Code auto-discovers under ~/.claude/skills/lakehouse-redshift/ and loads when your prompt matches the skill's trigger.
When to invoke it: 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 "<bucket>@s3tablescatalog" 3-part naming, IAM access control mode versus Lake Formation access control mode, and which Redshift external-schema path to pick.
Who uses this skill
The Lakehouse Redshift Claude Code skill is built for developers, power users, and teams automating repetitive workflows and improving developer experience. It's part of ClaudSkills (also referred to as Claude Skills or Claude Code Skills) — the open community-curated registry of 174,000+ SKILL.md files for Anthropic's Claude Code agent and the wider Claude ecosystem (Claude API, Claude Agent SDK).
How to install
Free
Manual install (2 steps)
mkdir -p ~/.claude/skills/lakehouse-redshift
curl -L https://claudskills.com/skills/lakehouse-redshift/SKILL.md \
-o ~/.claude/skills/lakehouse-redshift/SKILL.md
Or just download SKILL.md directly and drop it into ~/.claude/skills/lakehouse-redshift/. Claude Code auto-discovers it on next session.
Skills live at ~/.claude/skills/lakehouse-redshift/SKILL.md on macOS/Linux, or %USERPROFILE%\.claude\skills\lakehouse-redshift\SKILL.md on Windows. See the full install guide for step-by-step instructions.
Telegram
📱 Install from your phone or desktop Telegram
Open @claudskills_bot on Telegram, tap Open Desktop App, and the desktop app installs this skill for you. Or share the bot link with a colleague — they get the same one-tap install. Learn more →
Pro
One-click install via the desktop app
The ClaudSkills desktop app installs any skill directly into ~/.claude/skills/ with one click — no terminal required. Pro starts at $9/mo or $149 lifetime.
Pro
For the full experience including quality scoring and one-click install features for each skill — upgrade to Pro.
Frequently asked questions
How do I install the Lakehouse Redshift Claude Code skill?
Install via the ClaudSkills desktop app (one click) or copy
SKILL.md from the source repository to
~/.claude/skills/lakehouse-redshift/SKILL.md and restart Claude Code. Both flows are detailed at
claudskills.com/install/.
What does the Lakehouse Redshift skill do?
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 "<bucket>@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).
Is this skill free to install?
Yes. ClaudSkills is an open registry — every skill keeps its source repository's license, and manual install via copy is free. ClaudSkills Pro ($9/mo, $79/yr, or $149 one-time) adds one-click install via the desktop app and a multi-signal Quality Score.
When should I use the Lakehouse Redshift skill?
Use Lakehouse Redshift when your Claude Code task falls under the Dev Tools category — specifically in the tools misc area. Claude Code auto-discovers installed skills and invokes the right one based on the task description, so you can also ask Claude directly (e.g. "use Lakehouse Redshift" or describe the task and let Claude pick). Browse related skills at
/category/tools/.
What is a Claude Code skill and how does the Lakehouse Redshift skill fit in?
A Claude Code skill is a
SKILL.md file that lives under
~/.claude/skills/<name>/ and tells the Claude Code CLI agent how to perform a specific task (instructions, prompts, allowed tools). Skills are auto-discovered at session start. Lakehouse Redshift is one of 67,000+ skills indexed in the open ClaudSkills catalog, classified under the Dev Tools category. Learn more at
/learn/what-is-a-claude-skill/.
Attribution & license
Cite this skill
If you reference this skill in a blog post, paper, or documentation, you can cite it as:
APA
jaingxyz. (2026). Lakehouse Redshift [Claude Code skill]. ClaudSkills. https://claudskills.com/skills/lakehouse-redshift/
BibTeX
@misc{lakehouse-redshift-2026,
author = {jaingxyz},
title = {Lakehouse Redshift [Claude Code skill]},
year = {2026},
publisher = {ClaudSkills},
url = {https://claudskills.com/skills/lakehouse-redshift/}
}Embed this skill
Promote, attribute, or link this skill from your own README, blog post, or documentation. All three snippets are free to use — no sign-up, no API key. More distribution surfaces →
Badge
[](https://claudskills.com/skills/lakehouse-redshift/?utm_source=badge&utm_medium=readme&utm_campaign=skill_badge)
<script>
<script src="https://claudskills.com/embed/lakehouse-redshift.js" async></script>
<iframe>
<iframe src="https://claudskills.com/embed/lakehouse-redshift.html" width="100%" height="160" frameborder="0" loading="lazy" title="ClaudSkills: Lakehouse Redshift"></iframe>
Security scan
Grade A · scanned 2026-08-02 — free static scan against the OWASP Agentic Skills Top 10.
No risk patterns were found in any of the ten OWASP-aligned categories. How grading works ›
- ✓ Prompt injection
- ✓ Data exfiltration
- ✓ Supply chain
- ✓ Reverse shell
- ✓ Credentials
- ✓ Execution
- ✓ Filesystem
- ✓ Persistence
- ✓ Obfuscation
- ✓ Network
Show this grade on your repo (click to copy):
[](https://claudskills.com/skills/lakehouse-redshift/#security)
More Dev Tools skills
Browse all Dev Tools skills in the ClaudSkills registry, or explore these other picks from the same category:
Part of Acreator Store — Adam Lankamer's AI tools:
PerfectStudio ·
Ucaption ·
UTagger ·
AutoXPoster ·
TestYourSkills ·
AutomationFlows ·
Au Naturel ·
Telegram @acreatorstore