What does the SQL # symbol mean and how is it used?

They normally prefix temporary tables.

From the docs….

Prefix local temporary table names
with single number sign (#table_name),
and prefix global temporary table
names with a double number sign
(##table_name).