Перейти до основного вмісту
JobCannon
Усі навички
⚡

AWS Glue ETL

⬢ РІВЕНЬ 2Технічні
💰
Високий
Вплив на зарплату
⏱
7 міс.
Час на опанування
📊
Середньо
Складність
👥
—
Професії
Коротко

AWS Glue extracts data from sources (databases, S3, APIs), transforms it (schema mapping, normalization, enrichment), and loads it to targets (S3, Redshift, RDS). Glue Crawlers auto-discover schemas, Glue Jobs run ETL scripts (Python, Scala), and Glue Catalog manages metadata. Mastery means designing efficient pipelines, handling schema evolution, error recovery, and cost optimization. Learning path: ETL concepts (1 week) → Glue basics (2 weeks) → Crawlers + schema (1 week) → Jobs + transformations (2 weeks) → production patterns (1 week).

Що таке AWS Glue ETL

AWS Glue is a serverless ETL (Extract, Transform, Load) service. Glue Crawlers automatically discover data schemas from S3, databases, and APIs. Glue Jobs transform and move data using Spark scripts (Python or Scala). The Glue Data Catalog stores metadata, accessible to Athena, Redshift, and Lambda. Use for: data warehouse ingestion, data lake pipelines, data cleaning, format conversion (CSV to Parquet), schema normalization.

🔧 ІНСТРУМЕНТИ ТА ЕКОСИСТЕМА
AWS Glue ConsoleGlue CrawlersGlue JobsGlue Data CatalogGlue Studio (visual ETL)DPU (Data Processing Units)Glue TriggerApache Spark (backend)Python/Scala

📋 Перед стартом

PythonData AnalysisSql Databases

💰 Зарплата за регіонами

РегіонJuniorMiddleSenior
🇺🇸USA$80k$130k$180k
🇬🇧UK£48k£80k£120k
🇪🇺EU€52k€85k€130k
🇨🇦CANADAC$85kC$135kC$185k

🎓 Сертифікації

AWS Certified Data Analytics, Specialty→AWS Certified Solutions Architect, Associate→Apache Spark Certification (Databricks)→

⚖ Порівняти з

Dbt Data TransformationApache SparkAws Athena Queries

❓ Часті запитання

▶What's the difference between Glue and Athena?
Athena: query existing data with SQL. Glue: transform/load data into new format/location. Glue rewrites data; Athena reads it. Often used together.
▶Should I use Glue or Spark directly?
Glue: managed, simpler for straightforward pipelines, auto-scaling. Spark directly: more control, lower cost if you manage clusters. Glue for most cases.
▶What are Glue Crawlers?
Crawlers auto-discover data schema from S3/databases. They read data samples, infer types, and create table definitions in Glue Catalog. Magic for schema discovery.
▶How do I handle schema evolution?
Crawlers update table definitions when schema changes. Glue Jobs can handle schema mismatches. Use schema registry for stricter validation.
▶What's Glue Data Catalog?
Metadata repository. Crawlers populate it. Athena, Redshift, Lambda, and other AWS services query it. Single source of truth for data metadata.
▶How much does Glue cost?
DPU-hours: ~$0.44/DPU/hour. 10 DPU job running 1 hour = $4.40. Crawlers: $0.44/DPU-hour. Usually <$200/mo for small pipelines.
▶Is Glue suitable for production?
Yes, thousands of companies run ETL on Glue. Caveats: cold starts (first job takes time), DPU allocation critical for cost.
🎯

Не впевнені, що ця навичка вам підходить?

Пройдіть Career Match — підкажемо відповідні напрямки.

Підібрати навички для мене →

Знайдіть свій кар’єрний шлях

Підбір за навичками серед 2536 професій. Безкоштовно, ~2 хвилини.

Пройти Career Match — безкоштовно →
Дивитися ще:Усі навичкиБібліотека професійТести особистостіМетодологія