A collaboration with Amazon and a potential breakout are just two of the factors putting Snowflake stock on investors' radar.