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.