❄️ Case Studies – Snowflake

This repository contains hands-on case studies, exercises, and reference materials developed while following different courses and learning paths.

The goal is to strengthen practical knowledge of Snowflake by working through real-world scenarios involving data ingestion, transformation, and analysis.

🎯 Objectives

• Practice Snowflake
• Work with curated datasets
• Improve SQL and data modeling skills
• Explore data pipelines and transformations
• Build a portfolio of case studies

🧠 Topics Covered

• Snowflake architecture (databases, schemas, warehouses)
• Data loading and staging
• SQL transformations
• Analytical queries
• Performance considerations
• Basic data engineering workflows

⚙️ Technologies Used

• Snowflake
• SQL
• Git & GitHub
• (Optional) Python / Snowpark

🚀 How to Use

1. Clone the repository:

   git clone https://github.com/nathanyalmeida/case-studies-snowflake.git

2. Open your preferred environment:

• Snowflake Worksheets
• VS Code
• DBeaver

3. Run the SQL scripts step by step
4. Explore the exercises and adapt them to your own datasets