works for me, what happens if you run the same code directly in snowflake?
I use comments with the SQL script component quite often. So, yes, this shoudl work. I think we need to see the full SQL to help...