QuickSight #

Requirements #

Connect to a Starburst dataset #

  1. In the QuickSight navigation menu, click Datasets.

      Quicksight navigation menu.

  2. Click New dataset.

  3. Select the Starburst tile.

  4. In the New Starburst data source dialog, perform the following actions:

    • Product Type: Select a Starburst product.
    • Data source name: Name the new datasource.
    • Connection type: The Public network is pre-selected by default.
    • Database server: Enter the hostname of the cluster.
    • Port: The port for Starburst Galaxy is 443. For SEP, the port is 8080.
    • Catalog: Enter the name of the catalog.
    • Username: Enter the name of a user.
    • Password: Provide the password for the user.

  5. To test the connection, click Validate connection. If the connection validation fails, check that the cluster is running, verify your connection details, and try again.

  6. Click Create data source.

      quicksight new starburst data source dialog

  7. In the Choose your table dialog, expand the drop-down menu. Select a schema, then select a table. To return specific data, click Use custom SQL, and create a custom SQL statement. To preview the data to be used in your analysis, click Edit/Preview data.

  8. Click Select.

      quicksight choose your table dialog

  9. In the Finish data creation dialog, select how you would like to import data:

    • Import to Spice for quicker analytics runs the SELECT statement against data previously stored in memory.

    • Directly query your data runs the SELECT statement directly against the database.

  10. Uncheck Email users when a refresh fails if you do not want to notify users. This option is only available for Import to Spice for quicker analytics import mode.

  11. To enhance data analysis with Amazon SageMaker, click Augment with SageMaker. This option is only available for Import to Spice for quicker analytics import mode.

  12. Click Visualize.

      quicksight finish data creation dialog

  13. In the New sheet dialog, click Create to create an interactive sheet. To create a paginated report, add the Paginated reporting Add-on to your QuickSight account.

      quicksight new sheet dialog