Menu
Amazon QuickSight
User Guide

Preparing a Data Set Based on Database Data

Use the following procedure to prepare a database data set. The data for this data set can be from an AWS database data source like Amazon Athena, Amazon RDS, or Amazon Redshift, or from an external database instance.

  1. Open a database data set for preparation by choosing one of the following options:

  2. (Optional) On the data preparation page, type a name into the data set name box on the application bar.

    This name defaults to the table name if you selected one before data preparation. Otherwise, it's Untitled data source.

  3. Decide how your data is selected by choosing one of the following:

    • To use a single table to provide data, choose a table or change the table selection.

      If you have a long table list in the Tables pane, you can search for a specific table by typing a search term for Search tables.

      Any table whose name contains the search term is shown. Search is case-insensitive and wildcards are not supported. Choose the cancel icon (X) to the right of the search box to return to viewing all tables.

    • To use two or more joined tables to provide data, choose two tables and join them using the join pane. You must import data into SPICE if you choose to use joined tables. For more information about joining tables using the Amazon QuickSight interface, see Joining Tables.

    • To use a custom SQL query to provide data in a new data set, choose Switch to Custom SQL tool on the Tables pane. For more information, see Using a SQL Query.

      To change the SQL query in an existing data set, choose Edit SQL on the Fields pane to open the SQL pane and edit the query.

  4. Prepare the data by doing one or more of the following:

  5. If you aren't joining tables, choose whether to query the database directly or to import the data into SPICE by selecting either the Query or SPICE radio button. We recommend using SPICE for enhanced performance.

    If you want to use SPICE, check the SPICE indicator to see if you have enough space to import the data set. Importing occurs when you choose either Save & visualize or Save.

    If you don't have enough space, you can remove fields from the data set or apply a filter to decrease its size.

    Note

    The SPICE indicator doesn't update to reflect the potential savings of removing fields or filtering the data. It continues to reflect the size of the data set as retrieved from the data source.

  6. Choose Save to save your work, or Cancel to cancel it.

    You might also see an option to Save & visualize. This option appears based on the screen you started from. If this option isn't there, you can create a new visualization by starting from the data set screen.