Learn how to create a reusable connection definition to allow AWS Glue to crawl and load data from an RDS instance.
- [Tutor] Now our target is going to be…the RDS database, so we need to go to Connections.…Choose Add connection.…From here, we can name the connection;…MySqlDemoConnection.…Database engine should be RDS…because that's where our MySQL is running.…This next option we choose MySQL…and we can give a description if we like.…For the Instance, Glue pre-populates our RDS instances,…so we choose the first one.…
It pre-fills our Database Name and Username.…Now we have a problem.…"Unable to find a suitable security group."…Remember the self-referencing rule…that we created in the prep?…We have one more step here.…We need to attach it to the RDS database…that we created,…so let's go out of Glue via the main console,…and over to RDS.…Here we'll choose DB Instances…and select MySQL.…Under the dropdown for Instance Actions,…choose Modify.…
We've seen this screen before.…It's the place where we can set all kinds…of configuration options on the RDS database.…About halfway down the page…is the Security Group section.…Be careful when clicking into this menu…
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
5. Getting Data to AWS
6. Moving Data in 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.