Topics

• Architecture of the Snowflake Cloud Data Platform, three-tiered architecture
• Database Objects - Table Types, Time Travel, Zero Copy Clone, Views, Stages, File Format
• Data Loading and Unloading using COPY statement
• DML and DDL - Query Contract, Object Identifier
• Setup Snowflake SnoqSQL - Parameterisation, deployment and best practices
• Snowflake access management for users & applications
• Understanding Snowflake Hierarchy and Inheritance
• User management - Service Accounts and MFA
• Working with semi structured data - load, query & unload
• Snowflake Caching & Performance benefits
• Snowflake connection interface and partner networks
• Continuous Data Protection - CDP in Snowflake
• Secure Data Shring - Reader, Provider and Consumer - Real time user case
• Virtual Warehouse - Scaling and Concurrency - Cost Vs Performance
• Manage and monitor your Snowflake Account and Its usage
• Understanding Micro-Partition and Clustering in detail
• Best Practices to Work for Snowflake Platform
• Cost Optimisation and Monitoring in Snowflake - Use Cases
• Setting up Data Stage Environment for Snowflake
• Connection Configuration and common troubleshooting
• Define Data Stage pipeline to prepare S3 stage - Move data from Hadoop to S3
• Defining Data Migration pipeline for DW Lauer - S3 to Snowflake
• Identify various migration options for Teradata to Snowflake Migrations
• Setting up Data Stage environment for Teradata to Snowflake Migrations
• Develop Data Stage job to read data from Teradata and write to Snowflake
• Best Practices working with DataStage along with Snowflake
• Snowflake Kafka Integration Overview
• Setting up Kafka environment in AWS with Snowflake
• Live demo if data ingestion into Snowflake from Kafka
• Explore Snow pipe and understanding its use case for real time data ingestion
• Understanding other ETL/ELT tools available in market and how it is different from Data Stage
• Setup BI environment for Snowflake Integration - Live Demo
• Creating report in Tableau with Snowflake Data - Best Practices
• Exploring how other BI tools gets integrated with Snowflake