snowflake_Needs.md

1. Snowflake architecture
2. Virtual Warehouse
3. Internal stage
4. AWS/Azure/GCP based external stage
5. Snowpipe
6. File formats
7. Task
8. Dependent Task
9. Micro Partitioning
10. ADF to Snowflake
11. Stored Procedure
12. Snowsql
13. Loading data from local
14. Time Travel
15. Users & Role
16. Query/Task Monitoring
17. Zero copy cloning
18. Snowflake DDL/DML
19. Performace optimization
20. Cost control

Day 1 .Introduction

1. Snowflake : What? Why? Benfits?
2. Snowflake Architecture
3. Editions
4. Pricing and Budgeting

Day 2. Account Setup

1. Snowflake Account Setup
2. Createing your Warehouse & UI overview
3. Installation SnowSQL on Windows & Testing SnowSQL

Day 3. Data Warehouse

1. Need, benfits
2. How to setup Datawarehouse?
3. Data Ingestion
4. Exploring databases and tables
5. Tables, Types of Tables

Day 4. Data Ingestion

1. Stages
2. Loading
3. Copy
4. Various file formats (csv, json, parquet, etc)
5. Loading various types of data
6. Structured & Unstructured data handling

5. Data Integration

1. Manually import data from AWS
2. Implement a snowpipe stream with data from S3
3. Integration with AZURE
4. Integration with GCP

Day 6. Streams & Time Travel

Day 7. Automation

1. How to create Tasks
2. Jobs
3. Scheduling Jobs

Day 8. Visualization

1. Create a visualization worksheet
2. Create a dashboard
3. Connect PowerBI to Snowflake
4. Query data with Python

Day 9. Access Management

#. Day 10. Real World Case Study