Warning: Extra caution should be taken when configuring the output step so that any existing source data does not get accidentally overwritten. The output to database step has a variety of options such as dropping tables, truncating (deleting) data, adding new rows, and updating existing data. It is recommended that a test database is used when developing transformation flows. Further, the output step is disabled by default when in edit mode (see Run in Preview mode option).
Extend the output step panel by hovering on its icon, and drag an output step onto the canvas.
Next, connect the transformation step to the output step as mentioned above (part 2, steps 3 and 4).
Then configure the output step through the panel on the right-side. Click here to learn more about configuring this step.
You can also view the flow’s status in the run logs tab in the flow panel.
Click on the run button in the top header menu to execute the flow. Each step will process the number of rows that has been configured for the preview panel (with the max. limit being 200), or until it runs out of data, or if it processes an error. By default, any output to database step will not be run. This behaviour can be overridden by enabling the Run in Preview mode option in the output step configuration panel. This should only be done subject to the warnings listed earlier on this page.
