topic Re: API Query in Warehousing & Analytics

API Query

Yahya24 — Tue, 17 Oct 2023 14:42:11 GMT

Hello,

I created a sql warehouse (cluster size = 2X-Small) and I wanted to use it to execute a query using the sql query api:

- url : https://databricks-host/api/2.0/preview/sql/statements
- params = {
'warehouse_id': 'warehouse_id',
'statement': 'SELECT * FROM db1.table1;',
'wait_timeout': '0s'
}

I got a response with a status 200 but with text in xml.

On the other hand when I use the queries api https://databricks-host/api/2.0/preview/sql/queries it works well, I have a json with all my queries already defined.

Best regards,

Re: API Query

karthik_p — Wed, 18 Oct 2023 16:22:56 GMT

@Yahya24 can you please remove preview in query, they are not in preview any more "/api/2.0/sql/statements/", you should see json response, can you please check drop down menu and change to json, some times it may be setted into text, but usual response in json

Re: API Query

Yahya24 — Fri, 20 Oct 2023 07:22:45 GMT

Hello @karthik_p,

My problem is solved, I removed "preview" but the real problem comes from the type of the API, I use it as GET while it is POST.

Thank you very much.