GIT HUB CI/CD-snowflake-Stored procedure

1

Hi Team ,

Can you please help me here

We are implementing CI/CD using Liquibase GIT HUB actions , below code not working – Because of ($$) please advise

Error :syntax error line 5 at position 4 unexpected ‘$’.

–liquibase formatted sql

–changeset Abc:Initdep1.1

CREATE OR REPLACE PROCEDURE FETCH()
RETURNS VARCHAR(128)
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS $$
var SP_NAME=‘FETCH’;
var MESSAGE_TEXT=‘’;

// generating run_id

try{
	
	var statement = `SELECT SHA2(CURRENT_TIMESTAMP);`;
	var sql_query = snowflake.createStatement ( { sqlText: statement});
	var result    = sql_query.execute ();
	result.next();
	
	var run_id = result.getColumnValue(1);
	return run_id;
	
}

catch(err_dataloading){
	
	return "Error during generation of RUN_ID : " + err_dataloading
}

$$;

2

by removing –liquibase formatted sql from sql file able to deploy but in change log table , ID =raw author =include all
can i know why code is not working by mentioning liquibase formatted sql how to fix the issue by including –liquibase formatted sql to capture id and author

3

i could able to resolve by using .xml file instead of .sql

Thanks
ArunaH