CH CloudHill

Introduction

Architecture

Stages: (AWS)

Processing structured and semi-structured

Data Types

Connectors

Partner connect

Transformations

Continuous data protection

Performance tuning

Metadata Management

Data Sharing

Security & Admin

Introduction: 3Hrs

• Services layer
• UI Ribbon
• WH (multi cluster)
• Storage
• Cache (Metadata, result, WH)
• System Roles (sf defined roles)

Stages: (AWS): 2Hrs

• Internal
• external (S3/Azure BLOB/ GCP bucket integration objects)
• Table(Types)
• User Stage
• EXTERNAL Tables
• Views

Loading/unloading (structured and semi-structured data): 4Hrs

• Data types
• Copy (Web UI)
• Snow pipe
• Unload
• Bulk loading/Unloading
• File formats
• Copy formats

Partner connect: 3Hrs

• Introduction to partner connection (Matillion / stitch) With Python use case
• Snow SQL
• ODBC (IDE’s)
• JDBC (with Tableau or PowerBI)

Transformations: 3Hrs

• Tasks
• Stored procedures / UDF
• Change in data types

Continuous data protection: 2Hrs

• Cloning
• Fail-safe and time-travel
• Streams (CDC)

Performance tuning: 2Hrs

• History and Query profile
• Performance and concurrency
• Automatic clustering

Metadata Management: 1Hr

• Information schema vs information schema,
• Account usage Schema
• System functions(system$)

Data Sharing: 4Hrs

• Provider accounts
• Consumer accounts
• Share objects
• Reader accounts
• Data exchange
• Data Marketplace

Security & Admin: 3Hrs

• RBAC (Application of roles to respect GDPR, PII)
• Network policy
• MFA/SSO
• Dynamic data masking
• AWS private link
• Billing(WH, SP, Clustering, Cloud services)
• Resource monitor