# 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FGNx2tmv1xEhVormiMxqG%2F01-Creating-New-Project-ADWB.gif?alt=media&#x26;token=2f276eaf-b93e-4ea0-a05f-0882cb617817" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FKnUyPU9gaiJJ3t1yLFy7%2F02-Creating-DWB-Project-Shortcut.png?alt=media&#x26;token=2dee18b9-0127-47d6-866a-86aeb4a99e5e" 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2Fwp78wJjoZPpQaE4hQMOr%2F03-Save-Project.png?alt=media&#x26;token=c6c38455-27e3-47f1-9e3d-1c9d4dca6a58" 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FTa0XV8AKo3OuYzr8AiPO%2F04-New-Project-ProjectExplorer.png?alt=media&#x26;token=8829d715-4c1a-40f1-ad00-3a424c6dd908" 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F87vPVTog6OYIsp8KSAQr%2F05-Opening-Existing-Project-1619579656447.gif?alt=media&#x26;token=5a2a6e47-beeb-48b0-bb38-d5ac3387f0d7" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FtPH9fW4XcDDmFAYDM8fG%2F06-Existing-Project-ProjectExplorer.png?alt=media&#x26;token=8fe27f76-b61a-4b24-b4de-62bed53465cd" 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FXGUND6HBDhm3mpJP6Ruv%2F07-Opening-Existing-Data-Model.gif?alt=media&#x26;token=34e671ab-6ad4-4f23-90e6-81834e4b11b3" 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FFCctnQczpRyZNCkF5Jk3%2F08-Adding-Project-Item-Context-Menu.png?alt=media&#x26;token=5701b415-d51c-4f50-8813-9273e2cdb702" 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FWCMhsZaZo5MAELC4RAvx%2F09-Add-New-Data-Model.gif?alt=media&#x26;token=be426569-3fe4-437c-a663-e29e558b16c2" 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FD8PyiPazQDIH2AsFtb5D%2F10-Adding-New-Item-In-Project-1619583538813.gif?alt=media&#x26;token=4e52faff-ac41-40ab-92b5-eba04c7c7a45" 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FOJUgwrAQo56wp5pTG06s%2F11-Adding-Existing-Item.gif?alt=media&#x26;token=6fc4df56-c458-4efe-9e74-ab0fb56516e9" 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.
