topic Re: Databricks SDK for Python: Errors with parameters for Statement Execution in Data Engineering

Databricks SDK for Python: Errors with parameters for Statement Execution

Phuonganh — Tue, 16 Apr 2024 02:49:02 GMT

Hi team,

Im using Databricks SDK for python to run SQL queries. I created a variable as below:

param = [{'name' : 'a', 'value' :x'}, {'name' : 'b', 'value' : 'y'}]

and passed it the statement as below

_ = w.statement_execution.execute_statement( warehouse_id = "123", catalog = "aaa", statement = "SELECT * FROM table_a WHERE name = :a and age = :b", parameters = param)

and I get an attribute error: 'dict' object has no attribute 'as_dict'

But this is exactly how databricks instructed on their website. Thank you for your help

Re: Databricks SDK for Python: Errors with parameters for Statement Execution

DonkeyKong — Tue, 14 May 2024 20:14:09 GMT

@Retired_mod This does not help resolve the issue. I am experiencing the same issue when following the above pointers. Here is the statement:

response = w.statement_execution.execute_statement( statement='ALTER TABLE users ALTER COLUMN :col_name SET NOT NULL', warehouse_id='<warehouseID>', parameters=[{'name': 'col_name', 'value': 'user', 'type': 'STRING'}] )

This results in the same AttributeError outlined by @Phuonganh above.

Re: Databricks SDK for Python: Errors with parameters for Statement Execution

jessica3 — Wed, 23 Oct 2024 14:15:17 GMT

Has anyone found the solution to this? I am running into the same error

Re: Databricks SDK for Python: Errors with parameters for Statement Execution

vfrcode — Fri, 10 Jan 2025 18:17:47 GMT

The following works:

response = w.statement_execution.execute_statement( statement='ALTER TABLE users ALTER COLUMN :col_name SET NOT NULL', warehouse_id='<warehouseID>', parameters=[sql.StatementParameterListItem(name='col_name' value='user', type='STRING')] )