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

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.

Data Catalog

1) Navigate to the Arcwise icon at the top right corner of your sheet and click it.

The Arcwise icon appears at the top right of your Google Sheet

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

3) Select the Data catalog tab.

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.

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

Connect Data

1) Navigate to the Arcwise icon at the top right corner of your sheet and click it.

The Arcwise icon appears at the top right of your Google Sheet

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

4) Click on the Database section.

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.

AI

Getting Data Using AI