Skip to content

Prerequisites

This section outlines the prerequisites for setting up the Discovery scanning feature for Databricks Spark SQL.

Make sure you have installed and configured the base Privacera Discovery before proceeding with the Redshift setup. For more information, see Discovery.

Prerequisites Description
JDBC URL The JDBC URL for the Databricks Spark SQL database.
Personal Access Token The Personal Access Token for the Databricks Spark SQL database.

Discovery needs updated JDBC URL. Follow the steps below to update the JDBC URL.

Original URL
jdbc:databricks://privacera-XXXXXXXXXXXX.databricks.com:443/default;transportMode=http;ssl=1;httpPath=sql/protocolv1/o/10237XXXX0399/0410-08XXX58-hxwu2851;AuthMech=3;UID=token;PWD=<personal-access-token>
  1. Replace from jdbc:databricks: to jdbc:hive2:
  2. Remove UID and PWD from url.
  3. Replace ssl=1 to ssl=true
Updated URL
jdbc:hive2://<domainName>:<port>/default;transportMode=http;ssl=true;httpPath=sql/protocolv1/o/0/xxxx-xxxxxx-xxxxxxxx;AuthMech=3;

Comments