--- title: "Data Warehouse" slug: "data-warehouse" updated: 2021-09-23T22:39:51Z published: 2021-09-23T22:39:51Z canonical: "docs.visualvault.com/data-warehouse" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.visualvault.com/llms.txt > Use this file to discover all available pages before exploring further. # Data Warehouse ## Purpose --- This article will provide instructions on how to create, modify, search and delete Data Warehouses on the Process Design Studio tool. ## Definition --- Data Warehouse is a tool for storing your data tables. This can be created based on the information collected from Events or by uploading a CSV file. ## Create --- In order to create a new Data Warehouse, click on the **+ New Table** button. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47043064321/original/KIF7QNNx9LCRWhslGlqL6_mF4t7zKX-DSQ.png?1603226472) ### Settings --- Add a **Name** and **Description** of your new Data Warehouse. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47054224067/original/_AfqlE1Rlm5KnpcQK4rfl4MdeYYJNjCb2A.png?1610542612) Select the Event Source you would like to generate your Data Warehouse. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47048704996/original/MNQpHO9DkKbJM4JbL7z2JaVDxnL2RniEmA.png?1606833434) **Fields included** and **Metadata fields** (Additional & Optional) will be auto-populated with the Event's configuration and cannot be modified. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47055300168/original/Y-MX0AzkfN1KeITujOrl9IS8p2tXno5luw.png?1611159529) Select one or more Business Processes to associate the Data Warehouse with. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47048705042/original/m4NSWm2bnVFiU-X7911otLN2mJCZpXTsHg.png?1606833452) The Import Data section will allow you to upload a CSV file of data to your Table. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47048705116/original/hWWe5qcJcwaGm_VrfNYBDdLZ39zEzUKaEQ.png?1606833469) - **Append Existing Data**: Use this option if would like to upload new data but without losing the data previously collected. - **Overwrite Existing Data**: Use this option if you would like to delete all previously stored data and preserve only the data you are uploading. - **Separator**: Use this section to specify which symbol you are using on your CSV file for separation. ### Permissions --- This tab will allow you to configure the permissions that user groups have for the Data Warehouse. - All groups will be listed on the left side. Select the group you would like to grant access to and click on the role to be assigned. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47054304147/original/vZFtgeQOaLcWWcnp6vQcFRqEyz4H9HnWOA.png?1610567211) - Each group granted with any level of access will appear on the right list, under Assigned groups. Their respective permission level is shown on the right side of this list. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47054305380/original/qQA3KEqKa5qQNXABIdhCbD09bWi9suWdqA.png?1610567694) - Any groups selected will be grayed out from the left-hand list. Any group can be removed by selecting its list item and clicking on Remove Selected. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47054305640/original/yZLTv7JfJEans8HHACR8NvxSgYNMKc0mVQ.png?1610567777) --- Once all fields are completed, click on **Create** for confirmation of the Data Warehouse creation or **Cancel** for discarding changes. In both cases, you will be redirected to the Events page. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47054224592/original/hXb1JIGmUpFQNYwjHvQqzBzFupT9acQddg.png?1610542771) ## Modify --- For modifying a Data Warehouse, find the item on the list and click on the pencil icon on the right side of the line. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47043064501/original/Qp5ETPnkiw_d3PbNBSMSDeYDHIKzk_kA2Q.png?1603226576) - The only fields allowed for modifications are Table Name, Description, Related Business Processes and Import Data. - If the item has a padlock icon on the left side, it means the Data Warehouse is being used by a Data View and/or a Data Model. Also on the Edit view, there is a **Data Preview** tab that will allow you to overview the data stored on that Table. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47054230116/original/ccXavBOgOLpYQulMY4abaB71_vKXtPFNxw.png?1610544314) - The search box on the top right will allow you to find specific data on the Table. ## Search --- When using the search box on the top left of the screen, the page searches for the text under Table Name as well as under Description. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47043064517/original/2sn_46jSjgzoDDjuF73leSo_TwoIO2exUQ.png?1603226604) ## Delete --- In order to delete a Data Warehouse, select the item on the list and then click on the Delete Table on the top right of the screen. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47043064580/original/gNjuZHNbaf7CVlswfS04ybquxADkFbTW2Q.png?1603226627) You will be prompted to confirm the deletion and then redirected to the Data Warehouse page. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/47048706123/original/Wnpu8xhnRRMHv3A0ecLRVw-w9cbW4rfpEQ.png?1606833768)