<div dir="ltr"><div dir="ltr"><div dir="ltr"><div><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><pre>Looks like for table names we have to use the IDENTIFIER() keyword as follows:<br><br>CREATE OR REPLACE PROCEDURE SP__INSERT_TO_CUSTOMERS(table_name varchar)<br>RETURNS string<br>LANGUAGE SQL<br>AS<br><br>BEGIN<br><br>insert into IDENTIFIER(:table_name) (customer_name)<br>select distinct<br>customer_name<br>from orders;<br><br>RETURN ‘SUCCESS’;<br>END;<code>
</code></pre>
</div><div><span style="font-size:12.8px"><br></span></div></div></div></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jan 29, 2025 at 2:44 PM Ali, Saqib <<a href="mailto:docbook.xml@gmail.com" target="_blank">docbook.xml@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">I am trying to define a Stored Procedure in Snowflake as follows. But it is erroring out on the variable binding for :table_name. Error: Syntax error: unexpected 'into'.<br><br>How do I achieve this?<br><br>CREATE OR REPLACE PROCEDURE SP__INSERT_TO_CUSTOMERS(table_name varchar)<br> RETURNS string<br> LANGUAGE SQL<br>AS<br><br>BEGIN<br><br>insert into :table_name (customer_name)<br> select distinct<br> customer_name<br> from orders;<br><br>RETURN 'SUCCESS';<br>END;<br></div>
</blockquote></div></div>
</div>