Explain the differences between Amazon Redshift and Snowflake in architecture, scaling, and performance tuning.
