Creating ETL jobs on AWS Glue
In a modern data pipeline, there are multiple stages, such as Generate Data, Collect Data, Store Data, Perform ETL, Analyze, and Visualize. In this section, we will cover each of these at a high level and understand the ETL (extract, transform, load) part in-depth:
- Data can be generated from several devices, including mobile devices or IoT, weblogs, social media, transactional data, online games, and many more besides.
- This huge amount of generated data can be collected by using polling services or through API gateways integrated with AWS Lambda to collect the data, or via streams such as AWS Kinesis or AWS-managed Kafka or Kinesis Firehose. If you have an on-premises database and you want to collect that data to AWS, then you choose AWS DMS for that. You can sync your on-premises data to Amazon S3, Amazon EFS, or Amazon FSx via AWS DataSync. AWS Snowball is used to collect/transfer data into and out of AWS.
- The next step involves storing...