What is a Data Table?

Data Tables are shared tables used to process data in-flight. For example, when building replication or reconciliation workflows, it is useful to write IDs on a table to cross-reference data and determine fields that need to be rewritten to our final destination. Data tables can be used within flows for read-write operations, select, distinct, and summarize nodes.

In summary, a Data Table is a database that users can utilize to aggregate data from different sources in Toric. Users can define the structure of individual tables, including column names, data types, and primary key definitions.

Creating a Data Table

Steps to create a Data Table:

1. Log in to your Organization
2. Click on “Data Tables” on the left side menu
3. Click on Create New Table
   1. Add a Table Name
   2. Add the columns you need
   3. Select Primary Keys
   4. Select the Permissions desired
   5. Click on “Create Table”

https://www.loom.com/share/40d1f55768ee4e16a3df88a89f1804e4

Why do we need Data Tables?

Data Tables help users combine information into one place, whether that may be from different Projects, different Versions of the same Project, or different type of sources.