Snowflake DWH: Creating Database & Table

  • Published
  • Posted in Blog
  • Updated
  • 1 min read

Hello readers, in my previous blog we’ve discussed what is Snowflake DWH and how to create a data warehouse in it. In this blog, we will see how to create a database and a table within the database.

Let’s get started…

Step 1– From top ribbon, click on databases.

Step 2– Once we are at database section, click on create.

Now, you will see a dialog box asking for database details like name of the database and comment(optional).

After providing required details, click on finish to create the database

We have our database ready. Now, let’s create a table with the database.

Step 1– Select the database where you want to create a table.

Step 2– Now, click on create option

Once you are done with the table definition, click on finish.

This is all about creating a database and a table within the database in Snowflake. In my next blog, we will see how to load the data into snowflake table.

Thank you for reading this blog. I hope you will find this blog helpful.

Gaurav Lakhotia
Data Analyst
Addend Analytics

Addend Analytics is a Microsoft Gold Partner based in Mumbai, India, and a branch office in the U.S.

Addend has successfully implemented 100+ Microsoft Power BI and Business Central projects for 100+ clients across sectors like Financial Services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Switzerland, and Australia.

Get a free consultation now by emailing us or contacting us.