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