I am doing merge or query statement in my pyspark SQL and notebook executed perfectly when i run manually but if i schedule the pipeline in databricks workflow, i am getting below errors. kindly help me to provide your feedback.

dbutils.widgets.text("catalogname","test")
unity_catalog_name = dbutils.widgets.get("catalogname")
%sql
select * $catalogname.schema.tablename

error as below like when i execute in schedule pipeline

[PARSE_SYNTAX_ERROR] Syntax error at or near '.'. SQLSTATE: 42601