Configuring Tableau to Amazon QuickSight Conversion Stage

This topic provides steps to configure the Tableau to Amazon QuickSight conversion.

In Script Type, select Tableau.
In BI Assessments, select the report from the BI assessment you want to transform.

In Target Type, select Amazon QuickSight.
To store the transformed dataset in the QuickSight Spice mode, turn on the Spice toggle. Spice is an in-memory engine used to store extracted or generated reports or datasets. It auto-refreshes data in memory at a specified interval, which improves performance and allows data to load faster.
In Data Source, select the source database to fetch the data.
Select Data Configuration to configure the data for conversion.

In Source, select the data sources or workbooks you need to transform. To select the data sources or workbooks to transform, follow the steps below.

Select Data Source or Tableau Workbook.
Select the required data sources or workbooks from the Data Source or Tableau Workbook card.
Click to move the selected dashboards or workbooks to the Selected Data Source or Selected Tableau Workbook card.

To convert worksheets that are not used in the dashboard, turn on the Unused Worksheet Conversion toggle.
In Custom Properties, define key-value pairs to dynamically configure the custom property at runtime. To define custom properties, select the existing key-value pair from the dropdown or enter the property value manually.

The table below lists all custom properties along with the key-value pair.

Key	Definition	Value
S3 Bucket	Provide the S3 bucket details if an external file is used in the input artifacts.	S3 bucket name
S3 File Path	Provide the S3 file path of the external file present in the input artifacts.	S3 file path
S3 File Format	Provide the file format of the external file.	CSV
S3 File Delimiter	Provide the delimiter used in the external file.	,
S3 File Text Qualifier	Provide the text qualifier used in the external file.	DOUBLE_QUOTE
S3 File Contains Header	Specify whether the external file contains a column header.	True - if column header present False - if column header absent
S3 Table Column Format	Define the table column format especially for date type.	Supported column formats: dd-MMM-yy yyyy-MM-dd HH:mm:ss.SSS
Upper Lower Case Type Key	Used to configure the case format for queries in the respective target database.	Lower Case –To apply lower case to all target queries Upper Case - To apply upper case to all target queries Blank – To avoid case formatting and to retain the original format of the queries.

Click Visualization Configuration to configure the visualizations. The target platform does not automatically support certain legacy visualizations. So, to achieve optimal transformation outcomes, you need to map incompatible visualization with an appropriate alternative compatible visualization.

For each incompatible visualization (Incompatible Visualizations column), select the compatible visualization from the corresponding Map your visualization column to ensure a smooth transformation, as the target platform does not support certain legacy visualizations.

Click Save to update the changes.
An alert pop-up message appears. This message prompts you to refer your respective assessment to determine the anticipated quota deduction required when converting your scripts to target. Then click Ok.

Click to provide a preferred pipeline name and to save the pipeline.
Click to execute the integrated or standalone pipeline. Clicking (Execute) navigates you to the pipeline listing page which shows your pipeline status as Running state. It changes its state to Success when it is completed successfully.
Click on your pipeline card to see reports.

Note:

If the target for any BI conversion assignment is Amazon QuickSight, LeapLogic needs its access to execute the converted reports and datasets.

To view the Tableau to Amazon QuickSight Conversion Stage report, visit Tableau to Amazon QuickSight Conversion Report