Trying to create a stored procedure in snowflake that takes arguments to generate 'create statement' for external table using metadata of the staged file from infer schema and executing it. Since i am fairly new to Snowflake Stored procedure , would really appreciate inputs on how to achieve this?

CREATE OR REPLACE PROCEDURE DatabaseName.SchemaName.TEST_PROCEDURE(DB_NAME STRING, SCHEMA_NAME 
STRING, TABLE_NAME STRING , FILEPATH STRING)
returns string 
language javascript
as
$$
var cmd = `
   SELECT
   'CREATE OR REPLACE EXTERNAL TABLE ' || DB_NAME ||'.'||SCHEMA_NAME||'.'||TABLE_NAME|| ' (' 
||
LISTAGG(
  CLEAN_COLUMN || ' ' || TYPE || ' AS (' ||
  'VALUE:'|| CLEAN_COLUMN || '::' || TYPE || ')', ', ') AS QUERY_TEXT
 FROM (
SELECT *
,CASE WHEN COLUMN_NAME LIKE '%#%' THEN '"'||COLUMN_NAME||'"' ELSE COLUMN_NAME END AS CLEAN_COLUMN
from table(
  INFER_SCHEMA(
    LOCATION => '@db.src_xxx.stg_yyyy/2021-awdfg'
    ,FILE_FORMAT => '@db.src_xxx.parquet'
  )
) A
 )
`
var sql = snowflake.createStatement({sqlText: cmd});
var result = sql.execute();
    return 'Success';
$$;