Starburst Documentation
Clients
  • Overview
  • Gather connection information
  • Python clients
  • Business intelligence tools
  • SQL workbenches
  • Data management tools
  • Observability tools
  • Trino CLI
  • JDBC driver
  • ODBC driver
  • Machine learning

    • clients > QuickSight

    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

    Grant access and set limits #

    Users in deployments that use BIAC or file-based access control and enforce the SET privilege may encounter the following error message during query execution: Access Denied: Cannot set system session property query_max_run_time. To prevent this issue, grant the SET privilege on query_max_run_time. This privilege is required even when the property is set automatically by QuickSight’s JDBC driver. Granting this privilege does not impact other users or queries.

    To prevent users with direct query access and the SET privilege from overriding the query_max_run_time limit, use a deny rule for user accounts or configure a system-wide maximum for query_max_run_time. Any value above the configured maximum is automatically capped.