Hyper Parser
In this article
Overview
You can use this Snap to parse Tableau extract (hyper) file and convert it into documents.
Prerequisites
Tableau Hyper 10.25 or later version.
To run the Tableau hyper Pipelines in a plex, you must set the environment or system property
TABLEAU_HYPER_LIBS
to hyper (excluding hyper folder) where thejcc
is running.Tableau Hyper Snaps use Tableau Hyper API version 21.0.0.12982. You must have the Java Native Access (JNA) and shared libraries of the same API version for the respective Operating System on which you are running your Tableau Pipelines. You can download the files for your operating system (Windows and Linux) using this link: https://www.tableau.com/support/releases/hyper-api/0.0.12982.
Support for Ultra Pipelines
Works in Ultra Pipelines.
Limitations
None.
Known Issues
None.
Snap Input and Output
Input | Document |
|
| Data in document format. |
Output | Binary |
|
| Document in binary format. |
Snap Settings
Label* | None. | Specify the name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your Pipeline. Default Value: Hyper Parser |
Schema Name | N/A | Specify a schema name for the Tableau extract. If left empty, the Snap uses the default schema name Extract. Default Value: Extract |
Routes | Use this field set to define table names and the output views to send documents. You must specify each route in a separate row. Click + to add a new row. This field set consists of the following fields:
| |
Table Name | N/A | Specify a name for the hyper table. A table must exist in the incoming data of the hyper file. Else, an error is displayed upon validation. |
Output view name | N/A | Specify a name for the output view to which the documents should be routed. |
Example
Reading And Parsing Tableau Hyper Data
This example Pipeline demonstrates reading and parsing Tableau Hyper data using Tableau Hyper Formatter and Hyper Parser Snaps.
First, we configure the JSON Generator and CSV Generator Snaps to pass JSON and CSV data. Upon validation, we get the JSON and CSV data respectively in the output preview of the Snaps.
|
|
CSV Generator Snap | CSV Generator Output |
Next, we configure the Hyper Formatter Snap to transform the JSON and CSV output into hyper extract format. We configure two input views, json_data and csv_data—this creates target tables with the same names in the Hyper database of Tableau.
|
|
Next, we configure the Hyper Parser Snap to parse the transformed Hyper data into two tables, one each for json_data and csv_data. Upon validation, we get JSON and CSV outputs in the two output previews.
| |
Hyper Parser JSON Output | Hyper Parser CSV Output |
|
|
Finally, we configure two Mapper Snaps to transform the incoming JSON and CSV data. Upon validation, we get the output data for each format (JSON and CSV).
| |
Mapper -JSON Data Output | Mapper - CSV Data Output |
|
|