@lingareddy_Alva 

First, if we are going to use sql variable, then it needs to be declared first before we set it( declare variable catalog_name string).

Second, the main intention was not to use $ in sql code but that's not same as you explained above. Have you tried to run them in python and sql notebooks that can be demonstrated with successful run!!