title: How to execute Snowflake Stored Procedure from Python?
body: <p>I have created stored procedure in snowflake which is executed fine in snowflake UI and also from server by using snowsql. Now I want to execute procedure from python program, I tried to execute from python, here are the steps that I have followed:</p>
  <ol>
  <li>establish the connection to snowflake ( successfully able to connect.)</li>
  </ol>
  <blockquote>
  <p>cs = ctx.cursor()</p>
  </blockquote>
  <ol start="2">
  <li>Used appropriate role,warehouse,database and schema.</li>
  <li>tried to execute procedure like this:</li>
  </ol>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>cs.execute("call test_proc('value1', 'value2')")   
  x = cs.fetchall() 
  print(x)</code></pre>
  </div>
  </div>
  </p>
  <p>But getting an erorr:</p>
  <blockquote>
  <p>snowflake.connector.errors.ProgrammingError: 002140 (42601): SQL
  compilation error: Unknown function test_proc</p>
  </blockquote>
  <p>Can you please help me to resolve this problem.</p>
  <p>Thanks,</p>