In a mapping in SQL ELT mode, you don't have to specify an optimization type. Data Integration pushes the transformation logic by default to the target database.
You can run a mapping in SQL ELT mode to load data from the following data sources to Databricks:
Amazon S3
Databricks
Google Cloud Storage
Microsoft Azure Data Lake Storage Gen2
To create a mapping in SQL ELT mode, you create a
mapping and select
Mapping - SQL ELT
as the mapping type.
Select the cloud ecosystem where you want all the
mapping logic to be processed.
You're then prompted to select the target connection.
The mapping is automatically configured with the target connection you chose.
You can add additional transformations to the mapping. The transformations
available in the transformation palette are transformations that the target
endpoint can process. You can also preview data for individual transformations
to validate the mapping logic.
ASK INFAPreview
