Learn how to define and run an AWS Glue job to transfer relational data from RDS MySQL to S3.
- [Instructor] Now that Glue knows about our…S3 metadata for the states.csv file,…and it has a connection to MySQL,…it's time to create a job.…Click Jobs under ETL on the left and choose Add Job.…The name for this job will be StatestoMySQL.…As usual, we choose the GlueServiceRole…that we created earlier.…In this job, we're going to go with a proposed script…generated by AWS Glue.…Glue is going to create an S3 bucket…to store data about this job.…
It prefills that, but it does not prefill in…the temporary directory below.…All we need to do is copy the path,…backspace out our root,…and give it a name like tmp.…Keep everything else at default and choose Next.…Here we're choosing data sources.…We have the states metadata CSV,…so we'll choose that and click Next.…For the target, we don't have any metadata…describing a place that we want to put data into.…Instead, we want to choose…create tables in your data target.…Check that radio button and we're given different options.…
The data store is JDBC.…The connection to the database.…
Join AWS architect Brandon Rich and learn how to configure object storage solutions and lifecycle management in Simple Storage Service (S3), a web service offered by AWS, and migrate, back up, and replicate relational data in RDS. Find out how to leverage flexible network storage with Elastic File System (EFS), and use the new AWS Glue service to move and transform data. Plus, learn how Snowball can help you transfer truckloads of data in and out of the cloud.
- What is data management?
- AWS S3 basics
- S3 bucket creation
- S3 upload and logging
- S3 event notifications
- S3 data lifecycle configuration
- Working with Amazon Elastic Block Store volumes
- Creating and mounting an EFS
- Creating an AWS RDS instance
- RDS backup and recovery
- Moving data with AWS Database Migration Service
- Moving data with Data Pipeline and Glue
Skill Level Intermediate
Amazon Web Services: Data Serviceswith Lynn Langit4h 30m Intermediate
Amazon Web Services for Data Sciencewith Lynn Langit3h 56m Intermediate
Amazon Web Services: High Availabilitywith Sharif Nijim2h 17m Intermediate
2. Object Storage
3. File Systems
4. Database Services
6. Moving Data in AWS
5. Getting Data to AWS
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.