The three types of stages supported by Snowflake are Internal Stages - in which data is stored internally by Snowflake, and External Stages - where data is stored in Cloud Storage & Table stage - which is automatically created for each table.

For temporary external stages, only the stage is dropped, the files being external are not removed.

String constants can be enclosed in single quotes or $ symbols..

https://docs.snowflake.net/manuals/sql-reference/data-types-text.html#single-quoted-string-constants

https://docs.snowflake.net/manuals/sql-reference/data-types-text.html#dollar-quoted-string-constants