All About Write To Warehouse

Overview

Write transformed data to any warehouse of your choice.

1. Add Write to Warehouse in Your Dataflow

2. Write to Warehouse Options

‍

1. Add Write to Warehouse in Your Dataflow

Add Write to Warehouse to any node in your Dataflow. Select any node and use the Transform (+) button to open the list of options to select Write to Warehouse. You could work with the node in the Dataflow tab or use the Properties panel.

‍

2. Write to Warehouse Options

Write to Warehouse is composed of three sections. Select where to send your data, map data to columns in your data tables, and write the data to your warehouse.

2.1 Select Destination

Use the first dropdown to choose a warehouse.

2.2 Data Mapping

The second section maps data from Toric to your data warehouse. Use the dropdowns to the right of each columns to choose which data to write for each respective table column.

‍

The dropdown options are type-sensitive. In the example below, the my_varchar column can only accept data that is a string (i.e., text); therefore, the dropdown will only show data that are strings.

Note: This section will vary depending on how many columns are in your tables.

‍

‍

2.2 Write Data

There are two options for writing data. First, you may check the box Always Write, which will automatically write to your warehouse if the upstream data is updated. Otherwise, you could use the Write Now button to write to a warehouse manually.

Note: Upstream data is connected to a node input.

‍

Here is what it looks like to write sample sales data to a MySQL instance hosted in Google SQL.

‍

‍

Next steps

Node Glossary