Scribd Logo
Upload

Welcome to Scribd!

  • 24 views

    Snowflake

    Uploaded by

    funmixcrazy

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Snowflake

    Uploaded by

    funmixcrazy
    24 views3 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    24 views3 pages

    Snowflake

    Uploaded by

    funmixcrazy

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 3

    Prerequisite:

    Basic SQL knowledge and understanding Datawarehouse, if required need to attend


    additional classes

    1.Snowflake Architecture and Overview

     Snowflake Overview
     Architecture
     How to use the Snowflake UI & ecosystem

    2.Introduction to Cloud

     What is Cloud
     Different Cloud Vendors
     Advantages of Cloud over On-Premise

    3.Introduction Data Warehousing Concepts

     What is a Data Warehouse and Why do we need Data Warehouse?


     Database Vs Data Warehouse
     Data Warehouse Architecture
     OLTP Vs OLAP
     What is ETL

    5.Introduction to Snowflake

     How different from traditional DB


     Quick start to the snowflake and accessing trial account
     Creating warehouse, DB, Schema, and tables
     Accessing different roles and using it
     Working with worksheets
     Understanding different type of accounts

    6. Understand Cloud platforms

     AWS and understanding S3 storage


     Snowflake architecture and caching
     AZURE and understanding blob storage
     GCP and understanding Bucket storage
    7. Data Loading and Unloading

     File formats
     Internal and external storage
     Internal and external stage
     Copy into usage
     Snowflake internal storage
     Accessing Cloud storage data into Snowflake (GCP, AZURE and AWS)
     Data unloading

    8. SnowPipe

     Accessing Snowpipe
     PUT and GET commands
     Bulk loading from cloud storage
     Continuous loading

    9. Partner connect with snowflake

     Snowflake Connector and use cases Python


     BI connectors use cases
     Other connectors hands-on

    10. Handling JSON and Semi structure data

     Variant Datatype
     File format options
     Creating stages
     Loading JSON semi-structured data into SF tables
     Accessing JSON with select statement

    11. Scheduling with Snowflake

     Creating Tasks
     Streams
     Accessing procedures with tasks
     Scheduling as per time with Different time zones
     Automate loading process Daily and Weekly
    12. Secure Data sharing

     Usage of sharing data


     Sharing data with different accounts

     Sharing data with non-SF accounts using reader accounts


     Importance of reader accounts
     Privileges in data sharing
     Challenges with cross-region sharing and understanding replication
     Connecting shared objects with BI tools
     Limitations with Data sharing

    13. Cloning

     Access Control Privileges for Cloned Objects


     Cloning and Snowflake Objects
     Impact of DDL on Cloning
     Impact of DML and Data Retention on Cloning

    14. Time travel &Failsafe

     Introduction to Time Travel


     Querying Historical Data
     Enabling and Disabling Time Travel
     Data Retention Period
     Cloning Using Time Travel (Databases, Schemas, and Tables Only)

    15. Query Caching, Clustering, and Performance techniques

     Creating multi-users on large tables


     Performance techniques
     Result set cache
     Metadata cache
     Query data cache
     Best practices of using caching for performance and cost optimization

    You might also like