AWS Certified Data Analytics Specialty 2021 – Hands-On - Modifying the Glue Data Catalog from ETL Scripts

The video tutorial explains how to modify data catalogs in ETL jobs, focusing on changing schemas and partitions, creating new tables, and the restrictions involved. It highlights the use of ETL scripts to update catalogs without rerunning crawlers, and discusses the limitations when using specific data formats and storage options.

What is one of the initial steps you might take if you need to modify your data catalog after an ETL job?

• Rerun the crawler

• Delete the existing data catalog

• Ignore the changes

• Change the data format

Which option allows an ETL script to explicitly change partitions?

• Enable Update Catalog

• Disable Update Catalog

• Enable Partition Change

• Disable Partition Change

What can you do with an ETL script besides updating existing table schemas?

• Change data formats

• Create new tables

• Remove partitions

• Delete all tables

What is a requirement for modifying the Data Catalog from ETL?

• Using a local database

• Having S3 as the underlying data store

• Using XML data format

• Having a SQL-based data store

Which data format requires special code when modifying the Data Catalog?

• Parquet

• CSV

• JSON

• Avro