2

Is there a way to start, stop, list available SQL Endpoints in Databricks SQL?

With "Can Use" permission it's possible to start a SQL Endpoint while connecting to an endpoint using the Databricks JDBC driver, but have no idea how to stop it (not to mention how to list all the available endpoints).

Jacek Laskowski
  • 72,696
  • 27
  • 242
  • 420

1 Answers1

2

All of this (and more) could be done via REST API for SQL Endpoints. You just need to be authenticated to workspace & have corresponding permissions. To stop you need to have CAN_MANAGE permission (see docs)

Alex Ott
  • 80,552
  • 8
  • 87
  • 132
  • Yup, found it myself too and works great! I must admit it gives better view on the underlying configuration that the UI itself. Wish there were `dbutils`-way of managing SQL endpoints. – Jacek Laskowski Nov 01 '21 at 10:30
  • 2
    for actual management (except start/stop), I would recommend to use Databricks Terraform provider – Alex Ott Nov 01 '21 at 10:48