In this section, we will look more closely at the typical tasks an author user needs to do to edit a dataset. In real-world applications, it is common that datasets might need some degree of processing so that they can be used optimally by QuickSight.
These tasks include the following:
- Importing into SPICE
- Renaming fields
- Changing the field types
- Adding calculated fields
- Combining datasets together
- Applying security filters
In the next section, we will learn how to complete these tasks using the example dataset we configured earlier.
Importing into SPICE
It's time for us to learn how to import a dataset into SPICE. We will change the query mode using the dataset editor and then we will observe the status of the import job. Finally, we will learn how to schedule automatic refresh jobs for our SPICE datasets.
Setting the dataset query mode
Earlier in this chapter, we configured a Redshift dataset as a Direct Query...