# 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://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FIut89YlWocIJ5eSXn886%2F01-Creating-New-Project-ADWB.gif?alt=media&#x26;token=1185c809-717d-40c2-b9b3-672924838366" alt=""><figcaption></figcaption></figure>

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

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FwhlOsGoym7jrOf6Ih1bN%2F1.png?alt=media)

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

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

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2F88g9YSfBQs8F8LGE59hS%2F2.png?alt=media)

* 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.

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FSYg5SUBGVPoa2cHp672O%2F3.png?alt=media)

* 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*.

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FmsudKecP3eOaz6S5lTJZ%2F05-Opening-Existing-Project-1619579656447.gif?alt=media\&token=88c04b74-05a9-4b7c-8c88-579204a0abc8)

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

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FijGWQWNbE2HMUoYOJ0S8%2F5.png?alt=media)

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.

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FbTpO8axxqfItrIudLXc5%2F07-Opening-Existing-Data-Model.gif?alt=media\&token=d0b28326-895c-4ed0-8dc6-00775b6a0ad3)

## **Adding Items to a Data Warehousing Project**

You can add different new or existing items to 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 will open.

![](https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FEtEdJ688EHLMWq4TqYQh%2F7.png?alt=media)

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

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

<figure><img src="https://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FMDov5HkQOVdcU7xAb9zp%2F09-Add-New-Data-Model.gif?alt=media&#x26;token=e2aeba46-b167-440e-bd69-92dc02f96196" 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://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2FLPzHYu9HTCMHJLqKczp1%2F10-Adding-New-Item-In-Project-1619583538813.gif?alt=media&#x26;token=4ffa2cb8-66c5-4016-89e7-2d886a525fe3" 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://3891069449-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F28dJIkGHacXhBlux3efx%2Fuploads%2F1O1O07Yahiy2hq47rVsy%2F11-Adding-Existing-Item.gif?alt=media&#x26;token=7df7090e-4b2d-4b3b-85e3-2a118d24c0e4" 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.
