Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай Snowflake – The Complete Masterclass, а также все другие курсы, прямо сейчас!
Премиум
  • Урок 1. 00:00:36
    Welcome!
  • Урок 2. 00:02:52
    Course Outline
  • Урок 3. 00:04:26
    How to benefit best from the course?
  • Урок 4. 00:04:34
    Sign up for free trial
  • Урок 5. 00:04:51
    Getting to know the interface
  • Урок 6. 00:08:00
    Snowflake architecture
  • Урок 7. 00:08:36
    Setting up virtual warehouses
  • Урок 8. 00:07:01
    Scaling policy
  • Урок 9. 00:07:42
    Exploring tables & databases
  • Урок 10. 00:05:13
    Loading data in snowflake
  • Урок 11. 00:07:11
    What is a data warehouse?
  • Урок 12. 00:03:58
    Cloud computing
  • Урок 13. 00:04:50
    Snowflake editions
  • Урок 14. 00:08:47
    Snowflake pricing
  • Урок 15. 00:06:10
    Consumption of credits
  • Урок 16. 00:05:58
    Roles in snowflake
  • Урок 17. 00:02:45
    Loading methods
  • Урок 18. 00:03:37
    Understanding stages
  • Урок 19. 00:06:57
    Creating stage
  • Урок 20. 00:07:16
    COPY command
  • Урок 21. 00:07:59
    Transforming data
  • Урок 22. 00:05:14
    More transformations
  • Урок 23. 00:13:00
    Copy options & ON_ERROR
  • Урок 24. 00:12:36
    File format object
  • Урок 25. 00:02:54
    Summary
  • Урок 26. 00:01:21
    Understanding copy options
  • Урок 27. 00:06:17
    VALIDATION_MODE
  • Урок 28. 00:07:10
    Working with rejected records
  • Урок 29. 00:03:07
    SIZE_LIMIT
  • Урок 30. 00:02:23
    RETURN_FAILED_ONLY
  • Урок 31. 00:03:38
    TRUNCATECOLUMNS
  • Урок 32. 00:02:40
    FORCE
  • Урок 33. 00:05:00
    Load history
  • Урок 34. 00:02:12
    High-level steps
  • Урок 35. 00:03:50
    Our data
  • Урок 36. 00:03:47
    Creating stage & raw file
  • Урок 37. 00:04:49
    Parsing JSON
  • Урок 38. 00:07:02
    Handling nested data
  • Урок 39. 00:08:15
    Dealing with hierarchy
  • Урок 40. 00:03:10
    Insert final data
  • Урок 41. 00:10:26
    Querying PARQUET data
  • Урок 42. 00:04:09
    Loading PARQUET data
  • Урок 43. 00:04:24
    Performance in Snowflake
  • Урок 44. 00:04:54
    Create dedicated virtual warehouse
  • Урок 45. 00:06:44
    Implement dedicated virtual warehouse
  • Урок 46. 00:03:31
    Scaling up
  • Урок 47. 00:07:01
    Scaling out
  • Урок 48. 00:01:46
    Caching - Theory
  • Урок 49. 00:04:43
    Maximize Caching
  • Урок 50. 00:08:37
    Clustering - Theory
  • Урок 51. 00:05:51
    Clustering - Pracitice
  • Урок 52. 00:02:24
    Sign up for free trial
  • Урок 53. 00:03:40
    Creating S3 bucket
  • Урок 54. 00:03:54
    Upload files in S3
  • Урок 55. 00:05:32
    Creating policy
  • Урок 56. 00:07:55
    Creating integration object
  • Урок 57. 00:06:57
    Loading from S3
  • Урок 58. 00:10:54
    Handle JSON
  • Урок 59. 00:04:03
    Sign up for free trial
  • Урок 60. 00:05:04
    Create a storage account
  • Урок 61. 00:03:33
    Create a container
  • Урок 62. 00:08:31
    Create integration object
  • Урок 63. 00:02:39
    Create stage object
  • Урок 64. 00:04:35
    Load CSV file
  • Урок 65. 00:07:29
    Load JSON file
  • Урок 66. 00:02:32
    Sign up for free trial
  • Урок 67. 00:03:25
    Create a bucket
  • Урок 68. 00:04:16
    Create integration object
  • Урок 69. 00:02:03
    Create stage
  • Урок 70. 00:03:41
    Query & load data
  • Урок 71. 00:05:07
    Unload data
  • Урок 72. 00:02:46
    What is Snowpipe?
  • Урок 73. 00:02:21
    High-level steps
  • Урок 74. 00:03:51
    Creating stage
  • Урок 75. 00:03:30
    Creating pipe
  • Урок 76. 00:05:50
    Configure pipe & notifications
  • Урок 77. 00:09:13
    Error handling
  • Урок 78. 00:07:53
    Manage pipes
  • Урок 79. 00:09:59
    Using time travel
  • Урок 80. 00:10:50
    Restoring data
  • Урок 81. 00:08:36
    UNDROP tables
  • Урок 82. 00:07:02
    Retention time
  • Урок 83. 00:04:08
    Time travel cost
  • Урок 84. 00:05:03
    Understanding Fail Safe
  • Урок 85. 00:05:39
    Fail Safe storage
  • Урок 86. 00:09:00
    Different table types
  • Урок 87. 00:05:47
    Permanent tables & databases
  • Урок 88. 00:07:09
    Transient tables & databases
  • Урок 89. 00:05:15
    Temporary tables & databases
  • Урок 90. 00:05:41
    Understanding Zero-Copy Cloning
  • Урок 91. 00:03:37
    Cloning tables
  • Урок 92. 00:05:11
    Cloning schemas & databases
  • Урок 93. 00:05:12
    Cloning with time travel
  • Урок 94. 00:04:37
    Swapping tables
  • Урок 95. 00:03:14
    Understanding data sharing
  • Урок 96. 00:07:53
    Using data sharing
  • Урок 97. 00:05:25
    Create share through the interface
  • Урок 98. 00:02:11
    Sharing with non-snowflake users
  • Урок 99. 00:04:46
    Creating a reader account
  • Урок 100. 00:04:32
    Creating a database from share
  • Урок 101. 00:04:24
    Set up users for share
  • Урок 102. 00:05:06
    Sharing database & schema
  • Урок 103. 00:07:35
    Secure vs. normal view
  • Урок 104. 00:03:01
    Sharing a secure view
  • Урок 105. 00:03:25
    Why data sampling?
  • Урок 106. 00:02:53
    Methods of data sampling
  • Урок 107. 00:07:16
    Sampling data: Hands-on
  • Урок 108. 00:01:30
    Understanding tasks
  • Урок 109. 00:05:05
    Creating tasks
  • Урок 110. 00:06:23
    Using CRON
  • Урок 111. 00:02:19
    Understand tree of tasks
  • Урок 112. 00:06:09
    Creating trees of tasks
  • Урок 113. 00:04:48
    Calling a stored procedure
  • Урок 114. 00:06:09
    Task history & error handling
  • Урок 115. 00:04:57
    Tasks with condition
  • Урок 116. 00:07:23
    Understanding streams
  • Урок 117. 00:08:01
    INSERT operation
  • Урок 118. 00:06:49
    UPDATE operation
  • Урок 119. 00:05:08
    DELETE operation
  • Урок 120. 00:08:18
    Process all data changes
  • Урок 121. 00:05:05
    Combine streams & tasks
  • Урок 122. 00:06:12
    Types of streams
  • Урок 123. 00:05:50
    Changes clause
  • Урок 124. 00:02:24
    Understand materialized views
  • Урок 125. 00:06:07
    Using materialized views
  • Урок 126. 00:03:27
    Refresh materialized views
  • Урок 127. 00:02:45
    Maintenance costs
  • Урок 128. 00:04:52
    When to use materialized views
  • Урок 129. 00:01:48
    Limitations
  • Урок 130. 00:01:46
    Understanding data masking
  • Урок 131. 00:06:09
    Creating a masking policy
  • Урок 132. 00:06:35
    Unset & replace policy
  • Урок 133. 00:02:30
    Alter an existing policy
  • Урок 134. 00:05:48
    Real life examples
  • Урок 135. 00:06:46
    Key concepts
  • Урок 136. 00:03:18
    Roles overview
  • Урок 137. 00:02:57
    ACCOUNTADMIN
  • Урок 138. 00:05:57
    ACCOUNTADMIN in practice
  • Урок 139. 00:00:44
    SECURITYADMIN
  • Урок 140. 00:05:43
    SECURITYADMIN in practice
  • Урок 141. 00:01:27
    SYSADMIN
  • Урок 142. 00:06:51
    SYSADMIN in practice
  • Урок 143. 00:01:30
    Custom roles
  • Урок 144. 00:05:00
    Custom roles in practice
  • Урок 145. 00:01:18
    USERADMIN
  • Урок 146. 00:03:16
    USERADMIN in practice
  • Урок 147. 00:01:45
    PUBLIC
  • Урок 148. 00:01:19
    Data Visualization
  • Урок 149. 00:02:56
    Download & install Power BI
  • Урок 150. 00:06:11
    Connect Power BI & Snowflake
  • Урок 151. 00:03:03
    Working in Power BI
  • Урок 152. 00:01:54
    Download & install Tableau
  • Урок 153. 00:04:33
    Connect Tableau & Snowflake
  • Урок 154. 00:02:34
    Connecting to other tools
  • Урок 155. 00:03:14
    Connect to ETL tool
  • Урок 156. 00:01:41
    Best practices
  • Урок 157. 00:05:11
    Virtual warehouses
  • Урок 158. 00:06:25
    Table design
  • Урок 159. 00:05:12
    Monitoring
  • Урок 160. 00:03:48
    Retention period