Uit de cursus: AWS: Storage and Data Management

Krijg vandaag toegang tot de volledige cursus

Word vandaag lid en krijg toegang tot meer dan 23.400 cursussen geleid door branchedeskundigen.

AWS Glue: RDS data crawler

AWS Glue: RDS data crawler - tutorial Amazon Web Services (AWS)

Uit de cursus: AWS: Storage and Data Management

Gratis proefversie van 1 maand starten Aanschaffen voor mijn team

AWS Glue: RDS data crawler

“

- [Instructor] We're picking up right where we left off with Glue, now able to talk to the RDS database. Over here in MySQL Workbench, I've logged into that database, and you can find this bit of SQL in the Chapter 6 folder of the exercise files. It's in a file called mysql_states_table.sql. You see, speaking of features that Glue has modified or taken away, one of the things you used to be able to do is set up a job that would create the table in the destination database. Unfortunately, Glue isn't going to allow us that option right now, at least not through its graphical editor. So instead, what we're going to do is create the destination for our data and then have a crawler in glue discover it so that we'll have both sides of the metadata defined. In this case, you can see that this table is not going to be exactly like the schema of our CSV file, and that's because we want to show a little bit of transformation…

Inhoud