pbPassingBI
/
quicksight/flashcards/quicksight-cards-data

Data sources & datasets — flashcards

One card per lesson — 5 in this module. Recall the key points, then check. 5 cards. Click a card to flip, or use the arrow keys and space bar.

  1. SPICE and direct query — what are the key points?

    SPICE is an in-memory columnar copy; direct query hits the source per visual · Incremental refresh needs a date column and a supporting source · Refresh failures are often SPICE capacity — audit unused datasets Read the lesson

  2. Preparing datasets — what are the key points?

    Dataset-level work is inherited by every analysis on it · Set geographic roles or map visuals will not be offered · Prefer a warehouse view over embedded custom SQL Read the lesson

  3. Connecting to data sources — what are the key points?

    S3 needs a manifest file; URIPrefixes picks up new files automatically · QuickSight needs its own service permissions, separate from yours · One data source supports many datasets — define the connection once Read the lesson

  4. Preparing datasets — what are the key points?

    Dataset work is shared by every analysis; analysis work is not · Define shared calculations once in the dataset so reports cannot disagree · QuickSight can join across different data sources Read the lesson

  5. SPICE capacity and refresh — what are the key points?

    Running out of SPICE capacity makes refreshes fail, often quietly · Match refresh frequency to how often the data actually changes · Incremental refresh misses rows updated outside the lookback window Read the lesson