Snowflake DWH: Creating Database & Table

  • Post category:General
  • Post author:

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.

Addend Analytics is a Microsoft Power BI Gold Partner based in Mumbai, India. Apart from being authorized for Power BI implementations, Addend has successfully executed Power BI 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 at kamal.sharma@addendanalytics.com or Contact us

Gaurav Lakhotia
Data Analyst
Addend Analytics