ingesting-into-data-lake

ingesting-into-data-lake is a skill for Claude Code from aws/agent-toolkit-for-aws. It costs 228 tokens per session (2,635 once invoked), scanned A, original, Apache-2.0.

A data-ingestion guide for moving files or database data into an AWS data lake, a central store for analysis. It uses table formats such as Apache Iceberg so the imported data can be queried.

In plain words
What is it for?
Use it to load data from S3, local files, databases, Redshift, Snowflake, BigQuery, DynamoDB, or existing Glue catalog tables.
Why use it?
It removes the need to design a separate import process for every supported source and helps choose an appropriate S3-based destination.

Skill for Claude Code

Written for Claude Code: shipped in a Claude Code plugin.

Part of the aws-data-analytics plugin — 9 skills shipped together

About the project

Agent Toolkit for AWS is a collection of AWS-supported MCP servers, skills, plugins, commands, and hooks that help AI coding agents build, deploy, and manage applications on AWS. It is used by developers working with AWS services through agents such as Claude Code, Codex, Cursor, and Kiro. The catalogue entries are the toolkit's own agent extensions for AWS development and operations.

aws/agent-toolkit-for-aws · 2,539 stars · on GitHub

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add skills/aws/agent-toolkit-for-aws/ingesting-into-data-lake
Any agent
npx skills add aws/agent-toolkit-for-aws --skill ingesting-into-data-lake
Clone the repo
git clone --depth 1 https://github.com/aws/agent-toolkit-for-aws

Made for: Claude Code.

Or install aws-data-analytics, the plugin that ships this one along with the rest of its 9 skills.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for ingesting-into-data-lake

README.md
[![agentmods](https://agentmods.dev/badge/skills/aws/agent-toolkit-for-aws/ingesting-into-data-lake.svg)](https://agentmods.dev/skills/aws/agent-toolkit-for-aws/ingesting-into-data-lake)
Your own site
<a href="https://agentmods.dev/skills/aws/agent-toolkit-for-aws/ingesting-into-data-lake"><img src="https://agentmods.dev/badge/skills/aws/agent-toolkit-for-aws/ingesting-into-data-lake.svg" alt="Measured on agentmods" height="20"></a>
Per session 228 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 2,635 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00228 $0.02635
Opus 5 $0.00114 $0.01318
Sonnet 5 $0.00046 $0.00527
Haiku 4.5 $0.00023 $0.00264

Measured 2d ago against content hash 0de68643aa09, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-06, from the pricing page.

Security

Grade A, and why

ingesting-into-data-lake scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

Origin

Copies of this mod

1 near-identical copy found in the catalogue:

plugins/aws-data-analytics/skills/ingesting-into-data-lake/SKILL.md · 185 lines

How it starts

The opening of the file, as written. The whole thing — 185 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Ingest into Data Lake

Move data from a source into a queryable table in the data lake. This skill assumes the source connection (if one is needed) already exists. For Glue connection setup or troubleshooting, delegate to connecting-to-data-source.

Philosophy

Default to S3 Tables unless the environment says otherwise. S3 Tables is the recommended target for new data lake work. If the user's catalog inventory shows they haven't adopted S3 Tables, recommend standard Iceberg on their existing general-purpose bucket instead of forcing them to change posture.

Common Tasks

You MUST execute commands using AWS MCP server tools when connected -- they provide validation, sandboxed execution, and audit logging. Fall back to AWS CLI only if MCP is unavailable. You MUST explain each step before executing.

Workflow

1. Verify Dependencies and Context

  • You MUST check whether AWS MCP tools or AWS CLI are available and inform the user if missing
  • You MUST confirm target AWS region and verify credentials with aws sts get-caller-identity
  • For SageMaker Unified Studio project roles, note that target tables and connections may be scoped to the project. See the caller ARN detection pattern in querying-data-lake.

2. Classify the Source

User says... Source type Reference
"upload my file", "local CSV", "move to S3" Local file local-upload.md
"load from S3", "import CSV/JSON/Parquet from s3://" S3 files s3-files.md
"import from Oracle/Postgres/MySQL/SQL Server/Redshift/RDS/Aurora" JDBC jdbc-ingest.md
"pull from Snowflake", "Snowflake table to S3" Snowflake snowflake-ingest.md
"import from BigQuery", "GCP analytics to S3" BigQuery bigquery-ingest.md
"export DynamoDB", "DynamoDB to data lake" DynamoDB dynamodb-ingest.md
"migrate Glue table", "convert Hive to Iceberg" Catalog migration catalog-migration.md

Read the full file on GitHub · 185 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 2d ago First seen · 185 lines · 228 tokens per session scan A 0de68643aa09

Subscribe to this mod's changes

ingesting-into-data-lake is a skill published in the GitHub repository aws/agent-toolkit-for-aws (2,539 stars, last pushed yesterday), licensed Apache-2.0. It adds 228 tokens to every session and 2,635 once invoked, about $0.0011 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-03.