Privileges Required to Use Databricks Connector

To use Databricks, you need one of the following:

  • scheduler-administrator or redwood-administrator role.
  • scheduler-user or redwood-login role in combination with the following system-wide, Partition-wide or object-level privileges.

Built-in Roles

  • The scheduler-administrator or redwood-administrator built-in role provides full control over Databricks.
  • The scheduler-viewer built-in role provides read-only access to Databricks.

Creating, Modifying, and Deleting Databricks Connections

You need all of the following privilege ranks to be able to create, modify, and delete Databricks:

  • View or any other rank - on the Redwood_Databricks Application.
  • View or any other rank - on the Redwood_DatabricksConnectionConstraint constraint.
  • View or any other rank - on the Redwood_DatabricksNotRunningClusterConstraint constraint (version 1.0.0.1 and up only).
  • View or any other rank - on the Redwood_DatabricksNotTerminatedClusterConstraint constraint (version 1.0.0.1 and up only).
  • View or any other rank - on the Redwood_DatabricksConnection extension point.
  • View or any other rank - on the Redwood_Connections extension point.
  • View or any other rank - on the existing Process Server and Queue for the connection, if applicable.
  • Create - on Process Server and Queue, if these need to be created.
  • Edit - on DBKConnection if you want to be able to manage all Databricks connections.

Using Databricks

  • View or any other rank - on the Redwood_Databricks Application.
  • View or any other rank - on the Redwood_DatabricksConnectionConstraint constraint.
  • View or any other rank - on the Redwood_DatabricksNotRunningClusterConstraint constraint (version 1.0.0.1 and up only).
  • View or any other rank - on the Redwood_DatabricksNotTerminatedClusterConstraint constraint (version 1.0.0.1 and up only).
  • View or any other rank - on the Redwood_DatabricksConnection extension point.
  • View - on DBKConnection, EXTConnection, EXTObjectRefs, and EXTCertificate.
  • View - on the component's Process Server.
  • JobAdministrator - on the component's Queue.
  • View - on REDWOOD.Redwood_Databricks library.
  • Submit - on Process Definitions you wish to use.

See Also