Warehouse Overview

A warehouse is typically designed as a final storage location. In the context of Toric, a Data Warehouse is a physical instance of a database that is deployed and managed by the company. The purpose of a Data Warehouse is to store final, clean data that can be used for reporting or syncing.

Toric Data Warehouses offer users control over deployment region and backup region, including US, APAC, and EMEA regions. With Data Warehouses, users can create tables with custom schemas that support primary keys, dates, currencies, numbers, units of measure, lists, booleans, and even BIM models. Like data tables, Data Warehouses can be read and written from flows using the Write to Warehouse, Select, Distinct, and Summarize nodes.

Steps to create a Warehouse:

1. Log in to your Organization
2. Click on “Data Warehouses” on the left side menu
3. Click on Create New Warehouse
   1. Add a Warehouse Name
   2. Pick the region you want
   3. Pick your Backup Region
   4. Click on “Create Warehouse”

https://www.loom.com/share/97bfcb4553f24819844868a4ed59b031

Data in warehouses is stored by creating tables. When creating a new warehouse, you have the option to create a data table by clicking on "Create Table."

To create a table in the warehouse, follow these steps:

1. Add a table name.