Using SPICE data in an analysis - Amazon QuickSight

Using SPICE data in an analysis

When you use stored data to create an analysis, a data import indicator appears next to the dataset list at the top of the Fields list pane. When you first open the analysis and the dataset is importing, this icon appears as a spinner.

Fields list pane showing dataset "all_flights" with cancellation_code and dest_city_name fields.

After the SPICE import is complete, the indicator displays the percentage of rows that were successfully imported. A message also appears at the top of the visualization pane to provide counts of the rows imported and skipped.

Import completion message showing 11432789 rows successfully imported to SPICE.

If any rows were skipped, you can choose View summary in this message bar to see details about why those rows failed to import. To edit the dataset and resolve the issues that led to skipped rows, choose Edit data set. For more information about common causes for skipped rows, see Troubleshooting skipped row errors.

File import log showing summary of skipped rows and Edit data set button.

If an import fails altogether, the data import indicator appears as an exclamation point icon, and an Import failed message is displayed.