# 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*.
Or you can use the following keyboard shortcut to open a new project.
* 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 %}
* 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.
* 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*.
The project will open in the *Project Explorer* on the right-hand side of the designer.
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.
## **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.
* 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*.
2. Select *Add New Item*. A new window will open with all the items. Select *DataModel*, specify its *Name*, and click *Add*.
* 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*.
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.
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://documentation.astera.com/astera-data-stack-v9/data-model/creating-a-data-warehousing-project.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
