Export to SBDF

This operator converts a tabular data set to the Spotfire Binary Data Frame (SBDF) format. The SBDF files are stored in the same workspace as the workflow and can be downloaded for use in TIBCO Spotfire®.

Information at a Glance

Note: This operator can only be used with TIBCO® Data Virtualization and Apache Spark 3.2 or later.

Parameter

 Description
Category Tools
Data source type TIBCO® Data Virtualization
Sends output to other operators No
Data processing tool TIBCO® DV, Apache Spark 3.2 or later

Input

An input is a single tabular data set.

Bad or Missing Values
Null and empty values in the inputs are converted to blank cells in the SBDF file.

Restrictions

By default, the custom operator can export only up to 10 GB of data. You can modify this limit in the alpine.conf file by setting the following configuration.

Note: Raising this limit might overload the memory reserved for TIBCO Data Science - Team Studio. 
custom_operator.sbdf_export.max_mb_input_size_alpine_server=10240

Configuration

The following table provides the configuration details for the Export to SBDF operator.

Parameter Description
Notes Notes or helpful information about this operator's parameter settings. When you enter content in the Notes field, a yellow asterisk appears on the operator.
File Name

Specify the name of the SBDF file stored in the TIBCO Data Science - Team Studio workspace. The .sbdf file extension should be omitted because the file extension is automatically appended to the file name.

Note: The File Name must be unique for each operator.
Description Enter a brief description of the SBDF file for the current workflow.
Overwrite? Specify whether to overwrite the SBDF file.

  • When set to Yes, the SBDF file is overwritten (If the SBDF file already exists with the same name). A new version of the SBDF file is created in the workspace, and previous versions are still accessible through the work file version-control option.

  • When set to No, the SBDF file is not overwritten. If the SBDF file of the same name already exists, the operator fails with an error message that notifies the user of the existing work file.

Output

Visual Output
  • Summary: A text field displaying the summary of the output file.
Output to successive operators
None. This is a terminal operator.

Example

The following example demonstrates the Export to SBDF operator.

Export to SBDF operator workflow.png
Data
golf: This data set contains the following information:
  • Multiple columns namely outlook, temperature, wind, humidity, and play.
  • Multiple rows (14 rows).
Parameter Setting
The parameter settings for the golf data set are as follows:

  • File Name: golf_sbdf_file

  • Description: SBDF file for the golf data set.

  • Overwrite?: Yes

Output
The following figure displays the result for the Export to SBDF operator.
Export to SBDF operator output - Summary tab