32 . AWS Athena Query S3 Without Glue Catalog | AWS Data Engineer

#️⃣ #databricks #DataEngineering #AzureDataFactory

GITHUB DATASET -https://github.com/manish040596/AWS-DATA-ENG

In this video, we will learn how to query S3 data in AWS Athena without using a Glue Crawler, by creating an external table using the S3 LOCATION property.

This is an important concept for AWS Data Engineers who want full control over schema definition and avoid unnecessary crawler usage.

🔹 What You Will Learn

✔ How Athena reads data directly from S3
✔ Creating an external table manually using SQL
✔ Using LOCATION property in Athena
✔ Defining schema without Glue crawler
✔ Handling CSV / TSV files
✔ Skipping header rows
✔ Running SQL queries on S3 data

🔔 Want more videos like this?
👉 Hit Like, 💬 Comment, 🔁 Share, and ✅ Subscribe!

❤️ Support the channel!
🎯 Like Goal: 5000 Likes!
👍 Don’t forget to show love by liking & sharing this video.

📽️ Chapters
⏱️ 0:00 - Introduction

📚 Playlists You’ll Love:

1️⃣ AWS Data Engineer:
🔗 https://www.youtube.com/playlist?list=PLOlK8ytA0MghpdMjb0m9zu1v9s_qbRP0q

2️⃣ Azure Data Engineer Playlist:
🔗 https://www.youtube.com/watch?v=MD2ZwGtKE5M&list=PLOlK8ytA0MggTm3pkGSfupleGB1cgcuZt

3️⃣ SQL Playlist:
🔗 https://youtube.com/playlist?list=PLOlK8ytA0Mgibvv5_q4M_iW8nm9rTcszd&si=_E4dj0Bt0fp1VOFU

6️⃣ PySpark Playlist:
🔗 https://youtube.com/playlist?list=PLOlK8ytA0MgjvOpd-088NRU_vTYw_aryH&si=VzbbxDVp08LUYfMu

5️⃣ Azure Data Factory Playlist:
🔗 https://youtube.com/playlist?list=PLOlK8ytA0MgguN5XidtQXbILxwCdJCUJE&si=NfMjbeP2AaA3ct-_

4️⃣ Python Playlist:
🔗 https://youtube.com/playlist?list=PLOlK8ytA0Mgj8xTzgMxClAq09E5066Q7M&si=J023ppQnO9ABvecP
7️⃣ Azure Data Engineer Projects:
🔗 https://youtube.com/playlist?list=PLOlK8ytA0MgiEIhJmYEaNvaFIJQNCqA68&si=ilBuY8HWxblHiGca

8️⃣ Data Engineer Interview Prep:
🔗 https://youtube.com/playlist?list=PLOlK8ytA0Mgid1Sp61K7r-OiXZ5ovwjFM&si=esliJap1sk5rWZCP

📣 Connect with Me:
💬 Join the conversation on Telegram:
🔗 https://t.me/+Cb98j1_fnZs3OTA1

🙏 Hope you enjoyed the video and learned something valuable!
📺 See you in the next one — until then, Bye-Bye 👋

🔖 Tags:🔹 Why This Is Important for Data Engineers

Faster setup for small datasets

Full schema control

No dependency on Glue crawler

Useful in development and testing environments

Helps in interview preparation

This tutorial is perfect for:

AWS Data Engineers

ETL Developers

Cloud Engineers

Interview Preparation Candidates

Beginners learning Data Lake concepts

Видео 32 . AWS Athena Query S3 Without Glue Catalog | AWS Data Engineer канала learn by doing it