post /api/2.0/sql/statements/sql statement id/cancel forbidden error in databricks

slakshmanan — Wed, 09 Oct 2024 16:21:18 GMT

when i tried executing this request

post /api/2.0/sql/statements/${SQL_STATEMENT_ID}/cancel

I am getting forbidden error.

how do we get access to execute this

Re: post /api/2.0/sql/statements/sql statement id/cancel forbidden error in databricks

filipniziol — Wed, 09 Oct 2024 18:49:03 GMT

Hi @slakshmanan ,

The 403 Forbidden error usually means that the API request is not authorized, meaning you likely do not have the proper permissions or your authentication credentials are not being recognized. Here are 2 main reasons:

1. Missing or Incorrect Authentication Token
To execute REST API requests on Databricks, you need to authenticate using a Personal Access Token (PAT). Make sure that:

You have generated a valid PAT from your Databricks workspace settings.
You are including the PAT correctly in the request header.

Authorization: Bearer <YOUR_PERSONAL_ACCESS_TOKEN>

2. Insufficient Permissions

Make sure you have correct permissions

topic Re: post /api/2.0/sql/statements/sql statement id/cancel forbidden error in databricks in Data Engineering

post /api/2.0/sql/statements/sql statement id/cancel forbidden error in databricks

Re: post /api/2.0/sql/statements/sql statement id/cancel forbidden error in databricks