CSV vs Parquet Format Performance Comparison Using AWS Athena

Purpose of this video is to convert csv file to parquet file format using AWS athena.

[nttazitt]

Thank you, this gave me a very quick and good intro to parquet file format and that's what I was looking for exactly. Great!

[kavajvlogs]

You can do this:
CREATE TABLE IF NOT EXISTS
WITH (format='PARQUET', , parquet_compression='SNAPPY', external_location='s3://bucket/parquet/', partitioned_by = ARRAY['year', 'mt'],
bucketed_by = ARRAY['regionid'],
bucket_count = 50
) AS
SELECT * FROM

You can create a non EXTERNAL TABLE in Athena