Add a virtual table output [Beta]

Beta

Virtual table outputs in Pipeline Builder are in the beta phase of development and may not be available on your enrollment. Functionality may change during active development.

You can choose to add a virtual table output in Pipeline Builder to guide your pipeline integration towards clean, transformed data that is stored outside of Foundry. Learn more about different output types.

Create a virtual table output

First, select Add next to the virtual table type in the outputs panel to the right of the graph.

Output types

Next, select the source to which you would like to write your new table. Sources that have already been used in your pipeline (for example, any input virtual table's associated sources) will show up under Sources in this pipeline for ease of use. You will only be able to select source types currently supported by virtual tables.

Screenshot of setting virtual table external location

Configure the external location. Follow the source documentation and any requirements listed there for configuring where virtual tables will be stored in the source type you have chosen.

From here, you can follow the same steps as adding a dataset output, though please note that configuring write modes and write formats are not supported for virtual tables.