Create an endpoint in Databricks SQL
- Login to your Databricks account.
- After logging into your Databricks, go to SQL Analytics.
- Go to Endpoints and click on New SQL Endpoint.
-
Create the endpoint as per your requirement as shown below.
-
After creating endpoint click on the endpoint connection details and note down the JDBC url for configuration with PolicySync.
-
Click on personal access token to create token.
-
Click on Generate New Token.
- Put the name for the token and validity and click on Generate.
- Copy the generated token. This is the JDBC password of the user when connecting from PolicySync, and the email ID of the user is the JDBC username.
-
Grant Admin privileges.
- Go to Workspace.
- To access the Admin Console, go to the top right of the workspace UI, click the
user account icon, and select Admin Console.
- In the Admin column, select the checkbox for the user.