Summary
In this chapter, we reviewed several ways to ingest common data types into AWS. We reviewed how AWS DMS can be used to replicate a relational database to S3, and how Amazon Kinesis and Amazon MSK can be used to ingest streaming data.
In the hands-on section of this chapter, we used both the AWS DMS and Amazon Kinesis services to ingest data and then used AWS Glue to add the newly ingested data to the data catalog and query the data with Amazon Athena.
In the next chapter, Chapter 7, Transforming Data to Optimize for Analytics, we will review how we can transform the ingested data to optimize it for analytics, a core task for data engineers.