> ## Documentation Index
> Fetch the complete documentation index at: https://help.elationhealth.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Creating a Custom Database

You can create custom tables in Snowflake which will allow you to aggregate data from your master database to analyze and run reports. For more information check out the Snowflake documentation [https://docs.snowflake.com/en/sql-reference/sql/create-table](https://docs.snowflake.com/en/sql-reference/sql/create-table)

**Step 1: Create your database**

1. On the left hand navigation bar click on **Data > Database.**
2. On the top right hand corner click on the **Blue Database button**

<img src="https://mintcdn.com/elationhealth/aqLVKRo1Jpffmnwl/images/reference/snowflake-create-database-button.png?fit=max&auto=format&n=aqLVKRo1Jpffmnwl&q=85&s=b4dd3c6e5ea69a5bff6929219d4c47a8" alt="" width="3564" height="1278" data-path="images/reference/snowflake-create-database-button.png" />

**Step 2: Name your database and give it an optional comment**

<img src="https://mintcdn.com/elationhealth/aqLVKRo1Jpffmnwl/images/reference/snowflake-create-database-form.png?fit=max&auto=format&n=aqLVKRo1Jpffmnwl&q=85&s=3c0d2792b6d1e0a33b0c23ded6f8e4eb" alt="" width="1488" height="816" data-path="images/reference/snowflake-create-database-form.png" />

Click on the **Create button** once you are finished

**Step 3: Create a Schema**

1. Once the Database has been created you will see it on the left hand navigation along with your other database(s)
2. Click on the newly created Database then click on the blue Schema button on the top right hand side of the page.
3. Give your Schema a name and hit the create button

<img src="https://mintcdn.com/elationhealth/aqLVKRo1Jpffmnwl/images/reference/snowflake-create-schema-button.png?fit=max&auto=format&n=aqLVKRo1Jpffmnwl&q=85&s=12f44f73e3dec214f9ff7ced6ac38a65" alt="" width="3086" height="1000" data-path="images/reference/snowflake-create-schema-button.png" />

<img src="https://mintcdn.com/elationhealth/aqLVKRo1Jpffmnwl/images/reference/snowflake-create-schema-form.png?fit=max&auto=format&n=aqLVKRo1Jpffmnwl&q=85&s=a8f28d046fd82e641c350ed7d29a8676" alt="" width="1302" height="900" data-path="images/reference/snowflake-create-schema-form.png" />

**Step 4: Create your table**

1. Click on your newly created Schema
2. On the top right hand side corner of your screen click on the Blue Create button
3. Click on table then the appropriate option.

<img src="https://mintcdn.com/elationhealth/aqLVKRo1Jpffmnwl/images/reference/snowflake-create-table-menu.png?fit=max&auto=format&n=aqLVKRo1Jpffmnwl&q=85&s=19ab990508c7d3f0d23cb18f189a50ab" alt="" width="3088" height="1024" data-path="images/reference/snowflake-create-table-menu.png" />

For this example we will be choosing **Table** > As **Select**

This will take you to a new worksheet Pick your warehouse > Enter the criteria for you custom table > Click Create

<img src="https://mintcdn.com/elationhealth/c_0GuvXN24rkf1qg/images/reference/snowflake-worksheet-select-warehouse.png?fit=max&auto=format&n=c_0GuvXN24rkf1qg&q=85&s=080f1e30dc2a4ca82fe851cc9b5a4b80" alt="" width="2884" height="994" data-path="images/reference/snowflake-worksheet-select-warehouse.png" />

Enter the criteria for your new table and click Create Table

Make sure to reference your main hosted database and schema's full path

<img src="https://mintcdn.com/elationhealth/aqLVKRo1Jpffmnwl/images/reference/snowflake-create-table-criteria.png?fit=max&auto=format&n=aqLVKRo1Jpffmnwl&q=85&s=55a7099b07c833685b4645bdb3370a23" alt="" width="2878" height="610" data-path="images/reference/snowflake-create-table-criteria.png" />

You have successfully created a custom table

<img src="https://mintcdn.com/elationhealth/c_0GuvXN24rkf1qg/images/reference/snowflake-custom-table-results.png?fit=max&auto=format&n=c_0GuvXN24rkf1qg&q=85&s=fe1b00a5d6cedab901abc9ea04d76830" alt="" width="658" height="712" data-path="images/reference/snowflake-custom-table-results.png" />

If you have any questions please contact [Elation Support Portal](/articles/support-portal-introduction)
