Skip to content

Setup Databricks Spark SQL on Privacera Portal

These steps apply to both Self-Managed and Data Plane deployments..

  1. For Self-Managed, log in to the Privacera Portal; for Data Plane, log in to the Privacera Discovery Admin Console.
  2. Navigate to Settings > Data Source Registration
  3. Under the system name you added here, click the more icon. Select Add Application > DATABRICKS SPARK SQL
  4. Under Configure JDBC Application, provide values for the Application Name and Application Code fields.

  5. Under Application Properties, provide values for the following:

    Important

    Identify the user who must have appropriate permissions in your data source. For scanning, you need a user with read permission. Login credentials of that user are needed for the JDBC Username and JDBC Password properties as shown below.

    • JDBC Url: jdbc:hive2://<domainName>:<port>/default;transportMode=http;ssl=true;httpPath=sql/protocolv1/o/0/xxxx-xxxxxx-xxxxxxxx;AuthMech=3;

    • JDBC Username: <user_with_readwrite_permission>

    • JDBC Password: <login_credentials_of_identified_user>

    • JDBC Driver Class: org.apache.hive.jdbc.HiveDriver

    For more information about Driver Class You can refer List of JDBC Driver Class for all datasources

    Tip

    You don't need to update any other fields during the initial setup. You can update them later as needed.

  6. Click TEST CONNECTION. Ensure that a message named success is displayed.

  7. Click SAVE
Resource format for DatabricksSQL

Resources can be added in the following formats for Discovery Scanning:

  • dbx_database_name/dbx_table_name
  • */dbx_table_name
  • dbx_database_name/*
  • *_database_*/*_table_*

Comments