# Warehouse & Storage Setup

This document provides the steps involved in configuring a Data Warehouse and Storage on Sprinkle.

**Why integrate a Data Warehouse** :question:

* All analytical data is stored and queried from the Data Warehouse

**Why connect a Cloud Storage Bucket** :question:

* Sprinkle stores all intermediate data and report caches in this bucket

### Watch Video :tv:

{% embed url="<https://youtu.be/lq1aM1ta0Eg>" %}
Warehouses : Explanation & Feature Walkthrough
{% endembed %}

:arrow\_right: To Set up a warehouse and related storage bucket, navigate to Admin from the left navigation menu. Browse to the Warehouse page.

Admin -> Warehouse

:mouse\_three\_button:Click on the <mark style="color:purple;">**+ New Warehouse Connection**</mark> button to integrate a warehouse with Sprinkle.

### :tools: Steps to create a New Warehouse Connection

#### :digit\_one: Connect Warehouse

In the first step, you configure your warehouse by providing endpoint details of your Data Warehouse.

Refer to individual [Cloud Data Warehouse](https://docs.sprinkledata.com/product/integrating-your-data/destination-warehouses) pages for details on the fields in the form. The integration document has also been integrated alongside on the UI for you to refer.

**Test Connection**: It tests if a connection can be established with the warehouse endpoint provided. Clicking the button also shows the status, Failed or Passed.

**Test & Save**: This button tests the warehouse connection as well as saves the warehouse endpoints provided.

#### :digit\_two: Add Storage

Here you can provide details of your storage bucket to be associated with the warehouse configured. Test Connection and Test & Save buttons have similar functionality as discussed above.