Read And Parse Tableau Hyper Data

This example pipeline demonstrates reading and parsing Tableau Hyper data using Tableau Hyper Formatter and Hyper Parser Snaps.

  1. Configure the JSON Generator and CSV Generator to pass JSON and CSV data.

    On validation, we get the JSON and CSV data respectively in the output preview of the Snaps.

    JSON Generator Snap Configuration JSON Generator Snap Output

    JSON Generator Snap Configuration


    JSON Generator Snap Output

    CSV Generator Snap Configuration CSV Generator Snap Output

    CSV Generator Snap Configuration


    CSV Generator Snap Output

  2. Configure the Hyper Formatter 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.

    Hyper Formatter Snap Configuration Hyper Formatter Views

    Hyper Formatter Configuration


    Hyper Formatter Views

  3. Configure the Hyper Parser to parse the transformed Hyper data into two tables, one each for json_data and csv_data.

    On validation, we get JSON and CSV outputs in the two output previews.

    Hyper Parser Snap Configuration Hyper Parser JSON Output Hyper Parser CSV Output

    Hyper Parser Configuration


    Hyper Parser JSON Output


    Hyper Parser CSV Output

  4. Configure two Mapper Snaps to transform the incoming JSON and CSV data.

    On validation, we get the output data for each format (JSON and CSV).

    Mapper Snap Configuration Mapper Snap Output

    Mapper Snap Configuration


    Mapper Snap Output

    Mapper Snap - CSV Data Mapper Snap - CSV Data Output

    Mapper Snap - CSV Data


    Mapper Snap - CSV Data Output

To successfully reuse pipelines:
  1. Download and import the pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Provide pipeline parameters as applicable.