Skip to content
Advertisement

Tag: stored-procedures

Inserting parameters of stored procedure into a table using Merge in snowflake

I am trying to insert the parameter values of a stored procedure into the table using merge function in sql. The parameters consists of DB and schema name. I have written a stored procedure for that but, I don’t understand where I’m doing wrong. Here is my attempt: Answer You can use binds: See https://docs.snowflake.com/en/sql-reference/stored-procedures-usage.html#binding-variables for more info.

Advertisement