• Platform
    Ways to upskill
    • Courses Courses
    • Skill assessments Skill assessments
    • Labs LabsNEW
    • Hands-on learning Hands-on learning
    • Certification prep Certification prep
    • Team efficiency Team efficiency
    Skills for
    • Software development
    • IT ops
    • Info & cyber security
    • Cloud computing
    • Machine learning / AI
    • Data professional
    • See our entire course library
    Top Trending Paths
    Microsoft Azure Deployment
    Path
    Microsoft Azure Deployment
    • 4 Courses
    • 7 Hours
    • Skill IQ available Get your Skill IQ
    AWS Operations
    Path
    AWS Operations
    • 7 Courses
    • 14 Hours
    • Skill IQ available Get your Skill IQ
    Cleaning Data with R
    Path
    Cleaning Data with R
    • 5 Courses
    • 8 Hours
    • Skill IQ available Get your Skill IQ
    Core Python
    Path
    Core Python
    • 25 Courses
    • 44 Hours
    • Skill IQ available Get your Skill IQ
    Ruby Language Fundamentals
    Path
    Ruby Language Fundamentals
    • 7 Courses
    • 13 Hours
    • Skill IQ available Get your Skill IQ
    • See our entire course library
  • Products

    Build tech skills to drive results


    • What is Skills?
    • View plans

    Get insights into your workflow


    • What is Flow?
    • View plans
  • Resources
    Learn
    • Blog
    • Customer stories
    • Resource center
    • Guides
    • App download
    • Support
    Connect
    • Events
    • Webinars
    • Podcast
    Podcasts
    • All Hands on Tech
    • Perspectives in Leadership

    2022 Tech Forecast and
    Build Better Blueprint

    Prepare for shifts and trends in the industry
    Check it out
  • For IndividuaIs
  • Sign in
    Sign in with
    Skills Sign in Skills Sign in
    Sign in with
    Flow Sign in Flow Sign in
  • Try for free
×
AWS Labs
Labs badge iconLAB

Transform Data Using AWS Glue and Amazon Athena

In this lab, you'll practice transforming data with AWS Glue and then analyzing the result with AWS Athena. When you're finished with this lab, you'll have a solution to transform and query data.

* Our Labs are Available for Enterprise and Professional plans only.
Terms and conditions apply.
Contact sales
Labs - Transform Data Using AWS Glue and Amazon Athena

Lab info

Rating (256)
Level
Beginner
Duration
50m
Released
Mar 09, 2022

Lab author

Lab Author: Dan Tofan
Dan Tofan
Dan started programming decades ago on a Spectrum clone and started his professional programming career in 2003. Eager to learn, Dan moved to Netherlands to study at the University of Groningen. Now, Dan is proud of his PhD thesis on decision making and knowledge acquisition in software architecture, and about a dozen publications with hundreds of citations. Dan used Microsoft technologies for many years, but migrated gradually to Python, Linux and AWS, to learn more of the computing world. Cur... morerently, Dan is a full-time Python programmer at the Romania office of a global company in the research domain.
  • Table of contents
  • What's a lab?
  • Prerequisites
Challenge

Crawl Input Sales Data on S3

You’ll learn how to set up a Glue data crawler, then how to crawl the data in a S3 folder to populate the Glue Data Catalog with metadata about the S3 data.

Challenge

Convert Sales Data with a Glue Job

You’ll create a new Glue Job to convert the sales data from the CSV format to the Parquet format.

Challenge

Crawl Output Sales Data on S3

You’ll set up another Glue data crawler, to crawl the Parquet files created in the previous challenge, and write details about them into the Glue Data Catalog.

Challenge

Analyze Sales Data with Athena

You’ll configure Athena and then analyze the sales data with Athena.

Labs - code icon

Provided environment for hands-on practice

We will provide the credentials and environment necessary for you to practice right within your browser.

Labs - list icon

Guided walkthrough

Follow along with the author’s guided walkthrough and build something new in your provided environment!

Labs - analytic icon

Did you know?

On average, you retain 75% more of your learning if you get time for practice.

Recommended prerequisites

  • AWS S3 basics
  • SQL basics

Start learning by doing today

Contact sales

Contact Sales

2183 Redirect Link
Thank you!
Our team will be in touch shortly.

Loading form...

If this message remains, it may be due to cookies being disabled or to an ad blocker.

Close button

Ready to skill up
your entire team?

10
Subscriptions
Need more subscriptions? Contact sales.
Continue to checkout Continue to checkout
Cancel

With your Pluralsight plan, you can:

With your 14-day pilot, you can:

  • Access thousands of videos to develop critical skills
  • Give up to 10 users access to thousands of video courses
  • Practice and apply skills with interactive courses and projects
  • See skills, usage, and trend data for your teams
  • Prepare for certifications with industry-leading practice exams
  • Measure proficiency across skills and roles
  • Align learning to your goals with paths and channels

Ready to skill up
your entire team?

10
Subscriptions
Need more subscriptions? Contact sales.
Continue to checkout
Cancel

With your Pluralsight plan, you can:

With your 14-day pilot, you can:

  • Access thousands of videos to develop critical skills
  • Give up to 10 users access to thousands of video courses
  • Practice and apply skills with interactive courses and projects
  • See skills, usage, and trend data for your teams
  • Prepare for certifications with industry-leading practice exams
  • Measure proficiency across skills and roles
  • Align learning to your goals with paths and channels
  • Solutions

    • Pluralsight Skills
    • Pluralsight Flow
    • Government
    • Gift of Pluralsight
    • View Pricing
    • Contact Sales
    • Skill up for free
  • Platform

    • Browse library
    • Role IQ
    • Skill IQ
    • Iris
    • Authors
    • Professional Services
  • Company

    • About us
    • Customer stories
    • Careers
    • Blog
    • Newsroom
    • Resource center
    • Guides
  • Resources

    • Download Pluralsight
    • Events
    • Teach
    • Partners
    • Affiliate Partners
    • PluralsightOne.org
    • Subscribe
  • Support

    • Contact
    • Help center
    • IP allowlist
    • Sitemap
Globe wireframe
  • Deutsch
  • English
  • French
Copyright © 2004 - 2022 Pluralsight LLC. All rights reserved.
    Terms of Use
    Privacy Notice
    Modern Slavery Act Transparency Statement
  • Like on Facebook
  • Heart on Instagram
  • Retweet on Twitter
  • Share on LinkedIn
  • Watch on YouTube

We use cookies to make interactions with our websites and services easy and meaningful. For more information about the cookies we use or to find out how you can disable cookies, click here.

You have disabled non-critical cookies and are browsing in private mode. For the best possible experience on our website, please accept cookies. For additional details please read our privacy notice.