Amazon S3 Basic Intro

AWS S3:

- Use Amazon S3 to store and retrieve any amount of data using highly scalable, reliable, fast, and inexpensive data storage 

 - A bucket is a container for objects. 

 - An object is a file and any metadata that describes that file.

 Index:

 1. Create Bucket 

2. Load data File 

 3. Download data File 

 4. Delete data File 

 5. Delete Bucket 

 Video Link: https://www.youtube.com/watch?v=f9Bxe-3tTNU Video:

What is Athena ?? How its Works ??

Index:

1. setup Athena

2. Create & Select database

3. Create table

4. Load data in table 

5. over of query running

Pre-required :

Know about Hive and s3

-  Its similar to Hive but it is server less 

- Athena is layer on top of hive 

- No server required 

- as similar to hive in input data no header required

- In Athena 

- No charge on DDL Commands (Data Definition Language)

- It charge on scanning data only it's minimum 10mb 

- Athena used or work on external table 

Note:

'skip.header.line.count'='1'   # for the skip header line 

Video Link : https://www.youtube.com/watch?v=TzlN-aXKc_w

Video: