Skip to main content
skill CX Codex

zomato-ai-data-engineering-pipeline — Claude Code skill: setup

zomato-ai-data-engineering-pipeline is a Claude Code skill for building a food delivery batch pipeline across S3, Snowflake, dbt, and Airflow, with OpenAI for review enrichment and text-to-SQL.

no license 128 installs ★ 5 updated 2026-10-09

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add reason-machines/data-skills --skill zomato-ai-data-engineering-pipeline -a claude-code
Open on GitHub

What zomato-ai-data-engineering-pipeline does

This skill provides setup steps and SQL patterns for a food delivery medallion architecture. Raw CSV files land in Amazon S3 and load into Snowflake Bronze tables through a dedicated storage integration and external stage.

Transformations run through dbt. Silver views clean and cast seven source tables, while Gold marts manage business metrics, incremental facts, and SCD2 snapshots. Airflow runs via Docker Compose to handle scheduled pipeline tasks.

Ingestion halts if Snowflake external IDs and AWS IAM trust policies are mismatched. Running RAG searches or SQL generation also demands an active OPENAI_API_KEY in your environment.

What it helps with

  • Configure external stage ingestion from S3 into Snowflake RAW
  • Build dbt staging and mart models across medallion layers
  • Orchestrate batch workflow runs using Apache Airflow in Docker
  • Set up OpenAI integration for review enrichment and text-to-SQL

Example prompts for the agent

  • Help me configure the Snowflake storage integration for an S3 bucket
  • Build the dbt staging view for cleaning raw restaurant data
  • Generate docker compose environment settings for Airflow and Snowflake

How to install zomato-ai-data-engineering-pipeline

1Skills CLI (Vercel)

npx skills add reason-machines/data-skills --skill zomato-ai-data-engineering-pipeline -a claude-code

2Manually: put the files in place

~/.claude/skills/zomato-ai-data-engineering-pipeline/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/zomato-ai-data-engineering-pipeline/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about zomato-ai-data-engineering-pipeline

How to install zomato-ai-data-engineering-pipeline in Claude Code?

Run npx skills add reason-machines/data-skills --skill zomato-ai-data-engineering-pipeline -a claude-code. The file will be stored at ~/.claude/skills/zomato-ai-data-engineering-pipeline/SKILL.md.

What does zomato-ai-data-engineering-pipeline do?

It outlines the end-to-end architecture and code for a batch analytics pipeline using Snowflake, dbt, S3, Airflow, and OpenAI.

What external services are required for this pipeline?

You need an AWS account for S3 and IAM roles, a Snowflake account with warehouse access, Docker for Airflow, and an OpenAI API key.

Similar skills

All skills for Data and databases →
data-engineering travisjneuman The data-engineering Claude Code skill covers data pipelines and warehouse schema design. It activates for ETL/ELT work, stream processing, and dbt transformations. CX Codex +1 105installs snowflake-data-engineering-cursorrules-prompt-file PatrickJS The snowflake-data-engineering-cursorrules-prompt-file rule for Cursor defines Snowflake data engineering practices for VARIANT, Dynamic Tables, streaming ingestion, and warehouse cost control. CX Codex +1 ★ 41,178repo stars data-warehouse-experimentation rampstackco The data-warehouse-experimentation Claude Code skill explains how to run A/B tests in a data warehouse without vendor platforms. It covers user assignment, metric calculation, and statistical analysis. CX Codex +1 283installs dbt-sf-to-bq-translator official google dbt-sf-to-bq-translator — a skill for Claude Code, Gemini CLI and Codex that translates dbt SQL models from Snowflake to BigQuery. Runs when you migrate an existing dbt pipeline from one platform to the other. CX Codex +1 2,300installs snowflake-development Alireza Rezvani snowflake-development is a Claude Code skill for writing Snowflake SQL and configuring pipelines with Dynamic Tables or Streams and Tasks, dbt, Snowpark Python, and Cortex AI. CX Codex +1 25installs snowflake-snowpark-dbt-cursorrules-prompt-file PatrickJS snowflake-snowpark-dbt-cursorrules-prompt-file — a Cursor rule that gives the agent context for Snowpark Python and dbt with the Snowflake adapter. Useful when you write transformation pipelines in either tool. CX Codex +1 ★ 41,178repo stars

From the same set82

The whole set →
enterprise-user-management-ai-system enterprise-user-management-ai-system — a skill that scaffolds a user management system with Kanban boards, support tickets and AI analytics for risk, anomalies and burnout. CX Codex +1 372installs enterprise-user-management-system-ai-analytics The enterprise-user-management-system-ai-analytics skill outlines a user management app with task tracking, support tickets, and ML analytics. Use it when planning authentication, admin views, or workload and risk analysis. CX Codex +1 338installs web-analytics-agent-skill web-analytics-agent-skill pulls search and visitor metrics from Google Search Console, GA4, and Bing Webmaster Tools. Use it for SEO checks, comparisons, and reports. CX Codex +1 306installs microsoft-fabric-unified-analytics microsoft-fabric-unified-analytics walks you through a Fabric analytics stack: OneLake layers, a Dataflow Gen2 cleaning step, PySpark gold tables and Power BI on top. CX Codex +1 282installs crypto-etl-analytics-core crypto-etl-analytics-core is a Claude Code skill for building a Python and MySQL cryptocurrency OHLCV pipeline with standard-library analytics. CX Codex +1 273installs enterprise-user-management-system-ai enterprise-user-management-system-ai scaffolds a user management platform pairing React and Node.js with a FastAPI machine learning service. CX Codex +1 249installs ai-data-engineering-rag-pipeline ai-data-engineering-rag-pipeline is a Claude Code skill for building a local RAG workflow with BM25 retrieval, hierarchical document chunks, and retrieval scoring. It tests retrieval against a prepared set of questions. CX Codex +1 165installs high-stakes-analytics-decision-lab The high-stakes-analytics-decision-lab Claude Code skill checks data quality and chooses an analysis method to match the question. It runs for evidence-based reports and decision work that needs uncertainty bounds. CX Codex +1 103installs

Project sponsors

Companies that keep this analytics open