Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Preface
  2. Introduction to Databricks Connector
  3. Connections for Databricks
  4. Mappings for Databricks
  5. Migrating a mapping
  6. SQL ELT with Databricks Connector
  7. Data type reference
  8. Troubleshooting

Databricks Connector

Databricks Connector

Configuring a custom query for the Databricks source object

Configuring a custom query for the Databricks source object

You can push down a custom query to Databricks.
Before you run a task that contains a custom query as the source object, you must set the
Create Temporary View
session property in the mapping task properties.
If you do not set the
Create Temporary View
property, the mapping runs without
SQL ELT optimization
.
Perform the following task to set the property:
  1. In the mapping task, navigate to the
    SQL ELT Optimization
    section on the
    Runtime Options
    tab.
  2. Select
    Create Temporary View
    .
  3. Click
    Finish
    .

0 COMMENTS

We’d like to hear from you!