Output tab

Pentaho Data Integration

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15

Use this tab to configure the target table in Databricks. Once a connection is selected for the entry to use, the Catalog field is populated with the available catalogs from that Databricks connection. Once you select a catalog, the Schema field is populated, then when you select a Schema, the tables are populated.


PDI Bulk load Databricks Output tab
Field Description
Database connection

Specify the Databricks database connection to the Databricks account. You can authenticate with either an access token or a username and password. The username must be the email address that you use to login to Databricks. Click Edit to revise an existing connection; click New to add a new connection.

For example:

jdbc:databricks://<server hostname>:443;HttpPath=<HTTP path>;PWD=<Personal Access Token> and jdbc:databricks://<serverhostname>:443;HttpPath=<HTTP path>. The Custom driver class name is com.databricks.client.jdbc.Driver.
Catalog Specify a catalog from the list of available catalogs in your Databricks connection.
Schema Specify the schema of the target table.
Table name Specify the name of the target table.