Skip to main content

Database, table, and virtual warehouse are basic Snowflake objects required for most Snowflake activities. Setting them will be the first step in all our exercises! Let’s see how to do that!

Create a Snowflake account

Click here to create your new Snowflake account. It should be configured to use Amazon Web Services (AWS) and your user has the ACCOUNTADMIN role. In this way, you can create a database, tables, and virtual warehouse objects. You can use the 30-day free trial! But remember that everything will expire! So, please, save all! The exceeding £400 in credits can be another reason to lose everything before 30 days. Again, be careful! Working with a X-small warehouse is sufficient for our exercises.

Create your database and warehouse

By means of the CREATE (OR REPLACE) DATABASE stament we create our database. It includes automatically a SCHEMA, i.e. the PUBLIC one. If you want another one, you can CREATE (OR REPLACE) SCHEMA ‘myschema’ and your tables and views will be there!

--Create your database
CREATE OR REPLACE DATABASE mydatabase;

--Create your warehouse
CREATE OR REPLACE WAREHOUSE mywarehouse WITH
     WAREHOUSE_SIZE='X-SMALL
     SCALING_POLICY = STANDARD
     AUTO_SUSPEND = 120
     AUTO_RESUME = TRUE;

In the CREATE (OR REPLACE) WAREHOUSE statement we can add some object properties. By default we have a standard type warehouse. We can set the size of our warehouse. The bigger is the size, the bigger is the amount of compute resources in each cluster.. actually the bigger is the amount of money you “spend”! By deafult, the size of warehouse is XSMALL!

You can set the policy for the starting and shutting down cluster in a multi-cluster warehouse, especially when it is set in Auto-scale mode. There are two values: standard and economy. By default the valid value set is STANDARD. This just minimizes queuing by starting clusters.

As for the AUTO_SUSPEND property it declares the amount of seconds of inactivity before that the warehouse automatically suspends. By default the warehouse suspends after 10 minutes. If you set NULL, the warehouse never suspends.

If you want that your warehouse resumes automatically when a new query is submitted, you can set TRUE value to the AUTO_RESUME property. Generally, this statement is set to TRUE. You can add as many properties as you like, but read through the documentation about warehouses.

Create a table or a view

You can create a new TABLE into your schema or you can replace an existing one. Remember that there are several commands which are linked to CREATE TABLE. Be sure to select the one best suited for your needs. But keep things easy here:

Auteur

  • Sofia Pierini

    She is a critical thinker who draws inspiration from the intersection of logic, coding, and philosophy. She holds a Master's Degree in Philosophy and graduated as a Data Engineer from the Nimbus Intelligence Academy, earning certifications in Snowflake and dbt. Strong-willed and multifaceted, she has demonstrated competence in various interdisciplinary fields. As the Leader of the Italian Snowflake User Group and a founding member of the Snowflake Squad, she is deeply committed to fostering a strong and dynamic Snowflake Community. Her passion for technology and progress is evident in her innovative approach to problem-solving. She enjoys hardcore punk music and loves coffee.

Sofia Pierini

She is a critical thinker who draws inspiration from the intersection of logic, coding, and philosophy. She holds a Master's Degree in Philosophy and graduated as a Data Engineer from the Nimbus Intelligence Academy, earning certifications in Snowflake and dbt. Strong-willed and multifaceted, she has demonstrated competence in various interdisciplinary fields. As the Leader of the Italian Snowflake User Group and a founding member of the Snowflake Squad, she is deeply committed to fostering a strong and dynamic Snowflake Community. Her passion for technology and progress is evident in her innovative approach to problem-solving. She enjoys hardcore punk music and loves coffee.