Output tab

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.

Last updated

Was this helpful?