Data World 1 · Lake Foundations · Stage 4

Register the Day

Files in S3 are not rows until a partition points at them: register each day, or let Athena project it.

  • Partition projection
  • MSCK REPAIR TABLE
  • ALTER TABLE ADD PARTITION
  • Redshift Spectrum
Domain
Data engineering
World
Data World 1: Lake Foundations (Associate)
Game type
Lake tuner: Tune a lake's tables until the queries fit their limit and budget.
Time
About 25 minutes on a first attempt (estimated)
Exam guides
  • SAA-C03Task 3.5: Determine high-performing data ingestion and transformation solutions
  • DEA-C01Skill 2.2.4: Synchronize partitions with a data catalog; Skill 1.1.5: Set up schedulers by using Amazon EventBridge, Apache Airflow, or time-based schedules for jobs and crawlers; Skill 2.2.1: Use data catalogs to consume data from the data's source; Skill 3.1.7: Query data (for example, Amazon Athena)