create or replace procedure "ETL"."ACQ".SP_FILE_RETENT("Trgt_DB" VARCHAR, "Trgt_Schema" VARCHAR, "Trgt_Table" VARCHAR, "Trgt_Stage" VARCHAR)
returns string
language JavaScript
EXECUTE AS CALLER
as
$$

var remove_data_tbl = `delete from '`+Trgt_Table+`' where last_modified = current_date()`;
var remove_remove_data_tbl_sql = {sqlText: remove_data_tbl };
var remove_data_tbl_create = snowflake.createStatement(remove_remove_data_tbl_sql);
var remove_details_exec = remove_data_tbl_create.execute();

$$;

CALL "ETL"."ACQ".SP_FILE_RETENT('ETL', 'ACQ', 'METADATA', 'FILE_RETENTION');

when calling this procedure, it won't delete the rows from my table METADATA I have back ticks in place before 'delete' and before the + and I have other back ticks after the other plus and before the semi colon