# Data Warehouse

There are three alternative ways to connect data from your data warehouse: 

* **AI:** This is the preferred option and is often the simplest. Use this option when you would like the AI to assist in finding the correct data or doing light transformations of the data prior to working with it in your spreadsheet. See [getting-data-using-ai](https://docs.arcwise.app/using-arcwise-ai-analyst/getting-data-using-ai "mention") for using this option.
* **Data Catalog:** Use this option if you want to quickly connect a known table.
* **Connect Data:** Use this option to manually explore and search for tables.

{% hint style="info" %}
If your data is large the data in the sheet will be truncated to 100 rows. You can still work with this data, however! See [working-with-large-data](https://docs.arcwise.app/using-arcwise-in-sheets/working-with-large-data "mention").
{% endhint %}

{% tabs %}
{% tab title="Data Catalog" %}
1\) Navigate to the Arcwise icon at the top right corner of your sheet and click it.

<div data-full-width="false"><figure><img src="https://803372693-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlIfwCAQgoIa97JJYtlXQ%2Fuploads%2FgHwaBJYlEMhXjNjldXEF%2FScreenshot%202024-03-25%20at%2010.32.22%20PM.png?alt=media&#x26;token=f90e0c0b-e2d9-454f-9137-1c7f6393ea59" alt="" width="363"><figcaption><p>The Arcwise icon appears at the top right of your Google Sheet</p></figcaption></figure></div>

2\) From the command palette select **View all connect data** near the bottom.

<figure><img src="https://803372693-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlIfwCAQgoIa97JJYtlXQ%2Fuploads%2FrsapyZRIs308vyMLFxDi%2FScreenshot%202024-03-25%20at%2010.34.27%20PM.png?alt=media&#x26;token=487d58fd-d60d-4e25-a719-37485c4faeae" alt="" width="375"><figcaption></figcaption></figure>

3\) Select the **Data catalog** tab.

<figure><img src="https://803372693-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlIfwCAQgoIa97JJYtlXQ%2Fuploads%2FZVEGtvzmRqORQxsm320r%2FScreenshot%202024-03-25%20at%2010.56.05%20PM.png?alt=media&#x26;token=96944050-7cc1-4a43-b5c4-31f6381199fb" alt="" width="375"><figcaption></figcaption></figure>

4\) (Optional) If you have multiple data warehouses select the data warehouse you would like to pull data from.

5\) Select the schema the contains your table and then the table you would like to connect.

<figure><img src="https://803372693-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlIfwCAQgoIa97JJYtlXQ%2Fuploads%2FIKHs7ppOtidkMld1LjpO%2FScreenshot%202024-03-25%20at%2011.00.52%20PM.png?alt=media&#x26;token=5e5e5816-05b1-4dbd-9c28-c9c3ba6b9379" alt="" width="375"><figcaption></figcaption></figure>

6\) In the bottom right corner click the green **Connect** button.

<figure><img src="https://803372693-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlIfwCAQgoIa97JJYtlXQ%2Fuploads%2FT7vVOhodzUTgpMjnLHKL%2FScreenshot%202024-03-25%20at%2010.59.23%20PM.png?alt=media&#x26;token=629d1bfd-4c05-428e-8795-bca9cc87a02c" alt="" width="375"><figcaption></figcaption></figure>
{% endtab %}

{% tab title="Connect Data" %}
1\) Navigate to the Arcwise icon at the top right corner of your sheet and click it.

<div data-full-width="false"><figure><img src="https://803372693-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlIfwCAQgoIa97JJYtlXQ%2Fuploads%2FgHwaBJYlEMhXjNjldXEF%2FScreenshot%202024-03-25%20at%2010.32.22%20PM.png?alt=media&#x26;token=f90e0c0b-e2d9-454f-9137-1c7f6393ea59" alt="" width="363"><figcaption><p>The Arcwise icon appears at the top right of your Google Sheet</p></figcaption></figure></div>

2\) From the command palette select **Connect data** near the bottom.

<figure><img src="https://803372693-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlIfwCAQgoIa97JJYtlXQ%2Fuploads%2FrsapyZRIs308vyMLFxDi%2FScreenshot%202024-03-25%20at%2010.34.27%20PM.png?alt=media&#x26;token=487d58fd-d60d-4e25-a719-37485c4faeae" alt="" width="375"><figcaption></figcaption></figure>

4\) Click on the **Database** section.

<figure><img src="https://803372693-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlIfwCAQgoIa97JJYtlXQ%2Fuploads%2F9I43isDQ5wpnAyQn7c4n%2FScreenshot%202024-03-25%20at%2011.04.34%20PM.png?alt=media&#x26;token=7eecb012-bc3d-4802-afba-cdf0770e69dc" alt="" width="563"><figcaption></figcaption></figure>

5\) (Optional) search and use the navigation panel to find the data that is most relevant for your task.

6\) Select the table you would like to connect and click the green **Connect** button in the bottom right corner.

<figure><img src="https://803372693-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FlIfwCAQgoIa97JJYtlXQ%2Fuploads%2FoyPQ9RyTOVYZo4a8WsCX%2FScreenshot%202024-03-25%20at%2011.04.52%20PM.png?alt=media&#x26;token=df91ceed-0534-440c-8fd1-2108f16b53ef" alt="" width="563"><figcaption></figcaption></figure>
{% endtab %}

{% tab title="AI" %}
[getting-data-using-ai](https://docs.arcwise.app/using-arcwise-ai-analyst/getting-data-using-ai "mention")
{% endtab %}
{% endtabs %}