The slides make reference to ELT rather than ETL.... ELT is for "schema on read" whereas ETL is for "schema on write" solutions. ELT is more suitable for "file system based" Data Lakes (object storage in AWS S3) while ETL and ELTL is suitable for relational database data warehouse environments (Redshift). ETL is meant to be done by a separate middle ware service between the source and the Redshift Data Warehouse, whereas ELTL is meant to be done entirely in the Redshift Data Warehouse. ELTL is the preferred and modern way method of working in an MPP DW environemnt.
Thanks, Great job. Not all Re-Invent talks are as technical as this.
What a nice way of summarizing all important concepts of Redshift.
Once again, great review of Redshift. Thanks
Thank you Patel, very good technical guidelines well summarized and straight to the point, Thank you very much.
This is great video for deep dive and redshift architecture. Took a while to find it though :)
Amazing presentation and precious content.
I'm really glad you enjoyed it, Siva! 😃 ^NR
The slides make reference to ELT rather than ETL.... ELT is for "schema on read" whereas ETL is for "schema on write" solutions. ELT is more suitable for "file system based" Data Lakes (object storage in AWS S3) while ETL and ELTL is suitable for relational database data warehouse environments (Redshift). ETL is meant to be done by a separate middle ware service between the source and the Redshift Data Warehouse, whereas ELTL is meant to be done entirely in the Redshift Data Warehouse. ELTL is the preferred and modern way method of working in an MPP DW environemnt.
is there any video like that but 2024?
Wow! I watched it twice!
Thanks and nice explanation ..
How can I apply zone maps in my redshift table?
Please help me with this query! What will happen if leader node fails
Pls lemme know the best practices / ways to implement MERGE operation in redshift ( instead of doing n following multi step process). Thanks.
very good presentation - thank you
brilliant
this is cool