Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

Hello all :slightly_smiling_face:

I am getting this error `TypeError: execute() takes no keyword arguments` When running sql query *using SqlServerExecute.* Here is my task code following the doc explained here <https://docs.prefect.io/api/latest/tasks/sql_server.html#sqlserverexecute>

```from prefect.tasks.sql_server import SqlServerExecute

SQL = SqlServerExecute(db_name="my"Db",
            user="user",
            host="&lt;tcp:xxxs.database.windows.net&gt;",
            port=1433,
            driver="ODBC Driver 17 for SQL Server")

QUERY = "CREATE TABLE [dbo].[CandidateDetails] ([CandidateId] VARCHAR(22) COLLATE Latin1_General_100_BIN2 NOT NULL,[FirstName] VARCHAR(222) NULL,[LastName] VARCHAR(222) NULL)"

@task
def create_table():
  logger = prefect.context.get('logger')
  <http://logger.info|logger.info>("Create table in DW for loading the results")
  SQL.run(query=QUERY, password='myPass')```
Can you help me on this? many thanks already :slightly_smiling_face:

The complete error is

``` Unexpected error: TypeError('execute() takes no keyword arguments')
Traceback (most recent call last):
 File "/opt/conda/lib/python3.8/site-packages/prefect/engine/runner.py", line 48, in inner
  new_state = method(self, state, *args, **kwargs)
 File "/opt/conda/lib/python3.8/site-packages/prefect/engine/task_runner.py", line 865, in get_task_run_state
  value = prefect.utilities.executors.run_task_with_timeout(
 File "/opt/conda/lib/python3.8/site-packages/prefect/utilities/executors.py", line 323, in run_task_with_timeout
  return task.run(*args, **kwargs) # type: ignore
 File "/home/runner/work/dashboards/dashboards/prefect/jobs/KN/candidates.py", line 95, in create_table
 File "/opt/conda/lib/python3.8/site-packages/prefect/utilities/tasks.py", line 454, in method
  return run_method(self, *args, **kwargs)
 File "/opt/conda/lib/python3.8/site-packages/prefect/tasks/sql_server/sql_server.py", line 90, in run
  executed = cursor.execute(query=query, vars=data)
TypeError: execute() takes no keyword arguments```


Hello again! that task is broken because SqlServerExecute passes keyword arguments, but that `execute` can’t take any in. I have a PR open to fix this that I haven’t had time to finish. It is <https://github.com/PrefectHQ/prefect/pull/4363/files#diff-87c09aea6f8455cdcaa3bf4d3e838108fd566c209a2f01ad71d76d78ab0c6f1dL90-L91|here> . For now, I suggest you copy <https://github.com/PrefectHQ/prefect/blob/1b26edc2b49a77da85757b15975a499a1e68a114/src/prefect/tasks/sql_server/sql_server.py#L7-L100|this version> of the task and rename it and import it into your flow. I think this version should work.

Hi again :smiley:, Okay :slightly_smiling_face:  … many thanks (again :hugging_face:)