Cloud Computing as an overview Cloud Computing Concepts from Snowflake Perspective
Cloud Data Warehousing Concepts Data warehousing: past to present Benefits of cloud computing Advantages of a cloud data warehouse
Introduction to Snowflake Snowflake Architecture Cloud Platforms Snowflake Editions The Data Lifecycle Organizing Data o Storing Data o Querying and Working with Data Continuous Data Protection Types of Connections
Registration, Installation and Configuration Creating an account in Snowflake Install drivers and Compatible Diagnostic tool Sample database and files A Glance at Public Cloud Storages
Working Structure ANSI SQL and extension of SQL Database Constraints Hierarchy of Objects & Containers Parameters and Variables
Building Blocks of Snowflake A look into the Web Interface Virtual Warehouses o Scaling up and out o Clusters Databases, Schemas, Tables & Views o Create objects using SQL and Web Interface Stages, File format & Sequences o Type of Stages o Creating File Formats o A Glance on Sequences Loading Data using Web Interface (Limited)
MORE INFORMATION
Loading / Unloading Data into/from Snowflake Loading data from local system using SnowSQL (CLI Client Tool) o Configuration file o SnowSQL Commands o Running batch files Loading from external stages AWS & Azure o Settings on Cloud Storage Services o Methods of accessing the stage
Querying Data in Staged Files Query Syntax Accessing Metadata Required Parameters Supported Functions
Using transformation methods Supported Objects Subset of Table Data Reorder of Columns Convert Data Types
Working with Semi-structured Data Traversing Data Querying Semi-structured Data Functions for Parsing Load into separate columns
Third-party Interfaces Types of Integration o Storage Integration o API and Working with Integrations o Using Storage Integration
Snowflake Special Features External Tables o External table Columns o Partition on external tables o Automatic Refreshing of Metadata
Snowflake Special Features Materialized Views o Comparison with Regular Views o Limitations o Securing Views
Data History and Multi-Environment Cloning o Cloning Rules o Impact of DDL Time Travel & Fail-safe o SQL Extensions o Data Retention Period o Access Control Requirements
User Scripts Stored Procedures o JavaScript o Using SQL statements User Defined Functions o Scalar Functions o Table Functions
SnowSQL – Command Line Interface “Putting” files into internal stages “Getting” data into a local system SnowSQL commands Temporary Objects Temporary Tables and Stages Transient Tables
Automatic Continuous Load Loading Continuously Using Snowpipe o Using Notification Service in AWS o Create Queuing in Snowflake o Triggering external stage for loading
Access Control Built-in Roles Creating Users Assigning Roles Restricting access for users
Sharing Data in Snowflake Data Providers and Consumers Using Secure Objects to Control Data Access Managing Reader Accounts
Connecting to Snowflake using drivers ODBC Configuration and Connection Parameters Usage of JDBC Driver Connecting from other applications Connecting and executing queries from Java / Python Using Snowflake as a source in Power BI / Tableau
Streams and Tasks Table Versioning Stream Columns Task Scheduling Tree of Tasks Change Data Capture
Query Performance Query Profile Data Clustering Load Monitoring Chart Table & Warehouse Design Considerations Data Load Planning
Managing Your Snowflake Account Understanding Snowflake Credit and Storage Usage Resource Monitors Monitoring Account-level Credit and Storage Usage Summary of Security Features o Multi-Factor Authentication o Data Encryption o Other Authentication Methods
