Airflow Data Pipeline — Amazon S3 to Redshift ETL

    1

    Orchestrate an S3-to-Redshift data warehouse workflow with Apache Airflow DAGs, custom operators, fact/dimension loads, and basic quality checks.

    Free

    Security scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Airflow Data Pipeline — Amazon S3 to Redshift ETL

    Example session with this skill installed

    Help me configure and run the supplied S3-to-Redshift Airflow pipeline.

    • Read your context and instructions
    • Compiled the airflow data pipeline

    A setup checklist for Airflow connections, DAG/plugin placement, S3 locations, Redshift access, and the missing schema SQL prerequisite.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    A Python/Apache Airflow data engineering project that stages song and event JSON data from Amazon S3 into Amazon Redshift, loads a songplays fact table and users/songs/artists/time dimensions, and runs basic non-empty-table checks. Includes project setup guidance for AWS and Redshift connections. The source uses legacy Airflow APIs and references a create_tables.sql file that is not included, so buyers must adapt compatibility and configuration before running.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Data & Databases.

    Legacy Airflow APIs may require migration. create_tables.sql is referenced but absent. Data-quality checks only verify tables are non-empty. Replace historical S3 paths with authorized locations.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Free to use

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 2 days ago

    • Free with an Agensi account

    Accounts
    AWS account with S3 access
    Software
    PythonApache AirflowAmazon Redshift cluster

    Permissions

    File Scopes

    Airflow
    Data
    Pipeline
    project
    documentation

    Buyer configures their own AWS and Redshift connections. No credentials are included.

    Listed2 days ago

    What's inside

    Frequently Asked Questions

    Orchestrate an S3-to-Redshift data warehouse workflow with Apache Airflow DAGs, custom operators, fact/dimension loads, and basic quality checks.

    This skill uses the open SKILL.md standard. Use it through an MCP-compatible agent connected to Agensi, and check the compatibility information on this page for confirmed agents and required capabilities.

    Connect your AI agent to Agensi through MCP, then ask it to use Airflow Data Pipeline — Amazon S3 to Redshift ETL on your task. Your agent loads the latest approved version each time. Paid skills require a purchase or active subscription. Skill files are not available for download; your licence does not allow you to save, copy or export any part of a skill.

    New in Data & Databases

    Free