Section 1 – High Level Overview 30.

[Demo] Applying clustering brief intro

1. Course structure. Assignment 3: Micro-partition assignment 1.

2. Latest updates !!!! Assignment 4: Micro-partition assignment 2.

Section 2 – Module 1 . Assignment 5: Create clustered table.

3. Module-1 introduction Section 7 : Clustering – Deep Dive

Section 3 – S/F environment setup 32. Section introduction.

4. Creating snowflake trail account 33. [Demo] Checking clustering information

5. Snowflake web console introduction part1 34. [Demo] How clustering works.

6. Snowflake web console introduction part2 35. [Demo] Improve performance without
applying clustering
7. Web console limitation
36. [Demo] Manual re-clustering
8. Creating database and table intro to sample
data. 37. [Demo] How to choose clustering keys.

9. Section revise notes 38. Section Recap.

Section -4 Snowflake architecture 39. Snowflake clustering documentation.

11. Snowflake architecture introduction. Assignment 6: Clustering deep dive

assignment 1.
12. Shared disk architecture.
Assignment 7: Clustering deep dive
13. Shared nothing architecture part 1
assignment 2
14. Shared nothing architecture part 2
Section -8 : Introduction to virtual warehouse
15. Snowflake architecture revisit. creation

16. The impact 41. Introduction to virtual warehouse.

Section – 5 : Caching in snowflake data 42. Virtual warehouse creation

warehouse
43. Scaling policy
19. Introduction.
Section 9 : Snowflake new UI overview
20. [Architecture demo] Caching in snowflake.
45. Introduction
21. [Architecture demo] Caching revisit.
46. Snowflake worksheets
22. [Architecture demo] Lessons learned.
47. Snowflake UI tabs
23. Clarifications
Section 10 :- Virtual warehouse - Outlook
Section -6 : Clustering in Snowflake
48. Warehouse idle time intro
26. introduction.
49. Warehouse analogy
27. Query processing in snowflake.
50. Metadata views
28. Micro partitions in snowflake.

29. Micro partitions depth.

Section 11 : Virtual warehouse coast – 76. QAS- Eligible queries
Building dashboard
77. Importent points
52. Calculating idle cost
Section 14 : Search optimization service
53. Adding dynamic filters
79. SOS introduction
54. Creating dashboard intro
80. Problem statement
55. Warehouse utilization dashboard.
81. SOS: Scenario-1
56. Analysis by warehouse
82. SOS: Scenario-2
57. Analysis for under utilization
83. SOS: Scenario-3
58. Analysis for over utilization
84. How SOS works
59. Building dashboard
85. SOS: Summary
60. Leveraging snowflake UI
86. Query optimisation options
61. Conclusion
Section 15 – Optimization – outlook
Section 12 : Perfomance tuning and DB
88. Basic understanding
characteristics
89. ScaleUp vs ScaleOut
63. What is performance tuning in snowflake.
90. Query optimisation
64. How query optimization works.
91. Storage considerations.
65. Concurrency control.
92. As per documentation.
66. [Demo] How update transaction works.
93. Business model
67. [Demo] No constraints.
94. Warehouse monitor
68. Q/A
95. Warehouse monitor:Demo
Assignment 8: Performance : Executing
update statements. 96. Budgets.
Assignment 9: Performance : Adding new Section 16 – Module 2 Start
column.
98. Module-2 Introduction.
Assignment 10: Performance : Which query is
good. 99. Install AWS CLI in windows.

Section 13 : Query acceleration Service 100. Install AWS CLI in Mac.

70. Introduction 101. Install Snow CLI

71. Creating warehouse with QAS 102. Create GitHub account

72. Problem statement 103. Configure Gitpod

73. QAS- Solution 104. Snowcli from Gitpod

74. QAS- Demo 105. Things to be taken care.

75. QAS- scale factor

Section 17 : Loading data in snowflake Section 20: Load data from AWS S3

106. Introduction to stages in snowflake. 128. Section introduction.

107. Configuring connection to stage. 129. Create aws account.

108. Types of internal stage 130. Scenario.

109. Introduction to stage object , file format 131. Create aws s3 bucket.
and copy command.
132. Create aws s3 policy.
Assignment 11: Create stage object.
133. Create aws role.
Assignment 12: Create file format object.
134. Create snowflake integration object.
Section 18 : Load data using internal stage
135. Query aws s3 from snowflake.
110. Section intro.
136. Load data from s3 to snowflake.
111. Upload data using webconsole.
137. Unload data to s3
112. Scenario
138. Aws cli basics
113. [Demo] Load data from local system to
139. Other options to copy.
snowflake-Part1
140. Copy zip files
114. [Demo] Load data from local system to
snowflake-Part2 141. Upload data to aws s3 using aws web
console and cli.
115. [Demo] Load data from local system to
snowflake-Part3 142. Section Recap.
116. [Demo] Download data from snowflake Section 21 – Snowflake External Tables
to local system.
143. Introduction to external tables.
117. [Demo] Load data using named stage
object. 144. Why external tables.

Assignment 13: Load data using snowCLI. 145. Insert scenario.

Section 19 : Load data using internal stage 146. Delete scenario.

119. Introduction. 147. Update scenario.

120. Challenge-1 148. Partition in external tables.

121. Challenge-2 149. Manual partition in external tables.

122. Challenge-3 150. Auto refresh metadata.

123. Challenge-4 Section 24 : Copy options

124. Challenge-5 164. Introduction.

125. Challenge-6 165. [Demo] Validate before loading data to

table.
126. challenge-7
166. [Demo] File level options.
127. Challenge-8
167. [Demo] Collecting rejected records from 194. CH4: External view solution
copy command.
195. CH5: Climate data.
168. [Demo] Enforce and Truncate column
196. CH5: scenario-1
option.
197. CH5: scenario-2
169. [Demo] Force option.
198. CH5:scenario-3
170. [Demo] Purge option.
Section 27 : Assignement deprecated
171. Load history and copy history views
Assignment 15: Load data into snowflake
Section : 25 Demo : Working with copy
table using internal stage.
command
Assignment 16: Assignment load data to
172. Preparing data.
multiple tables
173. Load sample data.
Assignment 17: Unload data to internal stage.
174. Copy command performance.
Assignment 18: Create integration object.
Section : 26 : Workshop
Assignment 19: Use snowflake as query
175. CH1:Tobacco data. engine over aws s3.

176. CH1:scenario-1 Assignment 20: Loading aws open data to

snowflake.
177. CH1:scenario-2
Section : 28 : Loading Semi Structured data
178. CH1:scenario-3
199. Loading unstructured data introduction.
179. CH1:scenario-4
200. Load json data
180. CH1:scenario-5
201. Load xml data
181. CH1:scenario-6
202. Loading semi-structured data: Method-1
182. Tobacco_scenario:solution
203. Loading semi-structured data : Method-2
183. CH2: Intro
204. Loading semi-structured data : Method-3
184. CH2: Load multiple files - 1
Assignment 21: Load json book data.
185. CH2:Load multiple files - 2
Assignment 22: Load twitter data.
186. CH2:solution
Assignment 23: Unload and load parquet
187. CH3:intro
data.
188. CH3:unload data scenario
Section : 30 Module 3 Snowpipe
189. CH3:scenario-1
206. Snow pipe introduction.
190. CH3:scenario-2
207. Snowpipe demo
191. CH3:scenario-3
208. Snowpipe analysis part-1
192. Data unload solution.
209. Snowpipe analysis part-2
193. CH4: External view
210. Snowpipe analysis part-3
Assignment 24: Snowpipe assingment. 229. Transient table.

Section : 31 Data Sharing in snowflake 230. Temporary table.

211. Data sharing quick introduction. 231. Creating transient database in snowflake.

212. Data share demo Assignment 30: Assignment:- Fail safe.

213. Creating secure view Section : 34 : Clone feature in snowflake

214. Difference between secure and normal 233. Clone feature in snowflake and how it
view. works.

215. Creating snowflake reader account. 234. Clone feature demo.

216. Configure reader account. 235. Table swap in snowflake.

217. Restriction on reader account. Assignment 31: Assignment:-Cloning.

218. Data share significance. Section : 35 : Data Sampling in snowflake

219. Further reading Resources 236. Snowflake sampling introduction.

Assignment 25: Assignment-1: Create shared 237. Row vs Block sampling.

account.
238. Sampling Demo
Assignment 26: Assignment-2 : Create views
239. Clone vs Sampling.
Assignment 27: Assignment-3 : Create shared
Assignment 32: Assignment:-Data sampling.
database
Section : 36 : Scheduling in snowflake –
Section 32 : Time Travel in Snowflake
TASKS
220. Time travel demo.
241. Snowflake tasks introduction.
221. Time travel in snowflake and how it
242. Snowflake task demo.
works.
243. Task dependency intro.
222. Table retention period.
244. Task dependency demo
223. More on time travel.
Section : 37 : Streaming in snowflake
Assignment 28: Assignment : Time travel
245. Introduction to streams.
Assignment 29: Time travel and retention
period. 246. Strea.g demo part 1
Section : 33: Fail safe in snowflake 247. Strea.g demo part 2
224. Fail safe in snowflake. 248. Types of stream
225. Access fail safe from web console. 249. CHANGE clause
226. Relation between fail safe and retention 250. Slowly changing dimension using
period. streams.
227. Table types in snowflake.

228. Permanent table and failsafe.

Section : 38 : DEMO CONTINOUS data load in 276. Introduction
snowflake
277. What is iceberg table
251. Demo overview
278. Comparison.
252. Code preparation
279. Configure Iceberg with snowflake
253. Execution
280. Create table.
Section : 39 : Materialized view
281. Insert record- intro
254. Materialized view intro
282. Insert record-deep dive
255. MV under the hood
283. Insert record-experiment
256. MV maintenance cost
284. Insert 2nd record-intro
257. Before using MV
285. Insert 2nd record-in detail
258. Limitation of Materialized views.
286. Snapshot isolation
Assignment 33: Assignment :- Materialized
287. Update operation
views.
288. COW vs MOR
Section : 40 : Dynamic table
289. Delete operation
259. Queries used in this section.
290. Partition by/Cluster by - Snowflake.
260. Introduction
291. Partition by - Athena -1
261. Introduction on views
292. Partition by - Athena - 2
262. Understanding materialized views
293. Time travel
263. Dynamic table introduction
294. Why Iceberg
264. Dynamic table under the hood - part 1
Section : 43 : Data Governance and
265. Dynamic table under the hood - part 2
Administration
266. Revise dynamic table
296. Data governacence and Ad.istration
267. Target lag
Section : 44 : Data Masking
268. Full refresh vs Incremental refresh
297. Introduction to data masking.
269. Example scenario
298. Understand data masking
270. Approach: Normal way
299. Data masking scenario 1
271. Approach : Using dynamic table.
300. Data masking scenario 2
272. SCD type 2 in dynamic table
301. Segregation of duties
273. Dependency in dynamic table
302. Apply data masking (HIPAA version 1)
274. Downstream property
303. HIPAA rules version 2
Section : 41 : Snowflake iceberg tables
304. Problem with masking
275. Section_related_code_files
305. Using views 333. Transactions in stored procedures.

306. Using views ( continued ) 334. Caller and owner procedures.

Section : 45 : Row access policy 335. Using session variables in procedures.

307. Introduction. 336. Owner and Caller procedure use cases.

308. Row access policy demo Section : 48 : Access Control In snowflake

309. why row access policy? 337. Access-control introduction.

310. Segregation of duties 338. Objects and role hierarchy.

311. Mapping tables. 339. Default roles.

312. Dml operations 340. Creating database: Level1

313. Conclusion. 341. Creating database : Level2

Section : 46 : Tagging in snowflake 342. Creating database : Level3

314. Tagging in snowflake 343. Creating database : Level4

315. Create and apply tag 344. Creating database : Level5

316. Seggregation of duties 345. Managed schema introduction.

317. Prepare environment 346. Managed schema demo.

318. Applying tag 347. Building hierarchy introduction.

319. Tag based masking policy part1 348. Building hierarchy demo.

320. Tag based masking policy part2 349. Hierarchy for analyst.

321. Masking based on tag value. 350. Future grants.

322. Classification 351. SharedDB objects

323. Classification demo 352. Summary.

Section : 47 : Stored Procedures Section : 49 : Snowflake ORG account

324. Section introduction 353. Problem with access control

325. Stored procedure basics 354. Possible solution

326. Returning result from stored procedure 355. Ideal solution

327. Using control statements. 356. Snowflake org intro.

328. Using bind variables. 357. Creating accounts.

329. Table fill rate procedure. 358. Monitor

330. Error scenarios. 359. Snowflake orgad.s

331. Handling error scenarios.

332. Logging error messages. .

Section 50 : Disaster Recovery and
replication

361. Disaster recovery introduction

362. Replication

363. Setting up replication.

364. Database failover

365. Replication group intro

366. Replication group demo

367. Replication assignment.

368. Failure group demo

369. Snowflake connections intro

370. Snowflake connections demo

Section : 51 : Snowflake Best Practices

371. Best practice’s introduction.

372. Best practices while doing clone.

373. Best practice while creating database and

tables.

374. Best practice while using virtual

warehouse.

375. Best practice while using retention

period and time travel.

Section 52

376. Snowflake with spark.