Snowflake Course

• 1.1  How different from a traditional DB like (Oracle …)

  1.2  Quick start to Snowflake and accessing trial account

  1.3  WebUI, Creating warehouse, DB, Schema, and tables

  1.4  Accessing different roles and using it

  1.5  Working with Snowflake CLI

  1.6  Understanding different type of accounts

• 2.1  AWS and understanding S3 storage

  2.2  Snowflake architecture and caching.

  2.3  AZURE and understanding blob storage

  2.4  GCP and understanding Bucket storage

• 3.1  File formats

  3.2  Internal and external storage

  3.3  Copy into usage

  3.4  Snowflake internal storage

  3.5  Accessing Cloud storage data into Snowflake(GCP, AZURE and AWS)

  3.6 Data unloading

• 4.1  Variant Datatype

  4.2  File format options

  4.3  Creating stages

  4.4  Loading JSON semi-structured data into SF tables

  4.5  Accessing JSON with select statement

• 5.1  Accessing Snowpipe

  5.2  PUT and GET commands

  5.3  Bulk loading from cloud storage

  5.4  Continuous loading

• 6.1  Snowflake Connector and use cases Python

  6.2  BI connectors use cases.,

  6.3  Other connectors hands-on

• 7.1  Creating Tasks

  7.2  Streams

  7.3  Accessing procedures with tasks

  7.4  Scheduling as per time with Different time zones

  7.5  Automate loading process Daily and Weekly

• 8.1 Usage of sharing data

  8.2 Sharing data with different accounts

  8.3 Sharing data with non-SF accounts using reader accounts

  8.4 Importance of reader accounts

  8.5 Privileges in data sharing

  8.6 Challenges with cross-region sharing and understanding replication

  8.7 Connecting shared objects with BI tools like POWER BI

  8.8 Limitations with Data sharing

• 9.1  Access Control Privileges for Cloned Objects

  9.2  Cloning and Snowflake Objects

  9.3  Impact of DDL on Cloning

  9.4  Impact of DML and Data Retention on Cloning

• 10.1  Introduction to Time Travel

  10.2  Querying Historical Data

  10.3  Enabling and Disabling Time Travel

  10.4  Cloning Using Time Travel (Databases, Schemas, and Tables Only)

  10.5  Fail safe in snowflake.

  10.6  Relation between fail safe and retention period.

  10.7  Permanent table and failsafe.

  10.8  Transient table & Temporary table

• 11.1 Creating multi clusters on large tables

  11.2 Query processing inSnowflake

  11.3 Micro partitions in Snowflake

  11.4 Performance techniques

• 12.1 Implement SCD in Snowflake

13.1  Snowflake Realtime Data warehousing project #1

13.2  Snowflake Realtime Data warehousing project #2

13.3  Snowflake Realtime Data warehousing project #3

13.4  Snowflake Realtime Data warehousing project #4

13.5  Snowflake Realtime Data warehousing project #5