Output Data Tool
Use the Output Data tool to write results of a workflow to supported file types or data sources.
Select the Output Data tool in the palette, and drag it onto the workflow canvas.
Tool Components
 |
Figure: Output Data tool with anchor.
The Output Data tool has 1 anchor.
Input anchor: Connect the input anchor to your workflow to write your workflow results to a data source or a supported file type.
Configure the Tool
Save to Snowflake
To write the results of your workflow to Snowflake:
From the tool configuration window, select Select Output Location to open the Output Data window.
Select a cloud data connection from Connections or select from your Existing Datasets.
Enter a Table Name. Optionally, select the {x} (Add parameter) icon to add parameters to your Table Name. For details, refer to Parameters section.
Next, select a schema where you want to save your table and then select Next.
Use the Output Actions on Every Run dropdown to select an action to perform if a table with the same name exists at the moment of the job run.
Create New Table: Creates a new table.
Append to a Table: Data is appended at the end of the existing table.
Truncate Existing Table: The existing table data is deleted and replaced with new data.
Drop Existing Table: The existing table is dropped and replaced by the new table.
Merge with Existing Table: Output data is merged with the existing table.
Select Confirm to save your output data details. You can then review your selection in the Output Data tool configuration panel and use the pencil icon to make changes if needed.
Select Run Job to your workflow and save your file to the chosen connection.
Parameters
Use Parameters to apply dynamic String or Timestamp values to your output data. You can apply parameters to the Table Name.
String parameters have a default value that can be overwritten for each job execution, in a schedule, or Plan.
Timestamp parameters are automatically populated with a formatted timestamp at the time of job execution.
To use a parameter in the Table Name...
In the or Table Name field, select the {x} (Add parameter) icon to open the Parameters window.
If you previously created a parameter, select it from the Workspace Parameters section. Note that the parameters are inserted at your cursor location in the File Name field. To remove a parameter from your file name, select the parameter and then select Remove.
If you need to create a new parameter, select + New. You can also select the Manage Parameters link to launch the Parameters page, where you can create new parameters and edit existing ones.
Create String Parameter
Use a String parameter to dynamically label your output data.
To create a string parameter, select + New from the Parameters window and then select String from the Type dropdown.
Enter a parameter Name. This is what shows in the file name field if you use the parameter.
Enter a Description. This should be something clear that will help you and other users in the future.
Enter a Default value for the parameter. This value is used if the parameter isn't dynamically updated.
Select Create to create the parameter and add it to the name or path. To remove a parameter, select the parameter and select Remove.
Create Timestamp Parameter
Use a Timestamp parameter to automatically populate a formatted timestamp at the time job execution.
Note
Unlike String parameters, Timestamp parameters aren't stored on the Parameters page.
To create a Timestamp parameter, select + New from the Parameters window and then select Timestamp from the Type dropdown.
Customize the Timestamp Format as needed. The default format is yyyy-MM-dd. Select the + button to view your customization options. The Format Preview displays today's date using your selected format.
Next, set the Timestamp Value. Choose from...
Exact at Job Start: Outputs the exact timestamp value when the job starts.
Relative to Job Start: Output the timestamp relative to the Job Start time. For example, you might want a timestamp 1 hour after the Job Start time.
Occurrence: Choose to output a timestamp that is either After or Before the Job Start time.
Value: Choose a numerical value for your relative timestamp.
Unit: Choose a unit for your relative timestamp. Your options include:
Minutes
Hours
Days
Weeks
Months
Quarters
Years
Next, select a Timezone for your timestamp parameter.
Last, select Create to create the parameter and insert it at the your cursor position.
Override Parameters
When you run your workflow with String parameters, the workflow uses the default value specified when you created the parameter. However, you have the option to override this value.
To override the default value for String parameters...
Select the dropdown icon that's part of the Run Job button.
Select Parameters to open the Override Parameters window.
Enter override values into the Value Override column for all parameters where you don't want to use the default.
Select Save and Run Job to run your workflow with the updated parameter values.