# Creating a Data Warehousing Project

In this article, we will talk about how data warehousing projects work in Astera Data Stack. We’ll cover the following topics:

1\. Opening a New Data Warehousing Project

2\. Opening a Pre-Existing Data Warehousing Project

3\. Adding Items to a Data Warehousing Project

Let’s explore each one by one.

### Opening a New Data Warehousing Project

There are two ways to open a data warehousing project in Astera Data Stack. Let’s discuss each one by one.

1\. Go to the main menu bar *> Project > New > Data Warehousing Project*.

<figure><img src="https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/1lFVV3dz9o15pGVENtys/01-Creating-New-Project-ADWB.gif" alt=""><figcaption></figcaption></figure>

2\. Or, you can use the following keyboard shortcut to open a new project.

<figure><img src="https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/9dmFfo7ItQk3dkg0PWvP/02-Creating-DWB-Project-Shortcut.png" alt=""><figcaption></figcaption></figure>

* Once you open a new project, you will be required to save the project on a location of your choice. Specify the *File Name* and click *Save*.

{% hint style="info" %}
**Note:** Save the project in a new folder.
{% endhint %}

<figure><img src="https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/RKIF9g3zaR8wy4FGWDmv/03-Save-Project.png" alt=""><figcaption></figcaption></figure>

* Once the project is saved, it will open in Astera Data Stack in a *Project Explorer* window on the right-hand side of the designer.

<figure><img src="https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/oj52xOLHI8R8kUGxzW4b/04-New-Project-ProjectExplorer.png" alt=""><figcaption></figcaption></figure>

* You can now add project items to the project, such as *Data Models, Dataflows, Schedules, Shared Connections* and *Workflows*.

### Opening a Pre-Existing Data Warehousing Project

To open a pre-existing project, go to the main menu bar > *Project > Open*. Your local file directory would open in a new windowpane. Provide the path where the project exists in the *File Name* and click on *Open*.

<figure><img src="https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/M5amHHO6Y7bg05vqQaRE/05-Opening-Existing-Project-1619579656447.gif" alt=""><figcaption></figcaption></figure>

The project will open in the *Project Explorer* on the right-hand side of the designer.

<figure><img src="https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/yWQHuNuPyYRzIGpLGflk/06-Existing-Project-ProjectExplorer.png" alt=""><figcaption></figcaption></figure>

Now you can open project items such as *Data Models, Dataflows, Schedules, Shared Connections* and *Workflows* that exist in the project.

* To open a project item, expand the item node and select the item that you want to open.

  *Example*: To open an existing data model from the project, expand the *Data Model* node and select the data model you want to open.

<figure><img src="https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/MzOIdd3NrcWIWJvxgHZ3/07-Opening-Existing-Data-Model.gif" alt=""><figcaption></figcaption></figure>

### Adding Items to a Data Warehousing Project

You can add different new or existing items in the project, including *Data Models, Dataflows, Schedules, Shared Connections* and *Workflows*.

Let’s look at an example where we will add a new data model to a data warehousing project.

* Go to *Project Explorer > Project File > Data Models* and right click on it, a context menu would open.

<figure><img src="https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/AAegZInsw9pW5XNdnrF2/08-Adding-Project-Item-Context-Menu.png" alt="" width="416"><figcaption></figcaption></figure>

* Here, there are two ways to add a new data model:

1. Select *Add New Data Model* and a new data model designer would open. It would also show under the *Data Models* folder in the project explorer.

<figure><img src="https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/SFPQ97Du6yxd6Lw9UNYn/09-Add-New-Data-Model.gif" alt=""><figcaption></figcaption></figure>

2. Select *Add New Item*. A new window will open with all the items. Select *DataModel*, specify its *Name*, and click *Add*.

<figure><img src="https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/Vq9yDEbpbjZrVobNYV69/10-Adding-New-Item-In-Project-1619583538813.gif" alt=""><figcaption></figcaption></figure>

* To add an existing data model to the project, select *Add Existing Items*.

  A window would open where you can provide the path to the existing data model and add it to the project by clicking *Open*.

<figure><img src="https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/28C6jnlTGckoyH7SwM8F/11-Adding-Existing-Item.gif" alt=""><figcaption></figcaption></figure>

You can follow the same steps to add all the other items in a data warehousing project, including *Dataflows, Schedules, Shared Connections* and *Workflows*.

This concludes our discussion on creating a data warehousing project in Astera Data Stack.
