title: Call a Redshift stored procedure with a parameter from lambda boto3
body: <p>I have a stored proc that I want to call from my AWS lambda. The value of the parameter will change with each invocation which is why it cannot be hardcoded (to state the obvious).</p>
  <p>From the boto3 documentation I believe that this is the way to do it:</p>
  <pre><code>response = rs_client.execute_statement(
              ClusterIdentifier='my_cluster_name',
              Database='my_db_name',
              DbUser='my_user'',
              Sql='call my_schema.this_is_my_proc()',
              Parameters=[{'name': 'in_param', 'value': 'this is the parameter'}],
              StatementName='Test of SP call'
          )
  </code></pre>
  <p>but I get this error:</p>
  <pre><code>An error occurred (ValidationException) when calling the ExecuteStatement operation: Parameters list contains unused parameters. Unused parameters: [in_param]
  </code></pre>
  <p>I can call it with a hardcoded parameter which works but is of course pointless (but proves that the call to the proc works):</p>
  <pre><code>Sql=&quot;call my_schema.this_is_my_proc('and this is the parameter')&quot;
  </code></pre>
  <p>For completeness my stored proc heading looks like this:</p>
  <pre><code>create or replace procedure my_schema.this_is_my_proc(in_param varchar)
  as $$
  declare
  ...
  </code></pre>
  <p>Is it possible to call a Redshift SP with one or more parameters from a lambda using boto3?</p>
  <p>Edit - the Parameter argument would look something like this:</p>
  <pre><code>Parameter=[{'name': 'in_param', 'value': a_variable}]
  </code></pre>
  <p>Thanks</p>