Easy ReviewSAA-C03
Design High-Performing Architectures7

Glue

Serverless data integration that discovers, prepares, moves and catalogs data for analytics.

AWS Glue is a serverless data integration service for discovering, preparing, moving and integrating data from many sources.

Glue DataBrew

AWS Glue DataBrew is point-and-click data preparation: profile a dataset, spot quality problems and apply ready-made transformations, with no code and no clusters.

How it works

  1. Connect a dataset, for example in Amazon S3.
  2. Profile it and review suggested data quality fixes.
  3. Build a recipe from ready-made transformations and run it as a job.

Exam cues

  • If the question says visual, no-code data cleaning for analytics or ML, think AWS Glue DataBrew.

Remember

  • Serverless, over 250 transformations.

Trap: DataBrew prepares data; AWS Glue ETL jobs are the code-based option for large pipelines.

From the AWS docs (2)
  • AWS Glue DataBrew is a visual, serverless data preparation tool that cleans and normalizes data without code, with over 250 ready-made transformations.
  • DataBrew helps users discover, visualize, clean and transform raw data and suggests fixes for data quality issues.

Data integration and catalog

AWS Glue prepares data for analytics. It discovers data in many sources, keeps a central catalog of it, and runs ETL jobs that clean and move data into a data lake, without servers to manage.

How it works

  1. Connect Glue to data sources; it records their structure in the Data Catalog.
  2. Build ETL pipelines, visually or in code, to transform data and load it into a data lake.
  3. Query the cataloged data with Amazon Athena, Amazon EMR or Amazon Redshift Spectrum.
Analytics need Service
Prepare and catalog data (ETL) AWS Glue
Query data in S3 with SQL Amazon Athena
Stream data in real time Amazon Kinesis
Dashboards and BI Amazon Quick (QuickSight)
Data warehouse Amazon Redshift

Exam cues

  • If the question says ETL, data catalog or data preparation, think AWS Glue.

Remember

  • Serverless; 70+ data sources; central Data Catalog.

Trap: Glue prepares and catalogs data; querying it with SQL is Amazon Athena.

From the AWS docs (5)
  • AWS Glue is a serverless data integration service for discovering, preparing, moving and integrating data from multiple sources for analytics, machine learning and application development.
  • With AWS Glue you connect to more than 70 data sources and manage data in a centralized data catalog that Amazon Athena, Amazon EMR and Amazon Redshift Spectrum can query.
  • AWS Glue lets you visually create, run and monitor extract, transform and load (ETL) pipelines that load data into data lakes.
  • Glue job bookmarks persist what a previous ETL job run already processed, so scheduled reruns process only new data instead of reprocessing old data.
  • AWS Glue streaming ETL jobs run continuously, read from Kinesis Data Streams, Apache Kafka or Amazon MSK, and load cleaned data into S3 or JDBC stores.

Flashcards

tap to flip
Answer

·

All 7 cards as a list

A business analyst must clean and normalize a messy dataset for ML training without writing code. Which AWS service fits?

AWS Glue DataBrew, a visual, serverless data preparation tool.

Does AWS Glue DataBrew need clusters to be provisioned?

No. DataBrew is serverless.

A company needs serverless ETL jobs to clean data from several sources and load it into an S3 data lake. Which AWS service fits?

AWS Glue, a serverless data integration and ETL service.

What does the AWS Glue Data Catalog help an analytics team do?

It lets the team manage data in a centralized catalog that analytics services can query.

Does AWS Glue require provisioning servers for ETL jobs?

No. AWS Glue is serverless.

What can AWS Glue do to prepare data for a data lake?

AWS Glue can create and run extract, transform and load pipelines that load data into data lakes.

Which AWS service helps discover and prepare data from multiple sources for machine learning?

AWS Glue is a serverless data integration service for discovering and preparing data for machine learning and analytics.

You finished every topic of SAA-C03!

Your badge turned gold. Next step: book the exam on AWS. Once you pass, add yourself to Who passed.

Share

Share that you finished this certification

I finished every topic of AWS Certified Solutions Architect - Associate (SAA-C03) on Easy Review. Come study too!