Is Snowflake That Different from Redshift / Azure WH / BigTable

I was pondering this as well -- and wondering should I buy SNOW stock or is it a bubble ?