Databricks

Configure Databricks as a destination for Lumel Planning sheets' writeback.

Prerequisite: Certain Lumel IP addresses need to be whitelisted in the firewall for the application to reach the configured server.

Detailed help instructions, whitelisting procedures, and other details are available on the Lumel application with links as shown below:

Databricks as writeback destination

You will need to enter the following information:

• Host Name

• Warehouse ID

• Access Token

• Catalog

• Schema

• Table Name

• Whether you want to enable temporary Staging Table (Y/N)

• Staging Table Name

Configure details

To enhance the performance of inserts and updates in the destination database, enable the Temporary Staging Table option to leverage a temporary staging table during writeback. This is recommended for large payloads of size more than 50,000 records.