Skip to content
Advertisement

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:

JavaScript

Advertisement

Answer

You can use binds:

JavaScript

See https://docs.snowflake.com/en/sql-reference/stored-procedures-usage.html#binding-variables for more info.

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement