Learning ETL

    Category: Snowflake In General

    • Creating a Database and a Schema or Two

      ,

      While Snowflake comes with a good deal of sample data, let’s create our own sample database.  I’m going to call mine dbSample.  Note that the name of the database I have chosen describes what it is (a “sample” database) and starts with “db” so that anyone looking at the name can guess it is a…

    • The Quick And Dirty Snowflake Tour

      Snowflake is a multi-feature online data warehouse platform.  Like any other database platform (SQL Server, Oracle, MongoDB) there is a lot to learn, and more than once, I have found myself asking the question “Where is…?”  So I am going to concentrate on just a few areas. First, in the lower-left corner of the screen,…

    • Resource Monitors — Our First Order Of Business

      , ,

      I don’t plan to build anything large in Snowflake, because I don’t want to run up a big bill.  That said, I do recognize that I will incur some cost with my Snowflake enterprise subscription (and so will you.)  If you skipped the earlier post about cost, you can catch up here. A Resource Monitor…

    • Okay, Let’s Get Started!

      In order to access all the features of Snowflake that I would like to discuss, I am going to purchase an Enterprise plan.  At the time of this writing, the cost is $3.00 per credit.  I do not plan to do anything outrageously expensive, but just in case, I will configure my system to warn…

    • Welcome To Snowflake

      Hello!  My name is David.  I’ve been using Snowflake on and off for about a year now.  I would like to get to know it better, so I am blogging my experience.  I am glad you are joining me! Snowflake is great as a data warehouse for a variety of reasons.  First, unlike Oracle and…