Write transformed data to any warehouse of your choice.
1. Add Write to Warehouse in Your Dataflow
2. Write to Warehouse Options
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.
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.
Use the first dropdown to choose a warehouse.
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.
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.